EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB301289: Error “You do not have Execute access to the Consolidation object ‘XXX'..." is received when executing a Visual Insight dashboard in MicroStrategy Web 10.0 - 10.4


Community Admin

• Strategy


Error “You do not have Execute access to the Consolidation object ‘XXX'..." is received when executing a Visual Insight dashboard in MicroStrategy Web 10.0 - 10.4

SYMPTOM:
Users receive the below error when executing a Visual Insight Dashboard in Strategy Web 10.x.  

ka04W000000OaRLQA0_0EM4400000025Te.jpeg


“(You do not have Execute access to the Consolidation object ‘XXX'.  You do not have "<Project_Name> access to the %2 object '%3'.)"

This is seen by users who were granted access to the dashboard, after the dashboard and consolidation (attribute grouping) had already been created.  Users who had access to this dashboard from its initial creation do not encounter this issue.
 
NOTE: A common scenario that leads to this is when dashboards are created by a user in their My Reports Folder and then moved into the Shared Reports folder. Afterwards, only the user who created the dashboard and Administrator users are able to run the dashboard. Other users who try to run it will receive this error message.
 
STEPS TO REPRODUCE
Follow these steps to reproduce the issue in Strategy Tutorial project.
1. Create 2 users: A and B (B should not have Administrator permissions)
2. Create a report containing the Year attribute.  Both users A and B should have execution permissions.
3. Create a Visual Insight Dashboard with the user A, using this report as dataset.
4. Add the Year attribute to the grid.
5. Right click the attribute and select "Create groups..." to create a new group based on that attribute.

ka04W000000OaRLQA0_0EM4400000025Tg.jpeg

6. Save the new dashboard inside “My reports" folder.
7. Copy this dashboard into the "Shared Reports" folder so that user B now has permissions to use it.
8. With the same user (A), open the Shared Reports Dashboard. Everything works.
9. With other user (B) without Administrator permissions, open the dashboard within the “Shared Reports" folder.  The error is received.
 
CAUSE:
This is an identified defect in Strategy Web 10.0 - 10.4.  It comes from the fact that the attribute groups are managed objects which inherit their access control list from the object they reside in.  In this case it is the document itself.  The defect is when the access control list (ACL) for the dashboard is updated, the access control list for the managed object is not.  This is incorrect behavior, and currently, there is no method to manually update the access control list of these managed objects through Strategy Developer or Web.
ACTION:
This issue has been addressed in Strategy Web 10.4 HF 1 and 10.5. Upgrade to this version to take advantage of this fix.
WORKAROUND:
Ensure the initial dashboard creation is done in a folder all users have access to.  This will ensure the creation of the managed consolidation object gives all future users appropriate access even after moving the dashboard.
KB301289


Comment

0 comments

Details

Knowledge Article

Published:

April 14, 2017

Last Updated:

December 31, 2018