Skip to Content
0
Former Member
Dec 07, 2009 at 10:22 AM

Syntax for creating Dynamic Time Filtersin Universes based on SAPBW

24 Views

Hi there.

My customer has a requirement for having a series of dynamic filters available in a Universe Based on a Bex Query.

In the Univers the BO report Developper will be able to choose from different filters to make the appropriate query for the report,

The filters can have names such as:

last_14_Days

Last Year

This Year

This Quarter

Last Quarter

..

..

And so on

@Select(Time\CalenderYear/Week) BETWEEN to_char(sysdate-28,'YYYYWW') AND to_char(sysdate-7,'YYYYWW')

This syntaks is sort of showing the logic they want, but what will the syntax be to make it work in a Universe based on SAP integration Kit ?

Best Regards Ingrid