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

KB308150: "The token 'xxx' within the expression has been found in more than one location" error message occurs when trying to add an attribute form expression in Command Manager


Community Admin

• Strategy


"The token 'xxx' within the expression has been found in more than one location" error message occurs when trying to add an attribute form expression in Command Manager 10.x

SUMMARY:
The issue described in this document has been classified as a defect by Strategy.  The issue occurs in Strategy Command Manager 10.x.  A solution/code fix for this issue is not available in current releases, but is being reviewed for a future MicroStartegy release.
 
DESCRIPTION:
When users run the Command Manager script ADD ATTRIBUTEFORMEXP, and the expression contains more than 5 tables, users may see the following error:

ka04W000000Og3HQAS_0EM440000002C0y.jpeg

 


The token 'xxx' within the expression has been found in more than one location.

 
STEPS TO REPRODUCE:

  • Create a copy of the Day attribute called "Copy of Day".
  • Edit the "Copy of Day" attribute, and modify the ID form.
  • Set the table ORDER_DETAIL as the lookup table.
  • Delete the expression DAY_DATE from the ID form, so that the only expression is ORDER_DATE.
ka04W000000Og3HQAS_0EM440000002C0v.jpeg
  • Run the following Command Manager script. The error will appear.
     
    
    ADD ATTRIBUTEFORMEXP "DAY_DATE" MAPPINGMODE MANUAL EXPSOURCETABLES "DAY_CTR_SLS", "MTD_DAY", "PROMOTIONS", "QTD_DAY", "YTD_DAY", "LU_DAY" LOOKUPTABLE "LU_DAY" TO ATTRIBUTEFORM "ID" FOR ATTRIBUTE "Copy of Day" IN FOLDER '\Schema Objects\Attributes\Time' FOR PROJECT 'Strategy Tutorial';

 
CAUSE:
This is an identified defect in Strategy Command Manager 10.x.
 
ACTION:
This issue has been fixed in Strategy 10.4 Hotfix 2 and 10.6.  Upgrade to one of these versions to take advantage of the fix.
 
The Strategy Internal Reference Number for the issue described in this technical note is DE40774.


Comment

0 comments

Details

Knowledge Article

Published:

June 9, 2017

Last Updated:

June 29, 2017