Okay, so I tried below as well with the same results. Not sure if there could be something more to it. To me it looks to be a simple ternary...

Thanks for your response steve. I had read thepost earlier and tried to use membervalue already if you notice my code snippet. Even that does not seem to resolve the...

Thanks a ton! My scope was considering a lot more than i required. It was hitting half a million rows every time user dropped 'Outlet' dimension onto excel. With below...

Here is the MDX -

SCOPE ([Measures].[YTD Rolling POD Outlet],

[Outlet].[Customer].AllMembers,

[Date].[Fiscal Month].[Fiscal Month].MEMBERS,

[Item].[Brand Category].[Brand Category].MEMBERS,

[Item].[IPL].[IPL].MEMBERS,

[Item].[IPL Familyand Bottle].[IPL Familyand Bottle].MEMBERS

);

...

Sorry for arriving late. I actually got around the problem using resources shared by you. Chris Webb's blog helped. I had to play around with the scope definition and get...