OLAP Services, 64K members per parent limit

OLAP Services, 64K members per parent limit

Post by M. Stewar » Sun, 27 Jan 2002 05:49:57



In OLAP Services, you are limited to 64,000 members per
parent.

Does anyone know how to get around this limit in OLAP
Services (not Analysis Services)?

Thanks.

 
 
 

OLAP Services, 64K members per parent limit

Post by Michael Acost » Sun, 27 Jan 2002 06:25:58


There is no way to get around this limit.  However, you can impose what I
call "artificial" levels if you have very large, very flat dimensions.  For
example, let's say that you have a customers dimension and you have no
"natural" levels (e.g. country, state, city, zip) for aggregating.  You can
always use a view based on that table as the basis for the dimension and add
some fields for artificial levels.  Example follows:

SELECT FirstName, LastName, LEFT([LastName], 1) AS LastName1,
LEFT([LastName], 3) AS LastName3 FROM tblCustomers

You could then use LastName1, LastName3 and LastName as levels in your
dimension.  Obviously, the business value of these dimensions may be
dubious, but it works for the problem outlined.  Hope this helps!

Michael Acosta
Manager
Mosaic Interactive Technologies, LLC
Extending the Data Wahousing Framework through metadata conversion libraries
nd DTS Custom Tasks
http://www.mosaicinteractive.com


Quote:> In OLAP Services, you are limited to 64,000 members per
> parent.

> Does anyone know how to get around this limit in OLAP
> Services (not Analysis Services)?

> Thanks.


 
 
 

OLAP Services, 64K members per parent limit

Post by William Chen [M » Wed, 30 Jan 2002 16:02:14


In Analysis Service 2000, we can use the  Member Groups feature as listed
in the following Knowledge Base article.

Q303969 INF: How to Work with More Than 64,000 Children Per Parent
http://support.microsoft.com/support/kb/articles/q303/9/69.asp

In OLAP server 7, we can manually insert a new level as a workaround. For
example, use the first letter of the last name.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Thanks,

William Chen