Modeling: Derived Dimension Values on Modeled Sheet Rows
Watch the video:
5m 28sRelease: 2020-09-11
Derived dimension values let you dynamically group data based on user-defined multi-dimensional lookup rules. Dimension values in modeled sheet rows are returned based on your rules.
Derived dimension values help you plan at a high-level with aggregate data, while giving you the flexibility to make adjustments at the individual item level.
You can now use derived dimension values to dynamically group data based on user-defined, multi-dimensional lookup rules. This enables you to analyze possible impacts when planning key performance indicators based on new groupings. To save you time and effort, we also populate the derived dimension values on modeled sheets based on the rules you configure.
Small but Noteworthy
Release: 2020-09-11
Update for sales planning customers that use derived dimensions.
- Search in dimension mapping tables on dashboards.
- Dimension mapping tables react to perspective context filters.
- Move mapping values between rows in your dimension mapping table.
- Derived dimensions can now be secured with access rules.
- Import and export dimension mapping rules and download the template.