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

KB41021: Word wrap does not work with metric value in text format in a report running in MicroStrategy Developer 9.x.x-10.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


Word wrap does not work with metric value in text format in a report running in MicroStrategy Developer 9.x.x-10.x

SYMPTOM:
Word wrap does not work with metric value in text format in a report running in Strategy Developer 9.x.x-10.x, as shown below:

ka02R000000kcfkQAA_0EM440000002D7y.jpeg

NOTE: The same report running in Strategy Web works fine with word wrap, as shown below:

ka02R000000kcfkQAA_0EM440000002D7m.jpeg

STEPS TO REPRODUCE:
1 In Strategy Developer, create a metric with value in text format using the following definition:
   

ka02R000000kcfkQAA_0EM440000002Hyx.jpeg

Sample Code/Error
Max(Subcategory@DESC) {~}
2. Go to Menu -> Tools -> Formatting -> Values, under Alignment tab, select 'Yes' for Wrap text, as shown below:
    

ka02R000000kcfkQAA_0EM440000002Hz2.jpeg

3. Save the metric and name it with 'Metric_Value_ in_Text_Format' as an example.
4. Create a report with attribute Subcategory and metric created in the previous step.
5. Right mouse click on the metric -> Formatting -> Metric Values, as shown below:
    

ka02R000000kcfkQAA_0EM440000002Hz7.jpeg

6. In Format Cells window under Alignment tab (same with screenshot in step 2),  select from '<Default>' to 'Yes' for Wrap text. And click on OK to save the change.
7. Go to Menu -> Grid -> Options, under Columns and Rows tab, make sure Wordwrap is check, as shown below:
    

ka02R000000kcfkQAA_0EM440000002HzC.jpeg

8. Save the report and name it with 'Metric Word Wrap' as an example. Run the report in Grid View. Go to Menu -> Grid, uncheck 'Automatic Column Widths', and make sure 'View Column Handles' is checked, as shown below:
   

ka02R000000kcfkQAA_0EM440000002HzH.jpeg

9. Adjust the column width of the attribute and th metric to be about half of the original width. Re-execute the report and get the result as shown in SYMPTOM at the beginning of this technical note.
NOTE: With the following steps to display word wrap in Strategy Web.

  • Run the report in Strategy Web.
  • Right mouse click on the metric -> Advanced formatting, as shown below:
ka02R000000kcfkQAA_0EM440000002D8H.jpeg
  • Make sure the metric and Values are selected, and under Alignment tab, make sure Wrap Text is checked, as shown below:
ka02R000000kcfkQAA_0EM440000002D80.jpeg
  • NOTE: sometimes unchecking and checking on the checkbox are needed to make sure Wrap Text is performed to the formatting.
  • Click on OK to save the change. The report displays as shown in SYMPTOM.

CAUSE:
This is a known issue with Strategy Developer 9.4.x-10.x.
ACTION:
Strategy will continue to investigate and post updates as soon as they are available.
WORKAROUND:
In Developer, go to Menu -> Grid and check 'Automatic Column Widths'.
The Strategy Internal Reference Number for the issue discussed in this technical note is 653788.
 


Comment

0 comments

Details

Knowledge Article

Published:

April 5, 2017

Last Updated:

April 5, 2017