Count Parameters

Use the Configure Count Parameters screen to configure parameters specific to the Count (OLAP) template. With this template, you can build queries that count members of a selected level that contribute to a specific measure. This can address business questions such as the following:

Sales returns for MyCompany equal $25,000. How many product lines does this represent?

Structure

The main sections and controls of this screen are listed in the following table:

Section	Control	Description
Count Members of	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 all the members you wish to count.
	With measure ... not equal to zero	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.
Displayed by Members of	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.
For Date Range	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.

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:

Count Members Of section:

Dimension = Product
Hierarchy = Product
Level = Product Name
With measure ... not equal to zero = Store Sales

Displayed by Members Of section:

Dimension = Customers
Hierarchy = Customers
Level = State

For Date Range section:

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:

Products Sold by States: January to March
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.