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