In OLAP Services, you are limited to 64,000 members per
Does anyone know how to get around this limit in OLAP
Services (not Analysis Services)?
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!
Mosaic Interactive Technologies, LLC
Extending the Data Wahousing Framework through metadata conversion libraries
nd DTS Custom Tasks
Quote:> In OLAP Services, you are limited to 64,000 members per
> Does anyone know how to get around this limit in OLAP
> Services (not Analysis Services)?
Q303969 INF: How to Work with More Than 64,000 Children Per Parent
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.
I am trying to create a calculated member whose parent is a calculated
member. The cube editor allows me to choose a calculation as the parent
member but fails when it compiles the MDX statement.
Should this facility be available? I am using the early beta release of