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

KB35146: After changing the Total subtotal function of a metric, the metric dimensionality changes are lost in MicroStrategy Developer 9.4.x-10.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


In MicroStrategy Developer 9.4.x-10.x, users create a new metric, set the level to a certain attribute and remove report level.  They then modify the Total subtotal function of the metric and notice that the attribute in the metric's level has been removed and report level has been added back.

SYMPTOM:
In Strategy Developer 9.4.x-10.x, users create a new metric, set the level to a certain attribute and remove report level.  They then modify the Total subtotal function of the metric and notice that the attribute in the metric's level has been removed and report level has been added back.
 
STEPS TO REPRODUCE:

  • Create a new metric and add a formula such as Sum(Fact)
  • Add an attribute to the level of the metric and remove the report level as shown below
ka02R000000kaVfQAI_0EM440000002DsT.jpeg
  • Go to the Subtotals/Aggregation tab and change the Total subtotal function from Sum to None
ka02R000000kaVfQAI_0EM440000002DsR.jpeg
  • Go back to the Formula tab and click on formula. Notice that the attribute is removed and Report Level is added back as shown
ka02R000000kaVfQAI_0EM440000002DsO.jpeg

 
 
CAUSE:
This is a known issue in Strategy Developer 9.4.x-10.x.
 
ACTION:
Strategy will continue to investigate and post updates as soon as they are available.


Comment

0 comments

Details

Knowledge Article

Published:

April 17, 2017

Last Updated:

April 17, 2017