The Dimension Attribute Browser uses the same interface as the Dimension Browser and has the same icons. Attributes are indented under the dimension that they are associated with.

Click the attribute from the Model box or from the Model Artifacts Browser to open the Dimension Browser. The dimensions are listed on the left, attributes indented under them, and the members appear on the right in the Member Pane.

Click the attribute name. The hierarchies and members in the Members Pane can be expanded and collapsed with an icon. The selected member's properties appear in the Member Properties panel.

Dimension Attribute Browser for a Generated and Unlocked Model

Icons that are available to perform actions include Refresh, Add Member, Delete Member, Save, and New Attribute.

On existing attribute members, you can update the Display Label. You can also move the attribute member to a different parent by dragging and dropping it.

You can add new members to an attribute hierarchy.

You can select an attribute member and delete it.

Dimension Attribute Browser for a Generated and Locked Model

Icons that are available to perform actions include Refresh, Add Member, Delete Member, Save, and New Attribute.

On existing attribute members, you can update the Display Label. You can also move the attribute member to a different parent by dragging and dropping it.

You can add new members to an attribute hierarchy.

You can select an attribute member and delete it.

If you have made changes only to attribute members, then when you click Save, a message tells you that your changes have been saved.

Dimension Attribute Browser for an Ungenerated Model

Icons that are available to perform actions include Refresh, Add Member, Delete Member, Save, and New Attribute.

On existing attribute members, you can update the Display Label. You can also move the attribute member to a different parent by dragging and dropping it.

You can add new attribute members to an attribute hierarchy.

You can select an attribute member and delete it.

When you click Save, your changes are saved immediately. Because there is no data in the model, there is no delay in saving the changes.

Adding Attributes

Power and Contributor users can add new attributes and attribute members to any model.

How to Add a New Attribute to the Model?

In Spotlight Web, navigate to Dynamic Planning > Model.
From a Model Box, click the Dimensions or Attributes artifact. Select a dimension to open the Dimension Attribute Browser.
Select the dimension that the attribute will be associated with.
Click +New Attribute.
Type the name of the new attribute.
If the attribute you added will have children, then toggle Enable Dimension Leaf Members on. This makes it possible for the attribute and its members to be visible in views and reports.
Click the Save icon.
Select the Attribute that now appears under the dimension. You see that the attribute was added but it has no members yet.
Click the + icon to add members.
Type the name of the new attribute member.
Click Add.
Continue until you have added all the attribute members.
Optionally click each attribute member and customize the Display Label for each.
Click Save.
The attributes are now ready to be mapped to dimension members.

Mapping Attributes to Dimension Members

Once you have created a new attribute and added members to it, you are ready to map the attributes to your dimensions.

How to Map Attributes to Dimension Members?

In Spotlight Web, navigate to Dynamic Planning > Model.
From a Model Box, click the Dimensions or Attributes artifact. Select a dimension to open the Dimension Attribute Browser.
Select the dimension that the attribute appears under.
Click a dimension member to map to an attribute.
In the Member Properties panel, see the Attributes Mapping section.
Click the down arrow icon to display a list box of attribute members.
Click the attribute member to map to the dimension member.
Continue until you have mapped the desired dimension members to attributes.
Click Save.

Was this article helpful?

What's Next

Running and Filtering Calculations

Table of contents

Using the Dimension Attribute Browser