Hi Aneal,

Are you able to test the following (basically the same mdx) against the Foodmart2000-Sales cube?  If this works then the issue is related your cube rather than the mdx. ...

So using the query below, and changing the year to the specified year(I set it to 2003), the sample app returns the correct row count but SSRS doesn't?

WITH

NonEmptyCrossjoin(«Set1»[, «Set2»...][, «Crossjoin Set Count»])

Remarks

The NonEmptyCrossjoin function returns the cross product of two or more sets as a set, excluding empty tuples or tuples without data supplied by underlying fact...

As a first run answer I'd say that the combination of the dimensions being crossjoined is excluding your records.  Have you run up the possible queries (in say MDX sample...

Have you tried just creating the site, creating two new virtual directories (Reports and ReportManager) and point them to the same directories as the existing ones (on the default web)...

Can you post the query string that you're using?  ie the dynamic MDX with parms included.

Have you tried using the currentmember in the calculated member rather than explicitly naming the member?  This still works for me (naming the member) but when returning >1 dimension mmbers...

Immy,

I'm guessing you're referring to having your repository in MSAccess.  To get it into MSSQL, right click on the AS server within Analysis Manager and select the Migrate Repository option. ...

Possibly the InScope function could help.

A few things you can try.  The following is soem MDX that works for me (i translated back to your dim & measure names).  Alternatively, you can try out the...

I've done something similar when using a flawed join strategy for building the cube.  Have you got processing logging turned on?  If not, turn it on and capture the SQL...

I'm not really following where the second IIf statement comes in, or the "abc' bit, but if you're looking to clean up the nested "If's" a little, you could try...

Just a quick note on his article, if you follow it to the letter.  To save you pulling out lrge clumps of hair (as I did), if you have *any*...

I used a similar approach to that described in Bill Pearsons article (here) and use these templates almost every day. 

re: the images, i stored them within the report...

Have you tried to add a distinct count of Profit Centres that have Service_Days >= 0 ?

If you can add this then it can be:

i) hidden from users (ie set...