Dynamic Variable for YTD08

[Former Member]

Hi All,

I am having a requirement for the generating a report for the selection field 0calmonth.if execute the report,the field name should get change for the previous years and i should get the data for the same.

For Example:

Input : 200906

YTD' 200906(Dynamic) YTD 08 (Dynamic)

ARCHWAY SALES - CINCINNATI 1234 1234

ARCHWAY SALES - CINCINNATI 13,725 13,725.

Eg.. If i give the input as 200906 and execute the report then at YTD 08 place i have to get previous year ( 200906 has to be converted as 200806) so it has to generate dynamically .

Let me know if you have any queries

Thanks!!!

[Former Member · Accepted solution]

Hi

Create 2 Restricted Key Figures YTD(FiscalPeriod) and YTD(FiscalPeriod-12)

In 1st RKF

Bring the KF of YTD and restrict by Fiscalperiod Variable

In 2nd RKF

Bring the KF of YTD and restrict by Fiscalperiod Variable and offset the variable by -12.

Use these 2 in your report.

Regards,

Bilapati

[Former Member · Accepted solution]

If feasable, create a customer exit variable.

Your solution would become much more simplified and robust.

[rathy_moorthy2]

Hi,

U can achieve it by using customer exit variable-which u can base on ur user entry input variable. In the customer exit variable code give as input ur user entry variable and return previous years period.And restrict ur data with the customer exit variable.

Then for display create a text variable with replacement path for calmonth.

Hope it helps.

Regards,

Rathy

[Former Member]

Dear All,

I have the same requriment. All will say to create the Customer Exit Variable.

But Can anyone Kindly give Step by Step Procedure that how to create Customer Exit Variable for YTD based on Month.

Thanks,

Sony

[Former Member]

Hi,

Can you try the method that I said, It works for me.

Regards,

Bilapati