Configuring Count Parameters 
Use
Use this screen to configure the parameters specific to the Count template. See Count (OLAP) for the description, business question, and workflow for using this template.
Procedure
...
1. Configure the parameters in the Count Members Of section of the screen according to the actions in the table below:
Count Members Of Parameters
Parameter |
Values |
Action |
Dimension |
Lists all dimensions in the cube on which the query is based (see Selecting a Cube). As each of the screen’s three sections must be based on different dimensions, dimensions selected in the other two sections are omitted from this list. |
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 all the members you wish to count. |
With measure |
Lists all measures in the cube on which the query is based. |
Select the measure to which all members in the selected level contribute. Any member in the selected level with a non-zero value in this measure will be counted. |
2. Configure the parameters in the Displayed by Members Of section of the screen according to the actions in the table below:
Displayed By Members Of Parameters
Parameter |
Values |
Action |
Dimension |
Lists all dimensions in the cube on which the query is based. As each of the screen’s three sections must be based on different dimensions, dimensions selected in the other two sections are omitted from this list. |
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 that should be listed on the rows in the result. |
3. Configure the parameters in the For Date Range section of the screen according to the actions in the table below:
For Date Range Parameters
Parameter |
Values |
Action |
Time dimension |
Lists all the time dimensions in the cube on which the query is based. As each of the screen’s three sections must be based on different dimensions, dimensions selected in the other two sections are omitted from this list. |
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 upon which to base the date range. |
From |
Lists all members in the currently selected level. |
Select the start period of the date range in which to count members. |
To |
Lists all members in the currently selected level. |
Select the end period of the date range in which to count members. |
4. Click Next.
Result
You proceed to the Define Filters screen.
Example
You want to know how the quantity of products sold is distributed over states, and how that quantity changes from month to month. To create this query, configure the values on this screen in the following manner:
This example assumes you have similar types of metadata available in your data service.
Count Members Of section:
· Dimension = Product
· Hierarchy = Product
· Level = Product Name
· With measure = Store Sales
Displayed by Members Of section:
· Dimension = Customers
· Hierarchy = Customers
· Level = State
For Date Rangesection:
· Time dimension = Time
· Hierarchy = Time
· Period level = Month
· From = January
· To = March
The result of this query might be a table such as the following:
Count Query Result
Customers |
January |
February |
March |
CA |
1056 |
1131 |
1074 |
OR |
1185 |
970 |
1239 |
WA |
1343 |
1382 |
1391 |
This table shows that, for example, 1056 different products were sold in California in January, 1131 different products were sold in February, and so on.