SAP Commissions - Scheduling Pipeline using CDL

[former_member784354]

Hello, I just met a problem filling the Pipeline template for CDL. I don't know where to find the available commands, stagetypename, runmodes and etc. I have watched some microlearning videos and read some articles but they are not enough for me to understand how it works.

[lpulsife]

I have seen customers use an outside cron to schedule PIPELINE trigger file drops.

[lpulsife]

1. This blog post has some good details for the Purge action. This may be good for ongoing maintenance and keeping things tidy.

https://blogs.sap.com/2021/04/28/using-cdl-to-purge-data-from-stage-tables-in-sap-commissions/

1. An example template recently used to build the purges is attached. Files are built in the spreadsheet then copied into .txt files and subsequently uploaded using CDL. This is provided as an example. Please note that Excel likes to UPPERCASE the Boolean values and insists on turning false into FALSE, which will fail the PIPELINE trigger. (attachment to follow)

[lpulsife]

cdl-pipeline-templatexlsx.txt

Attached is a .xls named as .txt - rename to .xlsx

[former_member784354]

Hello, thank you for your reply.

It's okay in case we need to purge data. But the case is that we need to schedule the pipeline so it launched once a day to import new transactions and preliminary calculate bonus.