Hi I've built a view that select a few fields from 3 tables.
I have 2 dimensions working properly. when I add the 3rd dimension (Customer)
I get the following message

The Level 'Name' contains fewer memebers than its parent level 'Account Code'.
A child level normally contains more members than its parent level.
Do you want to move the level 'Name' to a position in which its parent level
has fewer members and its child level has more

I click no and continue and when I process the cube I get this error message
and processing fails

More than the maximum of 64,000 dimension member children for a single parent

Can someone tell me a little more info about this.

thanks

Mark

It's true usually the number of members at a child level is bigger than the
number of its parent level. The message is just a warning message help
developers avoid mistakes.

But there is also exception and maybe your case. For example, one year has
52weeks(week1 ~ week52) and every week has 7 days(Mon~Sun).
It's because AS counts distinct members at each level.

More than 64,000 children members under a parent member is another issue.
It's AS 2000 limitation.
To avoid this situation, you can consider adding a dummy grouping level
above the level and set visible property to False.
Or also you can use grouping features. For example, refer to "How to create
member groups" of Books Online.

Ohjoo

"Mark" <Mark (AT) discussions (DOT) microsoft.com> wrote