Skip to main content

Hi Experts , Lets say i have to compare activity time lets say "Goods Receipt" time which is present in activity table with Expected delivery date which is present in case table. Should i be directly substracting activity time on Olap table and fiter table by activity == "Goods receipt" OR

Is there a good way using PQL ?

 

Thanks - Shaif

Hello Shaif,

 

Try This, PU_FIRST("CASE TABLE", ACTIVITY_EVENTTIME, ACTIVTY_NAME = 'Goods Receipt') = "CASE TABLE"."DELIVERY DATE TIME" with the case when statment.


Sure , Thank you very much . This is helpful


Reply