WTD/PTD/QTD/YTD calculation required for line graph, SSAS cube as data source

[xyz]

Hi Gurus,

I have requirement to a graph based on the date, graph has to display for WTD/PTD/QTD/YTD, where my data source is SSAS cube and using DMR functions, how can I achieve the same.

I have Fiscal Year hierarchy, whereas it has Fiscal Year, Fiscal Quarter, Fiscal Month, Fiscal Week and Date levels.

Fiscal Year level has Member Description, Current Date Flag and Fiscal Year Key attributes.

Fiscal Quarter level has Member Description, Current Date Flag, Dim Time Fiscal Year and Fiscal Quarter Key attributes.

Fiscal Month level has Member Description, Current Date Flag, Dim Time Fiscal Quarter and Fiscal Month Key attributes.

Fiscal Week level has Member Description, Current Date Flag, Fiscal Month and Fiscal Week Key attributes.

Date level has Member Description, Current Date Flag, Day of Month, Day of Quarter, Day of Week, Day of Year, Fiscal Day of Month, Fiscal Day of Quarter,Fiscal Day of Week, Fiscal Day of Year, Fiscal Month of Quarter, Fiscal Month of Year, Fiscal Week, Fiscal Week of Month, Fiscal Week of Quarter, Fiscal Week of Year, Holiday Flag, Month, Month of Quarter,  Month of Year, Operation Week, Week, Week of Year and Date key attributes.


For WTD (Week to Date), I have to display Days on the x-axis and Measure percentage on y-axis. Where my week will start on Monday.
Similarly PTD (Period to Date), I have to display Days on the x-axis and Measure percentage on y-axis. Where my week will start on Monday.
Same for MTD and YTD as well.

Can, some one please help me how to write the calculation expression for this, as I am new to DMR functionality.


Thanks & Regards,
xzy

[xyz]

Can some one please reply on the same. I am eagerly waiting for the same.

For WTD (Week to Date), I have to display Days on the x-axis and Measure percentage on y-axis and regions in series. Where my week will start on Monday.

Similarly PTD (Period to Date), I have to display Days on the x-axis and Measure percentage on y-axis and regions in series. Where my week will start on Monday.

For QTD (Quarter to Date), I have to display Weeks on the x-axis and Measure percentage on y-axis and regions in series. Where my week will start on Monday.

And for YTD (Yeart to Date), I have to display by Weekly on the x-axis and Measure percentage on y-axis and regions in series. Where my week will start on Monday.


Thanks & Regards,
xyz

[xyz]

Hi Gurus,

Can you please let me know, shall I use levels in Fiscal-Year hierarchy for doing calculation for WTD, PTD, QTD and YTD?


Your help will be much appreciated?

Thanks & Regards,
Abdul