Find Specific Dimensions or Measures

You can search the current report or cube to find specific dimensions or measures in your data. Finding specific items in highly complex and large dimensions can significantly speed up your analysis time.

When you search the current report, PowerPlay Web searches the data in the current display. When you search the cube, PowerPlay Web searches all the data in the cube.

You can search for text in a category or measure based on the following criteria:

• contains
• begins with
• ends with

The search results provide the category name and full path. For example, searching in the Sample cube for Star Lite shows the following results:

Category	Path
Star Lite	Products/Camping Equipment/Tents

Steps

1. With the PowerPlay Web Explorer report open, click the arrow to the right of the help button on the toolbar, and then click Find.

The Find window opens in the lower half of your browser window.

2. In the Search String box, select the search criteria you want to use, and in the adjacent box, type the text to search for.
3. In the Find Text In box, choose whether to search a report or a cube.
4. In the Position box, choose whether to search Rows, Columns, or Rows and Columns.

Tip: The Position box changes to a Dimension box when you select a Cube search. You can then limit the search to a particular dimension.

5. Click Find.

The search results appear to the right of the Find box.

6. To view the data you were searching for in your PowerPlay Web Explorer report, select the category in the Results list and choose one of the following options:
   • If the category appears in the current report, click the Go To link to isolate the data in the report.
   • To filter the report on the returned category, click Filter.
   • To show the returned category in the report rows, click Replace Rows.
   • To show the returned category in the report columns, click Replace Columns.

Tip

• To find a specific item in your data, you can also right-click a category in the dimension viewer, and then click Find.

Scenario Dimensions

A scenario dimension is a dimension in which categories are used to represent different scenarios.

Scenario dimensions do not roll up to a single root category because that value would not be useful.

Scenario dimensions are useful when you are analyzing financial data. Instead of analyzing just one set of values, you can analyze several sets of values. Each set of values presents a scenario. Each scenario is based on different assumptions, such as planned, budget, or actual values, or best and worst case values.

Scenario dimensions are defined in Transformer. If default categories are defined for the dimension, when you open the cube in PowerPlay, the initial view is filtered on the default category.

In a cube or report that contains a scenario dimension, the scenario dimension is distinguished from other dimensions by the scenario dimension icon . If the cube modeler identified a default category for the scenario dimension, the default category appears as a default filter in the dimension line.