Last month dynamic filter in IDT using HANA db

[Former Member]

Hi All,

I'm trying to create last month filter in IDT so I can schedule monthly Webi report  for previous month dynamically using HANA db.  I use string as date object i.e 20140401.  We are on BO4 sp8 and HANA update 68.

Thanks

bismil

[former_member4998]

HI

Develop the “Predefined Time Periods” (is a list that contains the data values associated with an object) in HANA is a good idea , Once you develop in HANA…we can get the last month need to drag “Predefined Time Periods” in the Query filter.

Please find below video’s for

Create a list of values based on a SQL expression

http://scn.sap.com/docs/DOC-22130

http://www.youtube.com/watch?v=erWr4wVTrRA

[Former Member]

Thanks Sreenivasulu.  I currently don't have access to HANA.  I'm looking for some pointers on how to create the filter on IDT level using HANA SQL.