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

KB308057: Metric does not display currency symbol after the number in Microstrategy 10


Community Admin

• Strategy


SYMPTOM
When "Data type" of the fact is set to "Big Decimal", the metric based on its fact will not display a symbol of currency after the number.
 
STEPS TO REPRODUCE:
1. Copy the fact "Revenue" and modify it to use data type "Big Decimal" instead of decimal, as per screenshots below:

ka04W000000OffFQAS_0EM4400000029A5.jpeg

 

ka04W000000OffFQAS_0EM4400000029A3.jpeg

 
2. Create new metric called "Custom Revenue" using modified fact "Copy of Revenue" as below:

ka04W000000OffFQAS_0EM4400000029A8.jpeg

3. Format the metric to display currency after the number as shown below:

ka04W000000OffFQAS_0EM4400000029A4.jpeg

4. Create a report using the "Custom Revenue" and check the display as below:

ka04W000000OffFQAS_0EM4400000029A6.jpeg

 
5. Change the display of the currency to be before the number. This works.
 
CAUSE
This is an identified defect in Strategy 10
 
ACTION
This issue will be addressed in the next Strategy releases 10.11 and 10.4 Hotfix 7, tentatively scheduled to come out during Q1 2018. Upgrade to this version to take advantage of the fix.


Comment

0 comments

Details

Knowledge Article

Published:

June 7, 2017

Last Updated:

February 13, 2018