|
Your SAP Resource » Publications » SAP Experts » BI Expert Online |
|
|
SAP BI/BW/BusinessObjects
|
Part of the
|
|
|
|
|
|
|
|
Knowledgebase » Volume 8 (2010) » Update 6 SAP BusinessObjects Planning and Consolidation
|
|
See how to set up controlled batch jobs for SAP BusinessObjects Planning and Consolidation, version for the Microsoft platform, with any corporate scheduling tool. This allows you to load end-to-end data from SAP NetWeaver BW to SAP BusinessObjects Planning and Consolidation and vice versa. Follow the steps for creating a batch file on the SAP BusinessObjects Planning and Consolidation application server to execute the scheduled SQL Server Integration Services package on the SAP BusinessObjects Planning and Consolidation data manager. |
Categories: ETL, SAP BusinessObjects
| Key Concept |
| SAP BusinessObjects Planning and Consolidation, version for Microsoft, accepts data only in flat file format. SQL Server Integration Services (SSIS) packages are used to accept data from the file, transform the data into the desired format, and execute the SAP BusinessObjects Planning and Consolidation-specific tasks that load the data into SAP BusinessObjects Planning and Consolidation and perform tasks such as dimension processing and optimization. |
For companies implementing SAP BusinessObjects Planning and Consolidation 5.1 or 7.0, version for the Microsoft platform, several challenges are involved with setting up job scheduling and integrating SAP BusinessObjects Planning and Consolidation with the rest of the enterprise reporting landscape. While the Microsoft version provides a time-based job scheduling interface for SQL Server Integration Services (SSIS) packages through data manager, most companies typically schedule extraction, transformation, and loading (ETL) jobs using third-party scheduling tools that do not provide an easy interface with SAP BusinessObjects Planning and Consolidation.
When loading data into SAP BusinessObjects Planning and Consolidation, version for the Microsoft platform, you need to execute SSIS packages within the data manager, using standard SAP BusinessObjects Planning and Consolidation functionality, such as validating input records, logging reject records, and capturing the data load history. However, to have controlled scheduling and to integrate the SAP BusinessObjects Planning and Consolidation jobs into the overall enterprise-wide ETL schedule, it is beneficial to be able to trigger SSIS packages using any other scheduling tool and still have them execute within the data manager.
I present an easy-to-implement process for executing SSIS packages with a third-party enterprise scheduling tool. This process enables you to create a batch script on the SAP BusinessObjects Planning and Consolidation application server that can trigger the scheduled SSIS packages. The script also gets the return codes based on the execution status of the jobs and passes them on to the enterprise scheduling tool. When you pass the necessary parameters to it, only a single batch script is needed for triggering all the SSIS packages in an entire SAP BusinessObjects Planning and Consolidation environment.
Would you like to see the full version of this article?If you are an electronic license holder to BI Expert, please click here to log in. If you would like information about becoming an electronic license holder — and having 24/7 unrestricted access to all articles and content in the BI Expert online knowledgebase — click here to see the available subscription options. Or call 1-781-751-8799 to speak directly with a subscription and licensing specialist about customized access for you and your team. Isn't your SAP implementation worth world-class information support? |
|
Copyright © 2010 Wellesley Information Services. All rights reserved. Email: customer.service@bi-expertonline.com.
|
