After loading the data from 1st qvd files, I am making lot of calculations and the result is saved in a new qvd files.
I am not able to make this calculation in load script since the logic is complicated to do.
I have two qvd files , one is purchase schedules and another qvd file which is corresponding grn (goods receipts file). In my scenario , there are one or more than one rows for a specific p.o number in both tables. I have to calculate fulfillment ratio and delay in delivery days (FIFO basis) by checking each records in both tables.
Currently , in the 1st qvw file, I am loading both PO and GRN qvd files in to two different tables, and then briging this data in to two different chart (table list). The Marco function I worte will perform the calculation in which I am reading each records from GRN table and finding out fulfillment ratio and delivery delay days, writing this into a new table and saving the new qvd file. Since the macro can perform only after the load script, where I am calling the chart values , I can not call this function in the load script.
The reason I am using chart for calculation is, the table read (each rows) taking more time thant reading records from the chart.
I am using publisher to perform the load which is scheduled at night.
Is there any option to call the marco function after completing the load script.?