Use the Configure Zero Activity Parameters screen to configure parameters specific to the Zero Activity template. With this template, you can build queries that identify members of a selected level that have had sales in the past, but that have had no sales in a specified time period.
This template can address business questions such as the following:
Which products didn't sell last year?
The main sections and controls of this screen are listed in the following table:
Section |
Control |
Description |
---|---|---|
Display Members of |
Dimension |
Lists all dimensions in the cube on which the query is based. Select the dimension that contains the hierarchy to display in the Hierarchy field. |
Hierarchy |
Lists all hierarchies in the currently selected dimension. Select the hierarchy that contains the level to display in the Level field. |
|
Level |
Lists all levels in the currently selected hierarchy. Select the level that contains the members you want to see in the query's result. |
|
Based on the measure |
Lists all measures in the cube on which the query is based. Select the measure in which to look for a zero value. |
|
With No Activity for |
Time dimension |
Lists all the time dimensions in the cube on which the query is based. Select the dimension that contains the hierarchy to display in the Hierarchy field. |
Hierarchy |
Lists all hierarchies in the currently selected dimension. Select the hierarchy that contains the level to display in the Level field. |
|
Period level |
Lists all levels in the currently selected hierarchy. Select the level that contains the time granularity for the from and to periods. |
|
From |
Lists all members in the currently selected level. Select the beginning of the time period that should have zero activity. |
|
To |
Lists all members in the currently selected level. Select the end of the time period that should have zero activity. |
You want to know which products did not sell at all in January. To create this query, configure the values on this screen in the following manner:
Display Members Of section:
Dimension = Product
Hierarchy = Product
Level = Product Name
Based on the measure = Store Sales
With No Activity For section:
Time dimension = Time
Hierarchy = Time
Period level = Month
From = January
To = January
The result of this query is a simple table such as the following:
Product |
---|
Portsmouth Imported Beer |
Top Measure Imported Beer |
Fabulous Apple Drink |
Great Cranberry Muffins |
Great Muffins |