Dimension-Based MDX Calculations - Microsoft SQL Server 2008 Analysis Services - page 227

You can use BI Dev Studio to create the mapping between account type and aggregation
function: Right-click FoodMart 2008 and choose Edit Database from the contextual menu.
The database editor, shown in Figure 13.6, appears. You can use the editor to modify
account type mapping. Analysis Services uses the value in the Alias column to map from
the account type specified in the Account Type attribute to the measure's aggregation
function.

You can also use the Account Time Intelligence Wizard to simplify the process of associat-
ing different aggregation functions to different accounts, by following these steps:

1. In the Solution Explorer, right-click the Budget cube and select Add Business
Intelligence from the contextual menu.
2. Proceed to the Choose Enhancement page of the wizard and select Define Account
Intelligence.
3. On the next page, choose your account dimension— Account .
4. Map the account types specified in the relational account table to the built-in
account types.
5. Map the built-in account types to the types specified by the members of the Account
Type attribute.

FIGURE 13.6

Use BI Dev Studio to define the mapping between aggregation function and

account types.