How to Define the Structure of a Model?

1 Minute to read

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

In SpotlightXL, select the Model task and the Setup subtask.
In the Model Value field, select the model you want to edit, or select New Model and enter a name for the new model.
In the Type Value field, select Master or Analytic. The Master model represents model data pulled from the Planful Financial Cube and is the starting point for creating additional models. An Analytic model represents a sub-model that can be used for analysis or Dynamic Planning purposes.
Enable Change Data Tracking is an optional feature that marks leaf-level data as dirty whenever it is changed, such as through user input, calculations, or data load. When the next full aggregation (Aggregation, None) is performed, only the rollups with dirty leaf-level data are aggregated. This makes full aggregations faster.
Select Yes to Enable Direct Access to PCR to connect directly to the Financial Reporting Area of PCR (Structured Planning, Consolidation, and Reporting).
Created On, Created By, Modified On, and Modified By fields are populated automatically by the system when you save the model. Do not enter data in these fields. Any data entered will be replaced with system data when the model is saved.
The Status field is system-populated based on the actions you perform. A Generated model cannot be deleted. Clear the generated model by clicking Clear Model and then delete the model. Only generated models are available for analyzing and reporting. Do not enter data in this field. Any data entered will be replaced with system data.
Under the Dimension header, enter dimensions to include in the model.
Under Type, select the cell to enable a list box where you can choose between two types of dimensions; Value and Key. You MUST have at least one Key and one Value dimension to generate a model. A Key dimension type will most likely change, unlike a Value dimension (for example, Time) that does not normally change. The very first cell under Type provides a list box when the cell is selected. For subsequent cells, type in a value or copy and paste the list box cell to add new types.
Click Save. Notice that the Created On, Created By, Modified On, and Modified By fields are populated automatically after the first time you save a new model. For Status, Not Generated is displayed. Design and Value fields are populated beneath the model’s dimensions. A description of the data you might see under the Design and Value fields (which are read-only and cannot be modified) follows:

Was this article helpful?

What's Next

How to Create a Staging Model?