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

KB288645: Changing the Dynamic Aggregation Function more than once does not save in MicroStrategy Web 10


Community Admin

• Strategy


SYMPTOM:
When creating metrics, users can define the Dynamic Aggregation function that will be used for the rollup of metric values that occurs when an attribute is moved from the report grid to the Report Objects panel.
Note: For more information on dynamic aggregation, including details on using dynamic aggregation to analyze data, see the In-memory Analytics Guide. 
However, in Strategy Web 10.1, after saving the Dynamic Aggregation function once, editing the metric and changing it twice, the change will not get saved.
Consider the example below where the Dynamic Aggregation was initially set to Average:

ka04W000000OeB8QAK_0EM4400000025UJ.jpeg

 
After changing the Dynamic Aggregation to Sum, and saving it, the aggregation stays as Average.
 
STEPS TO REPRODUCE:

  1. Create a new metric in Strategy Web 10.
  2. Click the "Switch to Formula Editor" button at the bottom of the editor.
  3. Set the formula to be "cost + revenue".
  4. Click on Metric Options, as shown in the image above.
  5. Set the dynamic aggregation function to Average.
  6. Save the metric.
  7. Re-open the metric.
  8. Change the dynamic aggregation function to Sum.
  9. Save the metric.
  10. Re-open the metric and notice the change was not saved and the modification time is not updated.

 
CAUSE:
This is an identified defect in Strategy Web 10.
 
ACTION:
This issue has been addressed in Strategy Web 10.4. Upgrade to this version to take advantage of this fix.
 
WORKAROUND:
Perform a Save As instead of Save and the changes will be kept.
 
The Strategy Internal Reference Number for the issue discussed in this technical note is DE27326.


Comment

0 comments

Details

Knowledge Article

Published:

June 13, 2017

Last Updated:

June 13, 2017