SSAS MDX Year to Date (YTD) Calculation Example

Who is online?  0 guests and 0 members
Home  »  Blogs  »  BrianKnight  »  SSAS MDX Year to Date (YTD) Calculation Example
 
0
/5
Avg: 0/5: (0 votes)

Comments (1)

chrisflynn
chrisflynn said:

Hi Brian

I'm using this calculation (well, PeriodtoDate, to be exact as I'm dealing with Fiscal years) and have an issue when  months are missing.

Say in your example there was no fact value in the cube against Feb 2002, this would return no row against this missing month. In Reporting Services, a report which filters on Feb 2002 would then return nothing for the YTD to Feb 2002 value, which is wrong as it should be $648k (January's value).

I'm really struggling with this so any help would be much appreciated.

Many Thanks
Chris

6/14/2010
 · 
 
by
Blogs RSS Feed

BrianKnight's latest blog posts

Blogs RSS Feed

Latest community blog posts