Using Unary Operators to control Analysis Services hierarchy aggregations
Analysis Services hierarchy aggregations can be easily controlled using unary operators. For example, in accounting there are GL accounts that are grouped in major GL account groups and used in different financial statements like Profit & Loss Statement, Income Statement, Trial Balance, and Balance Sheet. These GL accounts may affect the balances of the major GL account groups and financial documents differently, adding or subtracting to the balance.
Read more...Tags: design