Hello all,

I have a dimesnion with two Levels
Country
CustomerId

For one country the number of customer Id exceeds 64000 . So the dimension
fails to build
I Changed the registry settings
of VLDMThreshold to 1000000 (1million) and VLDMShmSize to 10 million. I
rebooted the system and when I try to build the dimesnion i still get the
same error.

Can anybody throw some light on this isssue?

Thanks
Satish

Satish:

With Analysis Services you cannot have anymore than 64,000 children for any
given parent. To overcome this you have two options:

- Use the Automatic Grouping property for the level (Country) is this case
Analysis Services will "bucket" the customers into groups of approximately
the same size.
- Add a new fixed data element level between Country and Customer (pershaps
state/province, or your own grouping where you take the first character of
the customers name).

Your users probably won't be able to do any effective analysis with a
drill-down to 64,000 members anyway.

HTH,

Barry
---------
"Satish Sainath" <satish_sainath (AT) hotmail (DOT) com> wrote