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

KB34111: Column aliases generated by the attribute editor remains outdated after the attribute form expression is updated in MicroStrategy Developer 9.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


This technical note describes an issue in which column aliases do not reflect the new column name when the expression is defiend with a RTrim or LTrim function in MicroStrategy Developer 9.x.

SYMPTOM:
Column aliases do not reflect the new column name when the expression is defiend with a RTrim or LTrim function in Strategy Developer 9.x.
 
STEPS TO REPRODUCE:
Execute the following in Strategy Tutorial:
 

  • Create a new attribute with a form expression of RTrim().
ka02R000000kY20QAE_0EM440000002DzH.jpeg
  • Check the column alias and confirm that CALL_CTR_ID is used. Save and close.
ka02R000000kY20QAE_0EM440000002DzG.jpeg
  • Re-open the attribute editor and change the expression to RTrim().  Save and close.
ka02R000000kY20QAE_0EM440000002DzE.jpeg
  • Open the attribute to check the column alias for the form edited and notice CALL_CTR_ID is still used.
ka02R000000kY20QAE_0EM440000002DzF.jpeg

 
CAUSE:
This is a known limitation of Strategy Developer 9.x. When the expression is defined with the column name without any function, the column alias gets updated with the new column name.
 
ACTION:
Edit the column alias and specify the name as need be. For more information about options for column aliases, refer to the following Technical Note:
 
KB4371 - How to select or modify the column data type for an attribute or fact in Strategy Architect 9.x and 10.x
 


Comment

0 comments

Details

Knowledge Article

Published:

June 12, 2017

Last Updated:

June 12, 2017