Dear SCN Members,
I was asked to send out an outbound file to client server with below details in the .csv format.
File should be one liner and except last field all the fields are constant.
|ERP|SY-DATUM|CONTRACT||<COUNT OF TOTAL NUMBER OF ACTIVE CONTRACTS>
I would like to know what would be the best approach in the performance front.
Required data is available in the cube and active contract may be around 10 - 15 million.
1. May I send this file through OHD and write end routine to calculate active contracts ? or
2. Create query over cube and add formula to calculate active contracts then use Query --> APD --> Outbound file.
Thanks for your valuable suggestions.
Regards,
Prakash