Create YTD(Year TO Date) Variable in IDT 4.1 SP6

[Former Member]

Hello Gurus,

Stuck in to create a Variable in IDT for YTD to find Year to date value for a Measure .

Suppose I want how much Quantity ordered till date that will be entered like To Date will be prompted and from date will give date as per the selection of to date.

I have time_Key string value for date and measure value is Quantity.

And I want to create a variable for Year to date.

Note:- TO date will be any date like , 12 march 2015.(Not Current Date).

Please help me create a variable according to this scenario.

Backend DB is SqlServer.

[former_member196948]

Hi Pradeep,

You can achieve by this way tooo

Create a LOV's in IDT

Start date LOV : SELECT distinct(TO_DATE((to_char(CAL_DATE, 'YYYY')||'0101'),'YYYYMMDD'))

FROM DIM_DATE

where CURRENT_DATE = CAL_DATE

End Date LOV :  Current date - 1

and put in Condition as Start date and End Date.

Regards,

Jeet

[Former Member]

Hi Pradeep,

Please refer to below doc

Regards

Niraj