Design Manager
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Design Manager

  • Dark
    Light
  • PDF

Article summary

Design Manager provides advanced reporting capabilities, allowing for detailed data intersections and the selection of dimension members from multiple models. It also enables you to choose Point of View (POV) options. 

How to Use the Design Manager?

  1. In SpotlightXL, Go to Report > Design.
  2. Select the desired cell and click Design Manager to view the current dimension and member. 
  3. You can change the dimension value by clicking the member select icon, selecting a new value, and then click Update. All row and column dimensions and members are treated as "member" cells. See Identifying POV Dimensions for more information.

The cell is referred to as a "data" cell. Data cells represent data intersections, which are formed from the intersection of all dimensions in the model. If you select a new value for any of the dimensions, the data cell is automatically updated based on selections once you click the Update button on the Design Manager interface.

Select a blank cell and click Design Manager. Notice how the interface is updated to give you the option to create a data cell, dimension member cell, or POV cell.

You can also report off of any one model or multiple models available to you in the Model list box. 

Description of Fields

Data - Data Intersection

Report on the combination of two or more dimension members. Select members from a dimension intersection to populate the value within the report. You can pull data from an intersection for any model to which you have access. When Data is selected, the Model list box is available along with the dimensions that belong to the selected model as shown below.

You can select to exclude point of view (POV) dimensions in reports. For example, if your report has a page-level member for Company (My Cycles Company) and you want to show one cell of Total Corporate (My Holding Group) as a comparison, you can add the Total Corporate cell and exclude (or override) the Company POV for that cell.

Member - Dimension Member

Display a specific member name from a dimension. This replaces the cell with the name of the selected dimension member. When Member is selected, the Model and Dimension list boxes are available. Select the model from which you want to populate the report with dimension member information. Select the dimension that belongs to the selected model to populate your report.

When using POV and substitution variables, the member names will change based on the selected context.

ModelingImages301to350image342.png

POV - Option to Update Report Data

Make POV (point of view) selections based on a model and dimension. A POV is a method to allows users to select a particular member from a list box and then see all data in the report updated for that member. For example, if you want the user to be able to view different accounts, then put the Account dimension on the page level of the report, and make it a POV cell. As a result, data displayed in the report is controlled to display the selected Account dimension member. When POV is selected, the Model and Dimension list boxes are available.

ModelingImages301to350image343.png

Attributes

Select this checkbox to display the attributes that are available in the selected model. Uncheck this checkbox to hide the attributes from the Design Manager.

ModelingImagesimage39.png

Filtering Members

Filtering member options is helpful when updating an existing report, finding specific report dimension members, and previewing members you might filter. 

Filter Member

How to Use Filter Member Option in the Design Manager?

  1. Open a report in design mode by selecting the Report > Design.
  2. Select the entire spreadsheet and click Design Manager.
  3. Select a dimension member and select Filter Member.

Preview Filter Member

How to Use Preview Filter Member Option in the Design Manager?

  Filter Member:

  1. Open a report in design mode by selecting the Report > Design
  2. Select the entire spreadsheet and click Design Manager
  3. Select a dimension member you want to preview before filtering. 

The result is that the cell range is displayed as shown below. This way you know exactly where the member exists within the report.


Was this article helpful?

What's Next