Databases Reference
In-Depth Information
Figure 8-26
The Account Type identifies the type of an account member and
is used by Analysis Services to use the appropriate aggregation
function for measures that have the AggregationFunction prop-
erty set to ByAccount.
5.
In the Define Account Intelligence page the account types from the source
table are mapped to the built-in account types in Analysis Services 2005.
If the name of account types in the source table do not directly map to the
built-in account types you would need to map them correctly in this page. In
this example all the account types are mapped correctly and hence press
Next.
6.
The final page of the Business Intelligence Wizard shows the various
account types along with the aggregation functions associated with ac-
counts. Please review the aggregation functions and click Finish (see
Fig-
ure 8-27
and
Figure 8-28
).
Search WWH ::
Custom Search