Skip to Content
0
Former Member
Apr 09, 2010 at 09:18 AM

SAP BW Universe Filter - Yesterdays Date

55 Views

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 ...