Hi,

I am trying to build a cube in AS 2000 in which one of the
dimension has more than 64,000 values , so i inserted a dummy level
above it and applied automatic grouping on that dummy level but the
cube would not be generated as my lower level does not have unique
values.
I had 2 questions

1. Is there a work around for the above mentioned issue in AS 2000

2. I read the AS 2005 documentation and it says that in AS 2005 there
is no limitation on the number of values a level can have so can I just
include a level within my dimension whre this level has about 9 million
records .

Thanks

9 millions?
I really recommand to you to create hierarchy.
and you should never give access to these 9millions of members directly
(except if your users will don't do ad-hoc analysis and only a developprer
will create MDX queries)

for your AS2000 issue.
do you have activated the option "members name unique" in the dimension
level properties.
if yes, disable it, maybe you have a name in the intermediate level which
has the same name has your lowest level. so the name is not unique because
found at 2 different levels.
what are the key column options used for your middle and lowest levels?
does these values are uniques?
if you use the name of the customer as the key and if you have 2 customers
with the same name, this could cause an error.


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

Hey,

I did disable the member name unique in the dimension
properties. but it is still not working as it finds non - unique value.
However my question is in AS 2005 there is no limitation on the
dimension level having 64,000 or more values so a problem like the one
mentioned can it be easily tackled in AS 2005 or I might run into
similar issues. I have a data set which has about 9 million records and
out of those I have a million records that are unique.


Thanks


Jeje wrote:

you are right in AS2005 the limitation is far higher (4billion I think)

I think your AS2000 dimension have a wrong property setup to give you
errors.
Try to play and change the uniquename and other key properties in bot the
dimension and the levels.

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