We are using MSAS 2000 and getting an error that indicates my dimension has
more than the maximum number of members (64,000) How do I get past this error?

Chris,
Analysis Services has a limit on the number of children on each non-leaf
member - as you have found out that limit is 64000.

In practise 64000 children of a member is unweildy anyway - it slows down
your reporting and doesn't have any reporting value.

You have 2 options:
1) Change your ETL to include an interim level.
2) AS has a feature to automatically build an interim level where this
occurs. The name of this feature escapes me - sorry!

I would not recommend using option 2 as AS's output is arbitrary - you have
no control over what "groupings" AS produces.

FWIW, this 64000 restriction does not apply in AS2005!

Regards
Jamie Thomson


"Chris Busch" wrote:

The intermediate level Jamie is referring to is Grouping. There are 2 ways -
automatic, in which case a square-root function is used to determine the
munber of members, or you can enter your own function - eg I have used
Left(expression,1) to get an A-Z grouping level. This may or may not work -
it depends on the nature of your data and if you have >64000 in a particular
letter. In the case of surnames, the distribution is not even, so you don't
get 26*64000 members overall, and you might not even get all the letters of
the alphabet in the intermediate level, which can be confusing for users.
Even so, I prefer to have this level of control, and Left(exp,2) is always a
posibility (or some other formula).
HTH,
Paul Ibison

(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)