How to Filter Members Using Design Manager
  • 2 Minutes to read
  • Dark
    Light
  • PDF

How to Filter Members Using Design Manager

  • Dark
    Light
  • PDF

Article summary

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

  1. Filter Member
  2. Preview Filter Member

Filter Member

To use Filter Member, open a report in design mode by selecting the Report task and the Design subtask.

Select the entire spreadsheet as shown below and click Design Manager.

ModelingImagesimage79.png

Select a dimension member to filter. In this case Jan 17 is selected (show below).

ModelingImagesimage801.png

Now, select Filter Member as shown below.

ModelingImagesimage811.png

The result is that the Jan 17 member filtered is selected in the design manager and is also highlighted within the spreadsheet as shown below.

ModelingImagesimage821.png

If you would like to make any changes to the report and you want to select only a specific member from the report design and then make the change, in this example Jan-17 this new ‘Filter Member’ option will be beneficial.

Preview Filter Member

To use Preview Filter Member, open a report in design mode by selecting the Report task and the Design subtask. Select the entire spreadsheet and click Design Manager. Select a dimension member you want to preview before filtering. In this case, the Temp Mountain Bikes is selected along with the Preview Filter Member option as shown below.

ModelingImagesimage831.png

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

ModelingImagesimage841.png

Use Case

This use case steps you through the process of selecting the Data and Member Design Manager options to populate values within a report.

In the use case below, DecisionWorks (a fictional company) has a FinanceMaster model. A report named Golf Product Report is saved to FinanceMaster. The CFO wants to see how the Golf product line has performed over the past two years by comparing the data in this report with data from 2012 within the same report.

Golf Product Report

ModelingImages301to350image345.png

Perform the following steps to add a new data intersection to report on income from 2012:

  1. Select the blank cell (B17) below the 2014 data.
  2. Click Design Manager.
  3. Select Data.
  4. Select FinanceMaster as the model. The model
  5. the report is saved to populates the list box by default.
  6. Select Golf for Product.
  7. Select 2012 for Time. The data intersection in this case is where Golf intersects with 2012.
  8. Click Update.
  9. Format the cell as needed. For example, currency with no decimals.
  10. Click Save.
  11. Select the Run subtask. The result is displayed as shown below.

ModelingImages301to350image346.png

Next, add the Golf 2012 time dimension member to the report.

  1. Select the Design subtask.
  2. Select on the empty cell (A17) to the left of the cell you just populated with data.
  3. Click Design Manager.
  4. Select Member.
  5. The FinanceMaster model is selected by default.
  6. Select the Time dimension from the Dimension list box.
  7. Click the search box and select 2012.
  8. Click Update.
  9. Save the report.
  10. Select the Run subtask. The result is displayed below. You can format the report by adding background color, interesting rows, and so on.

ModelingImages301to350image347.png

Create a Report with a Filtered Dimension from Multiple Models

Note:
This is applicable for worksheet-based filters only.

You can filter dimensions when defining a report that pulls data from multiple models.

The image below shows a report that pulls data from multiple models. To view different dimensional data, select the 2014 Budget list box. Select the dimension and the report is instantly updated.

ModelingImages451to500471.jpg


Was this article helpful?