- 2 Minutes to read
- Print
- DarkLight
- PDF
Support for Structured Planning Cube Default Members for Dimensions in New Views, Formatted Reports, and Excel Reports
- 2 Minutes to read
- Print
- DarkLight
- PDF
Dynamic Planning respects the Structured Planning default members according to workforce dimensions in new views, formatted reports, and Excel reports. For example, if 2024 is set as the default for the Time dimension, it will be reflected in Default and New Views, as well as in new cells in reports.
Note:
This functionality is applicable to models with Direct Access to Structured Planning, not Master models with traditional Structured Planning integration. It is supported in both Spotlight Web and SpotlightXL, but in Excel Reports, this feature is available only in SpotlightXL.
Creating Default Members
Log in to Structured Planning.
Go to Maintenance > Reports > Cube Settings > Default Members.
Set the Reporting Area to Workforce.
For each dimension, select a default member to be displayed in Structured Planning reports and new views in Dynamic Planning.
Using Default Members in a View on the Web
Log in to Spotlight Web.
Navigate to Dynamic Planning > Analyze.
Select the workforce model and click Default view from the drop-down menu.
In the Default view, the dimensions will display their default members, while other dimensions will show their root members.
Note:
Default members do not restrict the visibility of the entire dimension. Clicking on a dimension member will still allow access to the rest of the dimension.
Using Default Members in a Report
When creating a formatted report, users typically start with a view and then convert it into a report. In this process, all dimensions and members are selected in the view before conversion. However, the Report Design includes functionality to view the default members when creating a new cell, as described below.
Log in to SpotlightXL.
Go to Analyze > Data, and select a workforce model.
Set up the view as needed and save it.
Select Data > Design With > Report.
This opens the Report tab with the view and comments on each cell.Click on any blank cell and then select Design Manager. The dimensions will have their default members selected by default for a Data cell.
To change a member, select one of the dimensions on the row or column axis. The default member is automatically selected, but users can use the member select icon to choose another member. For example, if the Scenario is on the column axis, the 2025 Forecast is selected by default.
Similarly, if POV is selected and a dimension is chosen, the default member will be selected. Users can use the member select icon to choose another member. For example, if CompensationItem is a POV dimension, All is selected by default.
Dimension Member Visibility
Default members do not restrict access to the rest of the dimension. Clicking on a dimension member allows access to other members of the dimension.