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

KB46186: Validating an expression in the consolidation editor changes the expression


Community Admin

• Strategy


After validating an expression in the consolidation editor a user may see the the expression change.  Specifically, this has been seen in situations where there are three or more attribute elements within a set of parentheses, the expression changes using the following pattern.

SYMPTOM:
After validating an expression in the consolidation editor a user may see the the expression change.  Specifically, this has been seen in situations where there are three or more attribute elements within a set of parentheses, the expression changes using the following pattern.


x/(n+n+n+...+n)

After validation the expression changes to:

x/(n+n)/(n)/(n)/...?(n)

 
STEPS TO REPRODUCE:
Follow the steps to reproduce in Strategy Tutorial:

  • Create a new consolidation using the expression below:
ka04W000000uGBUQA2_0EM440000002CSV.jpeg
  •   


    
    (({Month=Jan 2010} + {Month=Feb 2010} + {Month=Mar 2010}) - ({Month=Jan 2011} + {Month=Feb 2011} + {Month=Mar 2011}))/({Month=Jan 2012} + {Month=Feb 2012} + {Month=Mar 2012})
    
    



  • Click Validate.  The equation will change to the following:
ka04W000000uGBUQA2_0EM440000002CSM.jpeg
  •   


    
    (((({Month=Jan 2010}  +  {Month=Feb 2010})  +  {Month=Mar 2010})  -  ({Month=Jan 2011}  +  {Month=Feb 2011})  -  ({Month=Mar 2011}))  /  ({Month=Jan 2012}  +  {Month=Feb 2012})  /  ({Month=Mar 2012}))
    



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


Comment

0 comments

Details

Knowledge Article

Published:

May 29, 2017

Last Updated:

December 31, 2018