Orders only for previous date extract

[Former Member]

Hello everyone,

I need to schedule a order detailed report in WEBI where I need only orders created in the previous day to flow.
Trying to set a measure or a dimension based on [Order Header Create Date].
Tried with CurrentDate, Between,

If [Order Header Create Date] between CurrentDate() and CurrentDate()-1 then True else False and similar formulas/logics but without success.


This is really my first time working with the tool but without success.

I appreciate any help or guidance.

Thank you in advance!

[lenastodal]

Welcome and thanks for visiting SAP Community to get answers to your questions. Check out our tutorial to get started in SAP Community: https://developers.sap.com/tutorials/community-start.html By adding a picture to your profile you encourage readers to respond to your question: https://www.youtube.com/watch?v=46bt1juWUUM

[mhmohammed]

Hi Rusi,

Look at the Dynamic Default Value for Universe (UNX) Prompts section in this page.

Thanks,
Mahboob Mohammed