- 1 Minute to read
- Print
- DarkLight
- PDF
How to Create Dimensions as Attributes in SpotlightXL
- 1 Minute to read
- Print
- DarkLight
- PDF
In Dynamic Planning, you have the option to designate dimensions as attributes when transferring metadata from Structured Planning, Consolidation, and Reporting applications. This approach enhances performance and supports analysis without requiring all dimensions to be active in Dynamic Planning. This is particularly beneficial for models with extensive dimensions and large data volumes, where reducing the number of active dimensions improves processing times.
Step:1 Create Attribute
- In SpotlightXL, go to Model > Attribute.
- Select the required model.
- Enter a name for the Attribute.
- Enter a following details:
- Member Code
- Member Parent
- Member Display Label
- Click Save.
To create a dimension as an attribute you must define 2 lines your map (as shown below). Defining these two lines in the map creates a base dimension with leaf members as well as an attribute with all members (including rollups). For reporting and analysis purposes, use the Department attribute (which contains all members). For calculations and maps, use the base dimension (which contains leaf members).
Step:2 Create DimensionasAttribute
- Define the dimension you want to create as an attribute with a source and target filter set to LeafMembers. Defining this line in this way in the map ensures that the dimension is created with all leaf members.
- Define the same dimension as an attribute.
- To complete this step, add line in the map with the following selections:
- Source Dimension - <DimensionAsAttribute>
- Source Filter - <AllMembers>
- Source Value - <Base Dimension Name>
- Target Dimension - <Attribute name> Attribute name can be user defined and should not be the same as the dimension
- Target Filter - <AllMembers> AllMembers is the only filter type supported for DimensionAsAttribute
- Target Value - <Base Dimension Name>
- To complete this step, add line in the map with the following selections:
When you map a dimension as an attribute, it creates a base dimension with leaf members, then it creates the attribute with all members including rollup members, and then it maps the base dimension members with attribute members.
Base dimension is created with all leaf members
Attribute is created with all levels and members
Mapping between attribute members and dimension leaf members is complete so that the attribute can be used for analysis and reporting