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

KB15067: After drilling, metric values on a child report do not add up to the values for that metric on the parent report in MicroStrategy Developer


Stefan Zepeda

Salesforce Solutions Architect • Strategy


A user drills down on an attribute to generate a child report. The metric values between the parent report and the child report do not add up correctly in MicroStrategy Developer.

SYMPTOM:
A user drills down on an attribute to generate a child report. The metric values between the parent report and the child report do not add up correctly in Strategy Developer.
 
CAUSE:
The metric on the parent report may be embedded and the actual metric has since been altered. The child report will use the altered metric definition while the parent report will use the embedded metric definition. This may cause the metric values to be different depending on the nature of the changes.
 
ACTION:
To confirm that a metric is embedded, right-click the metric in the parent report and choose 'Properties.' The location for the metric will read 'Object is embedded in' if the metric is embedded.
 
If the metric is embedded, follow the steps below to correct the issue:
 

  1. In the parent report, remove the metric from the report.
  2. Add the metric back into the report.
  3. Go to Data > Report Data Options > General > Advanced, and check the option to Retain the Original Objects when prompting the report.
  4. Save and execute the report.
  5. Drill on the report to create the child report.

Comment

0 comments

Details

Knowledge Article

Published:

June 2, 2017

Last Updated:

June 2, 2017