If you are unable to create a new account, please email support@bspsoftware.com

 

PTD calculation not working as expected, SSAS cube as a data source

Started by xyz, 16 Jan 2014 01:33:35 PM

Previous topic - Next topic

xyz

Hello all,

I have one question, I have a calculation for WTD, QTD, Period To Date (PTD) and YTD in my report, I was able to get the calculation easily done for WTD, QTD and YTD. where I am struggling to get the data correct for Period To Date calculation, which is nothing but Month To Date. If I pass Week as parameter in PTD calculation, I have to display days for that month only on the x-axis.

Example: if I select fiscal week i.e. 01/18/2014 in the prompt at run time then report on x-axis should display all the days each day on x-axis from 01/18/2015 to 01/01/2014.

I tried creating calculation like below.

periodsToDate ([MMHF].[Date].[Hierarchy - Fiscal Year].[Date - Fiscal - Month], [MMHF].[Date].[Hierarchy - Fiscal Year].[Date - Fiscal - Week]->?p_fiscal_week?)

But it is not working as expected, can you please help me on it.

Example: Calculation used for QTD looks like below
periodsToDate ([MMHF].[Date].[Hierarchy - Fiscal Year].[Date - Fiscal - Quarter], [MMHF].[Date].[Hierarchy - Fiscal Year].[Date - Fiscal - Week]->?p_fiscal_week?)

WTD, QTD  and YTD calculations are working as expected.

Your help is much appreciated

Thanks & Regards,
Xyz