SAP BW Universe Filter - Yesterdays Date

[Former Member]

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]

Thanks

[IngoH]

hi,

currently this can only be resolved by using an EXIT variable in the BW query.

ingo