Add Dimension Mapping Tables in Dashboards
- Security:Access Dashboardspermission.
Dimension mapping tables enable dashboard users to set up the dimension mapping rules. Dimension mapping rules are the logic that auto-populates the derived dimension values in modeled sheets.
Terms we use:
- Derived dimension values: The dimension value that auto-populates on sheets.
- Mapping dimension values: The dimension values that users select in sheets to trigger the auto-population of the derived dimension value.
- Dimension mapping rules: The logic that maps the mapping dimension values to the derived dimension values.
- Dimension mapping: The process of creating dimension mapping rules through dashboards or through dimension imports.
You can add the table for the same derived dimension to different dashboards. Any updates you, or anyone makes to the tables, persists to all tables. When you import new or updated rules, all the tables automatically update with the new changes.
- SelectDashboardsfrom the main menu.
- Open a perspective.
- From the toolbar, clickEdit.
- From theChartspanel, dragDimension Mappinginto the canvas.
- In theGeneral Appearance Settings, enter a name for the mapping chart.
- To open the data settings, click theDataicon.
- From theDimensiondrop-down prompt, select a dimension to use for dimension mapping.Only dimensions that have theUse mapping criteria to set dimension value on modeled sheetssetting enabled display in the list.
The mapping chart pre-fills with columns for:
- Levels. Levels are required.
- The mapping dimensions.
- The derived dimension.
The derived dimension is Job Seniority. The two mapping dimensions are Job Title and Job Code.
When you create the chart, select Job Seniority in the
Data
settings. Then, Job Title
and Job Code
automatically display after Levels
in the chart. You can’t add mapping rules in edit mode.
Level | Job Tile | Job Code | Job Seniority |
|---|---|---|---|