Find the model you previously created that has direct access to PCR. For example, a model named Products 2020. There are two quick steps to add the PCR attributes and alternate hierarchies to the model: Clear Model, then Generate Model. You can do those steps manually or another option is to run the default calculation that was created automatically when you created the model.

In SpotlightXL , go to Model > Setup and select the model name from the Model drop-down. You see the list of dimensions but no attributes or other hierarchies. The model is generated and locked.
Click Clear Model.
Click Generate Model. The list of dimensions, attributes, and alternate hierarchies appears on the Model Setup screen, and they are now available for your use.

You can view attributes and attribute hierarchies from Model, Attribute. You can view alternate hierarchies from Analyze and Report.

Here is the same procedure in Spotlight on the web.

In Spotlight Web, navigate to Dynamic Planning > Model.
In Model Manager, locate the model from the grid or list view. Notice that there are Dimension artifacts but no Attribute artifacts yet.
Click the More menu, then select Clear Model. The icon next to the model changes to an incomplete circle.
From the More menu, select Generate Model. The screen refreshes and shows the model locked again. Now you have both dimension and attribute artifacts.

Note:

Another way to achieve the same goal is to run the default calculation which was created with your direct access model. The calculation is named <model-name> Refresh and it contains the commands to refresh the model. By refreshing the model, the attributes, attribute hierarchies, and alternate hierarchies are automatically added to the model. To run the calculation, go to Model, Calculation, locate the calculation, and click Run.

Viewing Attributes, Attribute Hierarchies, or Alternate Hierarchies in SpotlightXL Model Setup

In SpotlightXL, to see the PCR dimensions, attributes, attribute hierarchies, and alternate hierarchies, go to Model, Setup. Select the model from the Model drop-down.

How to View Attributes, Attribute Hierarchies, or Alternate Hierarchies in Spotlight Model Manager?

In Spotlight Model Manager, to see the PCR dimensions, attributes, attribute hierarchies, and alternate hierarchies, go to the grid or list layout view.

In Spotlight Web, navigate to Dynamic Planning > Model.
Select the model or model box.
On the More menu, select Model Artifacts.
Click Attributes to see the list of attributes and the dimension they are associated with.
Close the Artifact Browser and click Dimensions from the main layout screen to see the list of dimensions, alternate hierarchies, and attributes.

Support for Attribute Default in Direct Access to PCR Models

Direct Access to PCR models include support for views and reports that include the Attribute Default member of an Attribute dimension. This special member is used to denote members of the base dimension that have not been mapped to an attribute in an Attribute dimension. For example, if a dimension has 100 members, 80 of which are mapped to attributes, the remaining 20 members will automatically be associated with Attribute Default. You see Attribute Default whenever you expand an attribute dimension or look up an attribute in a member selection box.

Was this article helpful?

What's Next

Support for PCR Substitution Variables and Derived Variables

Table of contents

Support for PCR Attributes, Attribute Hierarchies, and Alternate Hierarchies
Support for Attribute Default in Direct Access to PCR Models