MAP VISUALIZATION IN PAW

How to Enable Map Visualization in PAW?

A Map Visualization gives regular but an intelligent design to the data based on Geographical Template. In order to accomplish the above-mentioned requirement, a Modeler/Analyst needs to take care of certain things while developing the dimension and cube.

To create Map Visualization the view must include a defined geography dimension and this dimension needs to be in the Row axis of the view. There is a limitation of having only 3 measures in the column axis of a view. The geography dimension can be for E.g. Organization/Region/State/Location. The elements which are added in this dimension should be identifiable as geographic entities. There could be cases wherein Location codes are added in the dimension instead of actual names. In such situation, “Map” option will not be populated and we need to enable this option.

Steps: –

Add Element names in the Dimension as Actual names of a Region it could be Cities, States or Countries. If Dimension elements consists of Location codes instead of actual names then create Alias for the respective codes using }ElementAttributes.

• Define the dimension as a geographic dimension for this, locate and open the }DimensionAttributes control cube. At the intersection of the dimension that you want to define as a geography dimension and the Dimension_Type attribute, enter Geography.

Now, Map option would be visible under “Change Visualization”.

Points to Remember: (Map Visualization)?

1. The Planning Analytics Workspace needs to analyse 80% of the elements of the Geographic Dimension as geographic entities in order to generate map in “Change Visualization”.
2. Geographic Dimension should be placed in the Row axis of a View.
3. A Map Visualization can display up to three measures only.
   1. Single-Measure map shades the region based on the measure data values.
   1. A Dual-Measure map shades the region based on the first measure, and for second measure it creates a sized-bubble on the respective region. Sized-Bubble means data value of that second measure for the region will derive the area(size) of the bubble.
   1. A Triple-Measure map shades the region based on the first measure, shows bubbles sized by second measure on each region, and shades those bubbles based on the third measure.