Skip to Content
0
Former Member
Jun 25, 2009 at 08:36 PM

How do I create Filter in Bex reports for version calcuated based on date?

25 Views

Hi ALL,

I am an SAP APO DP Consultant and BI is extensevly used for Demand Planning application. I am trying to create a filter in Bex report for version- we presently use constant 000 version for getting reports. Now as I used back up strategy and storing data in various version , I require to create filter for version whch can use formula and take yesterdays data with format yyyymmdd. We do this in Excel using TEXT(TODAY()-1,YYYYMMDD.

Can anyone advice how I can do this in Query designer for Bex Reports.

thanks

KV