Page 135 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes 6. Select a dimension name having a defined hierarchy from the Dimension name box.
7. Enter a name in the Hierarchy name box.
8. Click Finish to complete the wizard. After you complete the wizard, Dimension Editor
appears so that you can further refine the dimension.
9. (Optional.) To create another hierarchy of the dimension, from the File menu in Dimension
Editor, point to New Dimension, and then click Wizard. Repeat Steps 3 through 8.

Self Assessment

Fill in the blanks:
1. Different dimensions with a single hierarchy are called ...............................
2. Dimensions that have multiple hierarchies can be created in the ...............................

9.2 Build an Account Dimension to Support Financial Analysis

The Account dimension and its associated rules enable you to create and maintain a chart of
accounts for various financial models.

In Microsoft SQL Server Analysis Services, an account type dimension is a dimension whose
attributes represent a journal of accounts for financial reporting reasons. An account
dimension permits you selectively manage aggregation across various accounts over time. An
account dimension also lets you use a benchmark means to resolve most of the non-standard
aggregation issues typically came across in business understanding solutions that handle
financial data. If you did not have such a standard mechanism, settling these nonstandard
aggregation issues would need Multidimensional Expression (MDX) scripts.
The following table describes the pre-defined properties of Account dimension members:

Table 9.1: Properties of Account Dimension Members

Property Description
Account Type A selectable option that groups the account member into a type, such as Tax
Member ID Expense or Liability, for use with business rules. Planning Business Modeler
uses this property to determine the aggregation behaviour for accounts.
When using this property in a business rule calculation, you must explicitly
reference the property as Account Type Member ID. Do not use a substitute
such as "Account type".
Debit Credit Indicates whether, for calculation purposes such as aggregation, Planning
Business Modeler treats this account type as a debit entry or a credit entry.
When used in calculation, an account type that has a debit name has a
negative sign for calculation, and an account type that has a credit entry has
a positive sign.
Time Balance Indicates how Planning Business Modeler handles values in this account
type for aggregation. The following values are possible:
• Sum — aggregation value is the sum of all child members.
• End — aggregation value is the last nonempty child along the Time
dimension. Also called Last-child aggregation.
• Avg — aggregation value is the average value of member children.

Contd....

130 LOVELY PROFESSIONAL UNIVERSITY