Precog’s AI-powered, no-code data integration for SAP

352 results

  1. Automate Data Loading in SAP BusinessObjects Planning and Consolidation 7.5

    /BILearn a data loading automation solution for SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver. With this solution, business users can start and finish data loading by themselves by clicking a couple of buttons in the SAP BusinessObjects Planning and Consolidation client interface and save the loaded data in a different version. Key Concept…...…
  2. Identify Failed Data Loads with This Check Tool

    Dealing with data load failure is an inevitable part of BW support team members’ jobs. Expedite the way you check for data loads using this standardized process. Key Concept Daily and monthly loads fail from time to time. If you have no process in place to identify these failures at the time of failure, then…...…
  3. Load Time Data from an External System Into CATS with Ease

    Learn how to avoid problems when you import time data from a spreadsheet or external systems into the Cross-Application Time Sheet. Selecting the best method to develop an interface is the key to success. Key Concept Cross-Application Time Sheet (CATS) is a standard SAP transaction that allows users to capture time data for multiple SAP…...…
  4. Fully Automate Your BW Load Processes with Standard Tools (and a Little Creativity)

    Reading time: 15 mins

    Manual data loads, such as daily and monthly refreshes, can impede your BW team and increase the risk for human error. Fortunately, data load automation is an attainable goal. The author demonstrates how to automate your load processes using examples, InfoPackages, and custom code.   Many BW teams overlook their systems’ ability to completely automate…...…
  5. Load Data into Two BW Systems from One R/3 Source with Zero Downtime

    Are you worried about what adding another BW instance to your ERP system may mean to your end users? Here’s a technique that allows you to bring another BW system online without any outages on the source system. It can be used for other tasks such as reinitializing the system to reduce the impact on…...…
  6. How to Dynamically Load Multiple Files from SAP NetWeaver Application Server (Unix)

    Save time and avoid risks by using this ABAP program and process chains to load multiple flat file data into SAP NetWeaver BW. The code provided is for a Unix environment. Key Concept All the data stored in SAP NetWeaver BW is not necessarily sourced from SAP ERP Central Component (SAP ECC). Therefore, you might…...…
  7. Avoid Full Data Reload: Use Reverse Loading to Substitute InfoCube Characteristic Values

    Become familiar with a method for substituting InfoCube characteristic values that avoids a full data reload: reverse loading. Key Concept A characteristic is an object that presents the elementary dimension component in the BW star schema model such as customer, product, company, or sales organization. Key figures of an InfoCube relate to characteristics that supply…...…
  8. SAP Data Services Part 3: How to Extract, Transform, and Load Data into SAP HANA

    Examine and compare the classic SAP Data Services approach for extracting, transforming, and loading (ETL) processes to the functionality that is native to SAP HANA to determine optimal integration. Key Concept Certain extract, transform, and load (ETL) processes have been pushed to SAP HANA, which directly affects the integration with SAP Data Services. ETL is…...…
  9. Increase Load Performance by Buffering Number Ranges

    Reading time: 8 mins

    Learn how number range buffering can improve the performance of your SAP NetWeaver BI or SAP BW system. Key Concept By buffering the number ranges, the system reduces the number of database reads to the NRIV table, thus speeding up large data loads. The SAP BW system uses number ranges when loading master data or…...…
  10. Conditional Execution: Prevent Incorrect Data in Transactional Data Loads

    See how you can use conditional execution in your process chains to halt additional transactional data loads when you have outdated master data. Key Concept In SAP NetWeaver BI 7.0, the data transfer process (DTP) supports error handling for DataStore objects. The system sorts failed data load records and writes them to a temporary request-…...…