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

#1

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

#2

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

#3

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

#4

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

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

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

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

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

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