Skip to Content
0
Apr 14, 2016 at 02:37 PM

Filter on Current and Previous Year in IDT

1028 Views

Guys,

I might have messed up something and couldn't able to get the right way of creating filters in IDT.

Need to restrict 2 Year data (Current and Previous Year) in WebI and wanted to create a run time parameter (No prompts)


i have created dimension in BL for Current Year and Previous year but any ideas on the approach is appreciated.

Max(extract(year from "_SYS_BIC"."view"."CREATED_DATE"))

Data source is HANA view and BO 4.1.

Thanks,

Jothi