SEO

I have a virtual cube which has 4 physical cubes. The
virtual cube has 103 dimensions. while processing it
throws me an error that the cube has exceeded the maximum
no of levels in a cube. I guess the max limit is 256. Is
there any way of overcoming it? Its urgent and can
somebody help please?

Thanks,
Lakshman.

I think you exceeded the 256 limit of levels in a cube.
If your dimensions have 2 levels each than your cube will
have 206 levels and I assume your dimensions have more
than that. So it's very possible that you exceeded 256
overall.
As far as I know there's no option that you can change
this limitation. The only way that you can overcome it, is
by changing your design. You can do this by :
- Evaluate the most proper dimensions and levels that you
must include in your cube
- Break your virtual cube. Analyze which dimensions will
be used together in analysis and which one won't ever used
together. It's rather impossible that the user will see
and analyze with 103 dimension in one go. By doing this
you won't add significant processing time (because they're
virtuall) and you'll make the virtual cubes more logical
to be used.

I'm sorry if it does not fit with your problem and
requirement, I think the designer of Analysis Service have
these consideration in mind when giving the limitation,
but I know that it's always possible to have some specific
conditions in IT world that just can fit in. So, good
luck..

Regards,
Jono Indrawijaya - MCDBA
PT. eBiz Cipta Solusi
Indonesia

>-----Original Message-----
>I have a virtual cube which has 4 physical cubes. The
>virtual cube has 103 dimensions. while processing it
>throws me an error that the cube has exceeded the maximum
>no of levels in a cube. I guess the max limit is 256.
Is
>there any way of overcoming it? Its urgent and can
>somebody help please?
>
>Thanks,
>Lakshman.
>.
>

I've been thinking about this problem, and I remember one
thing that I learned in OLAP's MOC.
"The source cubes should contain one or more shared
dimensions that are the same, and at least one of the
common shared dimensions should be included in the virtual
cube. Analysis Manager does not enforce this rule, but the
result will be nonsensical if it is not followed. There is
no analytical value in combining cubes if they do not
share a dimension."
The point is : You have to have common shared dimensions
accross your virtual cube's physicall cube to make your
virtual cube make sense to analyze.
So if your physicall cubes had no problems with the level
limitation, so do your virtual cubes. It only could happen
if you include all the dimensions from your physicall
cubes that logically do not make sense.
Hope it helps..

Regards,
Jono Indrawijaya - MCDBA
PT. eBiz Cipta Solusi - Microsoft Certified Partner
Indonesia