Incorrect data in cube when with MOLAP and HOLAP storage

[marrow386]

When designing the storage for my database cube, when I use MOLAP or HOLAP my data is incorrect ,however when I use ROLAP everything is fine .
My cube has a possible 204 aggrigations , if I limit this to less than 21 the data comes back correct in all MOLAP HOLAP and ROLAP storage .However if I select more than 21 ,the data only comes back correct for ROLAP.

If data is correct in ROLAP ,shouldnt it be correct in HOLAP and ROLAP as well ?
Please tell me how i can resolve this . I am using SQL 2000 and have all the lates service packs updated.

HELPPPP PLEASE !!!!

 

[MDXer]

I would check the cube schema make sure it is optimized and that the select statement to populate the cube is not doing any weird joins that may cause data explosion.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[marrow386]

Thanks , I'm a go try that .