How to Create Dimensions as Attributes in SpotlightXL

The Dimension as Attributes option is beneficial for models with a large number of dimensions and significant data volumes, as it speeds up processing by decreasing the number of active dimensions.

Part 1 Create Attribute 

1. In SpotlightXL, go to Model > Attribute.
2. Select the desired model and dimension.
3. Enter a name for the Attribute.
4. Enter a following details: 
   1. Member Code
   2. Member Parent
   3. Member Display Label
5. Click Save.
   
   

Part 2 Create DimensionasAttribute 

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 calculations and maps, use the base dimension (which contains leaf members).

1. 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.
2. Define the same dimension as an attribute.
   1. To complete this step, add line in the map with the following selections:
      1. Source Dimension - <DimensionAsAttribute>
      2. Source Filter - <AllMembers>
      3. Source Value - <Base Dimension Name>
      4. Target Dimension - <Attribute name> Attribute name can be user defined and should not be the same as the dimension
      5. Target Filter - <AllMembers> AllMembers is the only filter type supported for DimensionAsAttribute
      6. Target Value - <Base Dimension Name>
         
         

Base dimension is created with leaf member

Attribute is created with all levels and members

Mapping attribute members to dimension leaf members is essential for utilizing the attribute in analysis and reporting.