hitting the 64k limit with a hierarchial big dimension - Please ad

hitting the 64k limit with a hierarchial big dimension - Please ad

Post by UHJhc2F » Fri, 06 May 2005 01:48:04


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.
 
 
 

hitting the 64k limit with a hierarchial big dimension - Please ad

Post by David Botz » Fri, 06 May 2005 12:13:05

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

David

 
 
 

hitting the 64k limit with a hierarchial big dimension - Please ad

Post by Dave Wicke » Fri, 06 May 2005 13:18:00

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