SAP BW Universe Filter - Yesterdays Date
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">
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 ...