I am working on SSAS 2008.
Lets assume I have a cube with a measure called "Expenditure" and a dimension called "Account".
The Account dimension has the attributes: Category, Commodity, Description, Account. I have defined a hierarchy called "General Ledger", which has the Attribute relationships defined as Account->Description->Commodity->Category.
NB: the redundant attribute relationships have been removed.
I am trying to query for Expenditure at the Account level (no sums for higher levels), but return the Names of the parent levels in the output as additional columns. So the output would look something like:
Category Commodity Description Account Expenditure
I have the following MDX which gives me the Accounts and their expenditure, but how would I get the parent levels' names as output from the query?
select [Measures].[Expenditure] on columns,
non empty [Dim GL].[General Ledger].[GL Account].Members on rows
Thanks for any help
View Complete Post