Tag Custom Dimension Values with Attribute Values
- Security:Model includes sheets, accounts, dimensions and formulaspermission.
Dimension attributes group data associated with dimensions differently than the dimension hierarchy. You can achieve this result by tagging dimension values with attribute values.
Example: T-Shirts, Jackets, and Jeans are Product dimension values. They roll up to the Product dimension. To group the values associated with the products, you create an attribute called, Product Group, with a value called, Tops. When you tag T-Shirts and Jackets with Tops, all data associated T-Shirts and Jackets is also associated with Tops automatically. Referencing or reporting on Tops pulls the aggregate values of both T-Shirts and Jackets across the model, providing an alternate rollup for the products.
- SelectModelingfrom the main menu.
- ClickDimensions.
- From the list of dimensions, expand the dimension with the value that you want to tag.
- From the list of values, select the dimension value that you want to tag.
- Expand theDimension Attributessection in theDetailarea.All related attributes have prompts in this section.
- From the attribute prompts, select the value that you want to tag to the dimension value.
- Save.