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

KB8671: How to replace English autostyles with double-byte autostyles in Microstrategy Developer


Stefan Zepeda

Salesforce Solutions Architect • Strategy


How to replace English autostyles with double-byte autostyles in Microstrategy Developer

SYMPTOM:
Consider the following example: A double-byte operating system is used with Simplified Chinese Windows 2000. When a project is created in English, or another single-byte interface, all autostyles, such as "Accounting" or "Agent", have single-byte fonts. Even though these single-byte fonts used in the autostyles can't display Chinese characters, the warehouse contains Chinese characters and they are displayed correctly with these single-byte autostyles. This is due to the fact that Strategy Desktop overwrites autostyle fonts with Desktop Preferences settings. If operating system is Chinese, the installation sets the following values in Desktop Preferences -> International -> Default character as follows:
 

  • "Override the default grid character set" is enabled
  • "Select the character set to be used in the grid" is set to "CHINESE_GB2312" (Simplified Chinese codepage)
  • "Select the font to be used in the grid" is set to "SimSun"

However, once the report is exported to Portable Document Format (PDF) with a Simplified Chinese version, all Chinese characters are missing.
 
CAUSE:
The PDF picks up the embedded fonts in the associated autostyle.
 
ACTION:
To export to PDF without recreating the project, users can take advantage of the "Find and Replace" feature available in Strategy Desktop 7i - 7.2.3 and newer. This feature can be used to do a mass replace of the autostyles that are applied to the reports in the double-byte project.
 

  • Create a dummy report by adding an attribute and metric to create custom autostyle.
  • Right mouse click (RMC) on an attribute and select "Formatting > Row Axis > Headers". In the formatting editor, select the Simplified Chinese font. Repeat the preceding step and RMC on the same attribute and select "Formatting > Row Axis > Values".
  • RMC on the "Metric" in the template and select "Formatting > All Metrics > Headers". In the formatting editor, select the Simplified Chinese font. Repeat the preceding step and RMC on "Metric" and select "Formatting > All Metrics > Data".
  • Access the Grid option in the menu and select "Save Autostyle".
  • Access Tools option on the Strategy Desktop menu and select "Find and Replace".
    • Select the default "Autostyle"
    • Check the radio button for "Apply to all reports and templates". Then, click the "Update Summary" button which will display all reports and templates in the window to the right, as shown in the screen shot below:
       
ka02R000000kYPEQA2_0EM440000002G6K.jpeg
    • In the "Replace with" pane, select the autostyle created in the preceding Step #4.
  • Click "Replace" button under the summary list of reports.

NOTE:
If a user prefers to use different autostyles such as "Accounting" or "Agent", then each custom autostyle needs to be created and replaced separately. Furthermore, if the template was used to create all or most of reports in the project, it may be easier to replace the template by creating a custom template instead of an autostyle.
 


Comment

0 comments

Details

Knowledge Article

Published:

June 8, 2017

Last Updated:

June 8, 2017