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