Thank you! This one caught me out today!

yes, it really does look like a bug. if I leave the NON EMPTY out of the query so as not to supress the empty rows, it works perfectly. so...

Steve, thanks a lot for all your suggestions. I will give the hierarchy thing a try.

I have actually created my time dimension manually, without using the wizard as well. my...

hi Steve

thanks for the tips on ordering. i will give them a try.

Yes, I was looking into doing some sorting at the Matrix level in RS. you can actually sort...

Thanks for both of the replies. I'm sure the problem can be solved with a correctly placed Order() clause. But since I'm an MDX newbie, "correctly" is not going to...

Hello

just a follow up on this problem i was having. On the microsoft.olap forum someone suggested that i enable drillthrough on the cube so that i could browse directly back...

Thanks so much for your reply!! I followed your advice and ran the component checker on my PC. It came back with MDAC 2.7 SP1 and MDAC 2.7 SP1 REFRESH....

This works a charm!! But I am unable to view my cubes still ...

If i select the FoodMart 2000 database, all it's cubes...