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

KB41487: "Cannot add metric to report because of insufficient accessibility to the metric or its dependents" error occurs when trying to add a metric to a subset report based off an freeform SQL Intelligent Cube in MicroStrategy Developer 9.x.


Stefan Zepeda

Salesforce Solutions Architect • Strategy


"Cannot add metric to report because of insufficient accessibility to the metric or its dependents" error occurs when trying to add a metric to a subset report based off an freeform SQL Intelligent Cube in MicroStrategy Developer 9.x

SYMPTOM:
 
Consider that an Intelligent Cube was created from a freeform SQL (FFSQL) report in Strategy Developer 9.x. For a subset report based off such a cube, when adding a metric to the report, the following error occurs:
 

ka02R000000kX0TQAU_0EM440000002D3i.png

Sample Code/Error
Cannot add metric <metric_name> to report because of insufficient accessibility to the metric or its dependents.
  
CAUSE:
 
Since the Intelligent Cube is based off a FFSQL report, the columns in the metrics being used are managed objects. Strategy Developer 9.x checks for 'Execute' access to the managed column object being used in the metric when adding it to the report, which is not required for regular non-mnanaged metrics.
 
This is a known issue with Strategy Developer 9.x.
 
ACTION:
 
Strategy will continue to investigate and post updates as soon as they are available.
 
WORKAROUND:
 
Use Strategy Web to add the metric to the subset report. Alternatively, granting the user adding the metric 'Bypass all objects security access check' privilege allows the user to add the metric from Strategy Developer 9.x.
 


Comment

0 comments

Details

Knowledge Article

Published:

April 12, 2017

Last Updated:

April 12, 2017