Hi everyone,

I have two time dimensions (i.e Fiscal Time and Calendar Time). Below is
my YTD MDX Query for Fiscal Time only.

How can I make this query for Calendar Time as well?


IIF([Measures].CurrentMember IS [Measures].[No of
Cases],NonEmptyCrossJoin({[ST Cases].[Case Key].Members},
{[ST Facilities].CurrentMember},
{[ST Facility Types].CurrentMember},
{[ST Time Series].[Value]},
{[ST Intent].CurrentMember},
{[ST Sites].CurrentMember},
{[ST Staging].CurrentMember},
{[ST Calendar Time].CurrentMember},
YTD([ST Fiscal Time].CurrentMember),1).Count,Sum(YTD([ST Fiscal
Time].CurrentMember), [ST Time Series].[Value]))

Thanks for all your help,

Audrey


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!