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.