Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SAP BW Universe Filter - Yesterdays Date

Hi All

I have a small problem and as I know very little about XML and MDX need help. I have created a filter in my SAP BW Universe with the following syntax

<FILTER KEY="[0CALDAY].[LEVEL01].[[20CALDAY]].[Value]"><CONDITION OPERATORCONDITION="Equal">

<CONSTANT VALUE="07/04/2010"></CONSTANT>

</CONDITION></FILTER>

This work fine however I need to dynamically bring back yesterdays date i.e. ReletiveDate(CurrentDate();-1) , I have tried but have failed to work out what the syntax is. Please Help ...

Former Member
Not what you were looking for? View more on this topic or Ask a question