Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Item
Technique
Dimension Names Brute force - Edit dimension name.
Measures and Calculated Fields Brute force - Edit alias.  Note: The alias title is displayed so if multiple calculated fields need to be displayed with the same name, append a space (or 2 or 3...) to it.
Tool TipsCan use Calculated field works using same technique as Worksheet Titles.  Will be time consuming, but only done once.  We should minimize these.
Axis Titles

Brute force - right click on axis, Edit Axis, Update Title field. 

Worksheet Titles

 On  Calculated field works.  On worksheet do the following:

  1. Create Custom Calculated Field - example below.  Name it "Label - Title -" and then the string it contains.
    case [Language]   
        when "en" then "Health Units Visited and Data Reported"   
        when "pt" then "pHealth Units Visited and Data Reported"    Portugues version of above"
        else "Health Units Visited and Data Reported"
     end
  2. Drag the field created above onto the tooltip button in the Marks tray.
  3. Right click on it deselect "Include in tooltip"
  4. Edit the sheet title and insert the ATTR() for the field created above.
Row Titles

Same Calculated field works using same general technique as Worksheet Titles.  Except naming convention is "Label - Row -" and you drag the custom field to the Rows tray.

Dashboard Titles & TextBrute force - simply edit them.  This includes any static fields on the any dashboard (headers, footers, etc.)
 Legends

Two techniques depending how the data we're graphing is created.

  1. Brute force - right click and edit alias.
  2. Modify calculated field - The Delivery Intervals graphs creates names that it then counts.  This formula could be modified for both languages using the same technique as Worksheet Titles. 
 FiltersBrute force.  Right click - Edit Title.
Specific Fields

There are a few fields that use calculations to determine the string that presented.  These need to be edited to include the language logic:

  1. FacilityVisitsReportDS
    1. Visit Interval 
  2. Refrigerator Data Source:
    1. Current Problem
    2. Problem Between Visits