What does this error mean? -- sql server data warehouse

Mike
12/18/2003 10:27:57 AM

All,

When I process a new cube, I receive this error:

Analysis Server Error: More than the maximum of 64,000
dimension member children for a single parent
(dimension 'Retention SC Account'S', level 'Account
Number', member '1234567890').; Time:12/18/03 9:58:28 AM

The underlying fact table has 16 rows for this account.
The view that populates the dimension retrieves 1 row for
this account and ~ 206,000 rows total.

The dimension has 5 levels:
Account: ~206,000 rows
Channel4: 54 distinct entries
Channel3: 42 distinct entries
Channel2: 16 distinct entries
Channel1: 14 distinct entries

Any idea why this error is occurring and what can be done
about it would be greatly appreciated.

TIA,

Mike

Ajit Singh
12/22/2003 9:38:58 PM

At a given level, only 64000 members can exist. This is the restriction by
AS.
To avoid this, you need to create group members and group the accounts below
them so that each group has a less than 64000 members (Accounts) below them.
Please refer to BOL for further details.

Ajit.

[quoted text, click to view]

sql server data warehouse : What does this error mean?