Developer Forum

Hi,

I have a big dimension with 4 levels including the "All" level. The second
level (The level below the "All" Level) has more than 64k members and MSAS
could not process the dimension.

I could not do "Auto - Grouping" as this is not the lowest level. Please
advice if there is a work around for this without changing the table
structure like adding new columns.

Thanks,

Sam.

Unfortunatly, the only thing you could do is add your own grouping to break
up the first level.

David

A common technique is:
1) load the dimension through a view; not the base table (always a best
practice)
2) in the view add a column which is the first 2 characters of the 2nd
level's name.
3) use this column to create a level between All and your 2nd level.
Basically you are forcing an intermediatary grouping level.

Hope that helps.
--
Dave Wickert [MSFT]
XXXX@XXXXX.COM
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)


break


second
MSAS