Hello Community & Experts,
Hope you all are keeping safe and healthy.
After almost a year of delay, I 'am happy this happens and I am posting this knowledge.
I had a chance to explore the API's exposed my SAP's API Business Hub for Data integration with external systems for SAP Integrated Business Planning for Supply Chain. As SAP has reserved the frequently used SAP_COM_0143 for SAP Analytics Cloud
I explored Export and Import of Master Data (MD) and Key figures (KF) data via exposed OData API. But there had been this delta extraction part which excited me to write this blog as I didn't find much content on it online. It will be not wrong to mention that the Delta functionality still needs more exploration and will be very useful in upcoming days for direct IBP keyfigure delta data extraction, which seems a tough design currently via SAP Cloud Integration for Data Services (Hereafter SAP CI-DS).
As first steps, (common for exposing entire OData Service for MD and KF)
- Planning Data Integration: SAP_COM_0720 needs to be enabled in SAP IBP Communication Management -> Communication Arrangements . Entire detailed steps can be found here
- The authentication modes possible currently is Basic and SSL Certificate based.
- Tip :The Business User configured should have access to the tables. It will the user who will be displayed as triggering the Data Integration Jobs during Data Import in IBP Inbound flows
SAP IBP Communication Arrangement
- In SAP IBP -> Global Configuration, Perform the below configuration:
- To add planning areas for the /IBP/PLANNING_DATA_API_SRV service, select .
- To define master data types for the /IBP/MASTER_DATA_API_SRV service, select .
- Tip: It is possible to use wildcard character '*' to allow the entire set. For eg: if MD tables are named as Dummy_LOC, Dummy_PRD etc. then just mentioning Dummy* will expose the entire MD table set. Multiple MD sets can be mentioned the same way seperated by ',
SAP IBP Global Configuration
- There are certain default configurations for Delta extraction in Global Configurations which can be changed as per the need.
- The maximum number of delta query definitions is limited by global configuration parameter KF_DELTA_MAX_QUERY_NR. By default, this parameter is set to 10.
- The select section must contain at least one key figure. The maximum number of key figures is limited by global configuration parameter KF_DELTA_MAX_SELECT_KF. By default, this parameter is set to 10.
- The maximum number of time buckets is limited by global configuration parameter KF_DELTA_MAX_TIME_BUCKETS. By default, this parameter is set to 36
Now if all the above done correctly. You should be able to consume the Delta OData Services
The operations exposed for Delta are below
Key Figure Delta Operations
Its also Important to understand the Delta Query Definition (DQD) various Status cycle. The descriptive info is available here
I have prepared a simple flow to understand it easily
As a thumb rule just follow the below points to understand the flow better
- Initial is the initial state after DQD creation or reset and
- executeKeyFigureDeltaLoad will execute the DQD and set the status to Extractable in case of success or Error in case of failure or Processing during execution
- executeKeyFigureDeltaLoad can be executed only if the status is Initial or Cancelled or Confirmed
- executeKeyFigureDeltaLoad will store all the delta data available till the point of execution and make available for extraction until Confirmed or Cancelled or Reset.
- After Extractable status Delta data can be extracted in the same pattern as for normal KF with an additional parameter P_DeltaQueryID with $select
- resetKeyFigureDeltaLoad can be triggered from any state and resets all the delta snapshots to initial date, hence after this there is Initial Load execution
KF Delta Status Flow
Enough of Knowledge sharing, Lets get our Hands dirty 😀
- KeyFigureDeltaDefinitionSet
- Fetch all the existing DQDs
Fetch All DQDs
- Create new
DeltaQueryID should be unique or empty to get back a unique system generated value
_TSTAMP should be suffixed to time period entity.
- Create new
Create DQD
- Fetch selected DQD
DeltaQueryID is required
- Fetch selected DQD
Fetch Selected DQD
- Delete slected DQD
DeltaQueryID is required
- Delete slected DQD
Delete Selected DQD
- Status Polling
- DeltaQueryID is required
Status Polling for Selected DQD
- Import Delta data to KF
- More details on parameters can be found here
Import KF Data
- Execute
- DeltaQueryID is required
Status Processing
Status Extractable
- Extract Data from Last run DQD
- DeltaQueryID is required
- More details on parameters can be found here
Extract KF Delta through selected DQD
- Confirm Last DQD Execution
- DeltaQueryID is required
Confirm Last DQD Execution
- Cancel Last DQD Execution
- DeltaQueryID is required
Cancel Last DQD Execution
- Reset DQD to Initial Load
- DeltaQueryID is required
Reset Entire Delta for selected DQD
That's it! Enough! 😅
However life is not easier yet!
As verified via OSS ticket this Delta APIs is not enabled on OData import in SAP Cloud Integration and SAP Cloud Integration for Data Services to be easily orchestrated. Hence an improvement request has been raised to include it. However there is a hack to call these API's via HTTP, but that's a workaround and a different story 😅.
Please show your support by voting for https://influence.sap.com/sap/ino/#idea/280968
Thanks and Please feel free to motivate by Liking and sharing this blog!
Best Regards,
Aman Varshney
- SAP Managed Tags:
| User | Count |
|---|---|
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
