Dimension limit - 64,000?

#1

I'm currently using SQL 2000 Standard Edition (SP3) to support a
variety of OLTP applications. I'm also using the same edition for a
large data warehouse.

I must be a bozo because I can't figure out how to create a dimension
with more than 64,000 members. All of the documention says that I
should be able to but I suspect that one need Enterprise edtion to be
able to do it.

The properties contained under the advanced tab in the dimension
editor are far fewer than those listed in BOL.

Is the edition the problem or is there a registry setting I have to do
that will allow for large dimensions?

#2

It's not a dimension limit. It's a family limit -- no member can have over
64k children. When a dim is flat (one level), all the members are children
of the ALL member. In this case, you need to add new level(s). If there's
nothing logical to pick from, then you must create a so-called grouping
level. (i.e. A-Z rolodex).

This is true of enterprise and non enterprise editions.

tom @ the domain below
www.tomchester.net

"Pete" <cytopete (AT) hotmail (DOT) com> wrote

Quote:

I'm currently using SQL 2000 Standard Edition (SP3) to support a
variety of OLTP applications. I'm also using the same edition for a
large data warehouse.

I must be a bozo because I can't figure out how to create a dimension
with more than 64,000 members. All of the documention says that I
should be able to but I suspect that one need Enterprise edtion to be
able to do it.

The properties contained under the advanced tab in the dimension
editor are far fewer than those listed in BOL.

Is the edition the problem or is there a registry setting I have to do
that will allow for large dimensions?

#3

cytopete (AT) hotmail (DOT) com (Pete) wrote in message news:<edf0c96e.0310310441.54450dbc (AT) posting (DOT) google.com>...

Quote:

I'm currently using SQL 2000 Standard Edition (SP3) to support a
variety of OLTP applications. I'm also using the same edition for a
large data warehouse.

I must be a bozo because I can't figure out how to create a dimension
with more than 64,000 members. All of the documention says that I
should be able to but I suspect that one need Enterprise edtion to be
able to do it.

The properties contained under the advanced tab in the dimension
editor are far fewer than those listed in BOL.

Is the edition the problem or is there a registry setting I have to do
that will allow for large dimensions?

Hi There --

I believe there is a physical limit of 64,000 members in any level of
any dimension, both in 32 bit and 64 bit SQL Server. The Microsoft
Folsk will probably tell you the same but more technically.

Sorry.

Pete

#4

Quote:

I believe there is a physical limit of 64,000 members in any level of
any dimension, both in 32 bit and 64 bit SQL Server. The Microsoft
Folsk will probably tell you the same but more technically.

As Tom already pointed out, there is no limitation on number of members in
the level. Only on number of children under same parent (siblings).
If you need to have more then 64000 children under same parent - you can
create grouping level, and even make it hidden.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

#5

Actually, Members per parent = 64000.

-SQLVarad(MCDBA-1999,MCSE-1999)

Quote:

-----Original Message-----
It's not a dimension limit. It's a family limit -- no
member can have over
64k children. When a dim is flat (one level), all the
members are children
of the ALL member. In this case, you need to add new level
(s). If there's
nothing logical to pick from, then you must create a so-
called grouping
level. (i.e. A-Z rolodex).

This is true of enterprise and non enterprise editions.

tom @ the domain below
www.tomchester.net

"Pete" <cytopete (AT) hotmail (DOT) com> wrote in message
news:edf0c96e.0310310441.54450dbc (AT) posting (DOT) google.com...
I'm currently using SQL 2000 Standard Edition (SP3) to
support a
variety of OLTP applications. I'm also using the same
edition for a
large data warehouse.

I must be a bozo because I can't figure out how to
create a dimension
with more than 64,000 members. All of the documention
says that I
should be able to but I suspect that one need
Enterprise edtion to be
able to do it.

The properties contained under the advanced tab in the
dimension
editor are far fewer than those listed in BOL.

Is the edition the problem or is there a registry
setting I have to do
that will allow for large dimensions?

.

#6

"Mosha Pasumansky [MS]" <moshap (AT) microsoft (DOT) com> wrote

Quote:

I believe there is a physical limit of 64,000 members in any level of
any dimension, both in 32 bit and 64 bit SQL Server. The Microsoft
Folsk will probably tell you the same but more technically.

As Tom already pointed out, there is no limitation on number of members in
the level. Only on number of children under same parent (siblings).
If you need to have more then 64000 children under same parent - you can
create grouping level, and even make it hidden.

Hidden ... Now that's a very cool idea that I should have thought of.
Thanks much Mosha. Will let you know how it works out.....

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

Dimension limit - 64,000?

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

Dimension limit - 64,000? - 10-31-2003 , 06:41 AM

Re: Dimension limit - 64,000? - 10-31-2003 , 10:58 AM

Re: Dimension limit - 64,000? - 10-31-2003 , 12:28 PM

Re: Dimension limit - 64,000? - 10-31-2003 , 12:45 PM

Re: Dimension limit - 64,000? - 10-31-2003 , 06:04 PM

Re: Dimension limit - 64,000? - 11-01-2003 , 06:05 AM