Databases Reference
In-Depth Information
You have now successfully enhanced your Account dimension. If you
look at the properties for the Account dimension you will see the Account
dimension property Type is set to Accounts. The aggregation functions
for various account types are pre-defined in Analysis Services. However
Analysis Services allows you the flexibility to add additional account
types as well as to make changes to the AggregationFunction for the
account types to suit your business needs. To make modifications right
click on the project name AnalysisServicesTutorial in solution explorer
and select Edit Database. You will see a new designer to make changes
at the database level as shown in
Figure 8-29
.
Figure 8-29
As mentioned earlier the enhancement made to the Account dimension
will only be applicable for measures that aggregation function defined as
ByAccount. Open the Adventure Works DW cube. In the Cube Structure
pane select the measure Amount in the Fact Finance measure group and
set the Aggregation Function for this measure to ByAccount as shown in
Figure 8-30
. Deploy your changes to the Analysis Services instance.
Search WWH ::
Custom Search