dbTalk Databases Forums  

Re: More Than the maximum of 64,000 dimension member children for a single parent

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Re: More Than the maximum of 64,000 dimension member children for a single parent in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
akshay349
 
Posts: n/a

Default Re: More Than the maximum of 64,000 dimension member children for a single parent - 08-12-2003 , 10:57 AM






In analysis services any level cannot have more than 64K members.
So when you create dimensions from dimension wizrd , use advanced options
and select groupting options.
It will create artificial groups .
Look more info into BOL.
Regards,
Akshay
"Eleazar" <enl23 (AT) matusa (DOT) com.mx> wrote

Quote:
Hello everybody !!
What does means this message?
Into dimension 'Member Count' have 207476 level members.
the server have 4 G.b. harddisc, 1.02 Gb free space and 785698 Kb. in RAM






Reply With Quote
  #2  
Old   
Eleazar
 
Posts: n/a

Default Re: More Than the maximum of 64,000 dimension member children for a single parent - 08-12-2003 , 11:49 AM






Thanks you very much..


"akshay349" <akshay349 (AT) hotmail (DOT) com> escribió en el mensaje
news:uTCllpOYDHA.2572 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Quote:
In analysis services any level cannot have more than 64K members.
So when you create dimensions from dimension wizrd , use advanced options
and select groupting options.
It will create artificial groups .
Look more info into BOL.
Regards,
Akshay
"Eleazar" <enl23 (AT) matusa (DOT) com.mx> wrote in message
news:uPgwRdOYDHA.736 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Hello everybody !!
What does means this message?
Into dimension 'Member Count' have 207476 level members.
the server have 4 G.b. harddisc, 1.02 Gb free space and 785698 Kb. in
RAM








Reply With Quote
  #3  
Old   
Eleazar
 
Posts: n/a

Default Re: More Than the maximum of 64,000 ... - 08-12-2003 , 01:07 PM



Thanks

"akshay349" <akshay349 (AT) hotmail (DOT) com> escribió en el mensaje
news:uTCllpOYDHA.2572 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Quote:
In analysis services any level cannot have more than 64K members.
So when you create dimensions from dimension wizrd , use advanced options
and select groupting options.
It will create artificial groups .
Look more info into BOL.
Regards,
Akshay
"Eleazar" <enl23 (AT) matusa (DOT) com.mx> wrote in message
news:uPgwRdOYDHA.736 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Hello everybody !!
What does means this message?
Into dimension 'Member Count' have 207476 level members.
the server have 4 G.b. harddisc, 1.02 Gb free space and 785698 Kb. in
RAM








Reply With Quote
  #4  
Old   
Sean Boon [MS]
 
Posts: n/a

Default Re: More Than the maximum of 64,000 ... - 08-12-2003 , 06:59 PM



The restriction is actually that no parent can have more than 64,000
children. You can have more than 64,000 members in a level.

Sean


--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Eleazar" <enl23 (AT) matusa (DOT) com.mx> wrote

Quote:
Thanks

"akshay349" <akshay349 (AT) hotmail (DOT) com> escribió en el mensaje
news:uTCllpOYDHA.2572 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
In analysis services any level cannot have more than 64K members.
So when you create dimensions from dimension wizrd , use advanced
options
and select groupting options.
It will create artificial groups .
Look more info into BOL.
Regards,
Akshay
"Eleazar" <enl23 (AT) matusa (DOT) com.mx> wrote in message
news:uPgwRdOYDHA.736 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Hello everybody !!
What does means this message?
Into dimension 'Member Count' have 207476 level members.
the server have 4 G.b. harddisc, 1.02 Gb free space and 785698 Kb. in
RAM










Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.