Hi,

Is it possible to create a dimension in Analysis Services having
more than 64,000 distinct values. Is it a product limitation and is
there a way around it.

Thanks

its an AS2000 limit.
the limit is: 1 member cannot have more then 64000 children.
simply add a level in the dimension based on anything, like the first letter
of the product name will solve the issue.
or use category of product or anything to break the 64000 member list into
subsets



<tsachin (AT) gmail (DOT) com> wrote

Hi,

I am not clear with your answer, just so that I understand you
are saying that I can add levels which will correspond to the same
column as the dimension can you expand on this a little more. thanks
for the help



Jeje wrote:

AS2000 has the option to do this for you. (I don't remember the name of the
option, but take a look at the product level properties to find which one
do this)
or you can do it yourself, steps:
1. create a new level based on the product name
2. edit the caption and key column definition to keep only the first letter
(SQL statement like : left("mytable"."mycolumn",1))
3. process the product dimension


<tsachin (AT) gmail (DOT) com> wrote