Hi All,

I have been pulling my hair out on this one. Using SSAS 2005 (This
functionality worked in SSAS 2000)

My fact table contains financial data. Entries are identified with an
AccountID, Year, Month, Amount
My Account Dimension has the following structure:
Default Grouping
Level 1 Grouping
Level 2 Grouping
Level 3 Grouping
Account ID

Account Dimension Table is joined to the fact table on the AccountID

Dimension processes and is correct

When I browse the data, All values up and down the dimension have the same
value (Grand Total) until I get to the accountid level (lowest level). When
I am there,
the value is correct.

Please help. If you need more information, let me know.

Thanks,
Chris Exley

I'd check out how you have your member key set on the dimension. I had the
same problem as you did.

Is it set up as a parent child?


"Chris" <cexley (AT) enableconsulting (DOT) com> wrote