I would like to create an account dimension in SSAS in which I have a simple hierarchy where some of the members are subtracted rather than added. For example Operating Income = Gross Margin - ExpenseGroup1 - Expense Group2....
Where Gross Margin is in turn an aggregate e.g. Gross Margin = Revenue - Cost of Sales.
I've looked at adding business intelligence to my dimension and defining "Account Intelligence". It seems though that this is just a way of adding some pre-defined attributes such as Assets, Liabilities, Income, Expense... to the dimension. It looks helpful in the way these defined attributes will aggregate over the time dimension e.g. Assets not adding over time but rather 2005 Assets would be the same as Dec 2005 assets. It doesn't seem though that it has any effect on how the members are aggregated in the Account dimension.
Because of the number of the accounts and the subtractions (around 6000 members) it makes using the creating a calculated member by writing the MDX statement too cumbersome. Isn't there a way to put this into a table?