Add Combinations of Items dialog

Use this dialog to specify when you want a summary to be used.

This dialog is also displayed as:

Summary Wizard: Step 4

Summary Wizard: Step 5

Edit Summary dialog: Combinations tab

For more information, see:

"What are summary combinations?"

"What to consider when defining summary combinations?"

"Guidelines for setting up summary combinations"

For example, you create a manual summary on two items: Product Key and Product Type. You might want the summary to be used for any query using both items together, or any of the items individually, as follows:

• Product Key and Product Type

• Product Key

• Product Type

In this instance, you create three combinations and select the check box next to the items that you want to use as follows:

Table 25-1 Summary combinations

Combinations	Combination 1	Combination 2	Combination 3
Product Key	Ticked	Ticked	Not ticked
Product Type	Ticked	Not ticked	Ticked

If you want to use the summary only when the Product Key and Product Type items are used together, you use the default combination only:

Table 25-2 Summary combinations

Combinations	Combination 1
Product Key	Ticked
Product Type	Ticked

Add combinations of items to this summary folder by clicking "Add Summary Combination" and clicking the desired items

You need to choose the summary combinations that are to be pre-built and managed by the End User Layer. Each combination (essentially the queries and reports available to the end user) should reflect the type of analysis the user will want. The Summary Wizard displays one vertical row for each possible combination of axis items and summary folders.

In each row, click the check box for each axis item and combination to create a specific summary table for that choice. The End User Layer will always build that data for that table and have the information ready when an end user selects that particular query.

Add Combination

Adds a new summary combination row.

Remove Combination

Deletes the selected summary combination row.

Estimate Space

Displays an estimate of database space required to store the summary combination you created.

Properties

Allows you to view and edit database storage properties for the selected combination.

Status

The status field displays the status (for more information, see "Summary Status") and any database error message for a selected combination. If the summary table for this combination did not get built, the error message returned by the server appears here.