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

KB441130 : The Metric Name with underscore is not displaying underscore as Column Alias in SQL statement in MicroStrategy 10.x and 11.x


Ji-Hyun (Jenna) Kim

Senior Cloud Support Engineer III • MicroStrategy


The Metric Column Alias which has underscore in name could not be used underscore in SQL statement in MicroStrategy 10.x and 11.x

SYMPTOM
Customer may want to use Metric Name with underscore(_) in it but underscore could not be used as Column Alias in SQL statement in Strategy 10.x and 11.x
STEP TO REPRODUCE
1. Create a Metric Name with underscore(_) like "Underscore_Alias" as shown below image :

ka04W000001Ir88QAC_0EM44000000WUfg.png

2, Create a Report as shown below image:

ka04W000001Ir88QAC_0EM44000000WUfl.png

3. Set VLDB "Default to Metric Name" option to "Use the metric name as the default metric column alias" as shown below image:

ka04W000001Ir88QAC_0EM44000000WUfv.png

4. Check the SQL statement Column Alias "Underscore_Alias" shown as 'UnderscoreAlias" as shown below image:

ka04W000001Ir88QAC_0EM44000000WUg0.png

CAUSE
This is an identified defect in Strategy 10.x and 11.x
ACTION
It is currently not feasible to address this defect in the product and we have no plan to fix it in the near future.
Article Reference Number : KB441130


Comment

0 comments

Details

Knowledge Article

Published:

September 10, 2018

Last Updated:

September 10, 2018