Question:
Hello Guru:
I have an ODS like:
Order/Item/delivery quan/order quan/ count
The delivery quan/ order quan/ count are all key figures, the count for each record is "1".
Now I want to get the count for which the delivery quan>order quan.
I do not want to create another ODS.
Is there any solution for it?
Thank you.
Best regards,
Eric
Answer:
Create an additional key figure and populate it with a routine : 1 when condition met, 0 instead.
Answer:
Hello CHC:
Thanks for reply.
But the delivery quantity will be changed by the delta upload every day, and the delta data will only contain the "Delta" data, not the after image data.
So, where to define delivery>order? I think in the update rule, the data for delivery data is same as the data comes from the data source.
Thank you.
Best regards,
Eric
Answer:
1) create the said additional key figure
2) generate export datasource from the ods
3) create an infosouce based on this export datasource
4) create an update rule between the ODS and the infosource of point 3 ; in the update rules don't update anything apart the additional keyfigure with the said condition
5) load the ODS with the current UR
6) after activation, do a load from the ODS to itself to have the additional key figure populated correctly
7) after this second load in the ODS, populate the next datatarget
Ch