Sap Bw Parallel Data Load

Good Essays
1 Scenario
You have an SAP BW system with several (application) servers. You would like to distribute the workload of the data loads and other data warehouse management activities in a way that fits your needs best. This could mean that you would like to have all processes distributed across all available servers or that you would like to have one dedicated server for these processes.
2 Introduction
SAP uses the terms instance and application server synonymously. In order to avoid misunderstandings we use the term instance for an SAP instance (application server) in this document. For a physical machine we use the term server. Some of the settings described in this document are done on an instance level, some on a server level. If you don’t have several instances (of the same SAP system) on one server you don’t have to draw this distinction between instance and server when reading this document.
There are a host of functions and settings in the area of load balancing provided by the basis system (Web Application Server). However, these have been designed primarily for SAP’s ERP system. Customizing these features for optimal use with SAP BW requires further considerations. The challenges presented with data load processing originate from the fact that many fairly long running processes can be started almost simultanesouly. The standard SAP load balancing approach takes the quality of the instances into consideration when distributing the load. This quality is evaluated in regular intervals (five minutes by default). Within one interval a lot of parallel processes may be started on the best instance, using a lot of work processes while the other instances are idle. An optimal distribution of BW OLAP workload or data load resource consumption cannot readily be achieved with this standard method.
Without adequate planning, and under heavy workload (peak) conditions, the risks can increase that hardware becomes a bottleneck; a limited number of

You May Also Find These Documents Helpful

  • Good Essays

    SAP BW Infosource

    • 645 Words
    • 3 Pages

    together, summarized into a single unit. It prepares consolidated data for updating to the data targets. InfoSources contain either transaction data or master data (attributes, texts and hierarchies). When you want to load the related data from different datasources to the data targets, Infosource comes into picture. Role of InfoSource in SAP BW- There is a difference in use of InfoSource between BW and BI. In BW, a DataSource is assigned to an InfoSource. If fields that logically…

    • 645 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    sap data archiving

    • 2029 Words
    • 11 Pages

    SAP DATA ARCHIVING INDEX 1. Introduction................................................................................................... 2. Archiving Objects......................................................................................... 2.1 Definition..................................................................................................................................... 2.2 Archiving objects and related tables................…

    • 2029 Words
    • 11 Pages
    Powerful Essays
  • Good Essays

    Big Data Sap Hana

    • 6226 Words
    • 25 Pages

    WHITE PAPER Big Data: Trends, Strategies, and SAP Technology Sponsored by: SAP Carl W. Olofson Dan Vesset August 2012 THE DAWN OF THE INTELLIGENT ECONOMY The intelligent economy has arrived. The convergence of intelligent devices, social networking, pervasive broadband communications, and analytics is redefining relationships among producers, distributors, and consumers of goods and services. The growth in volume, variety, and velocity of data has created new challenges and opportunities.…

    • 6226 Words
    • 25 Pages
    Good Essays
  • Good Essays

    Bw Manufacturing

    • 582 Words
    • 3 Pages

    BW MANUFACTURING COMPANY CASE SUMMARY The owners of BW Manufacturing, a small manufacturer of gas grills, have prepared a preliminary budget for the upcoming year and would like to assess the financial impact of several alternative scenarios, including dropping a product; changing the price on a product, with a resulting increase in volume; and shifting advertising focus, with a resulting shift in volume from one product to another. A new budget must be prepared. At year-end, the actual results…

    • 582 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Big Data SAP HANA

    • 263 Words
    • 2 Pages

    Case Study – AirAsia Formula(on Valida(on In 2001, Time Warner Execu(ve Tony Fernandes purchased the ailing, debt-­‐riddled, government-­‐owned AirAsia. In a remarkable feat (using blue ocean strategy principles) Fernandes engineered a remarkable turnaround, turning a profit in 2002 and swiJly opening mul(ple new routes…

    • 263 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    SAP ABAP

    • 11815 Words
    • 46 Pages

    SAPtips Document Library We help SAP clients and consultants solve business and technical problems with our library of undocumented features, timesaving solutions, and best practices. SAPtips covers all phases of SAP installations, from full-scale implementation issues to post-golive optimization and functionality enhancements. SAPtips is geared towards helping users maximize their current ERP investment. Subscribe to SAPtips and your subscription includes the next year's worth of SAPtips issues…

    • 11815 Words
    • 46 Pages
    Good Essays
  • Good Essays

    generator load

    • 472 Words
    • 2 Pages

    GENERATOR SET KW & KVAR LOAD SHARING IN A PARALLELED SYSTEM LOAD SHARING Load sharing is defined as the proportional division of the kW and kVAR total load between multiple generator sets in a paralleled system. Load sharing is essential to avoid overloading and stability problems on the systems’ generator sets. ACTIVE POWER (KW) LOAD SHARING When generator sets operate in parallel, the engine speed governor of each generator set determines the proportional sharing of the total active power…

    • 472 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    SAP

    • 422 Words
    • 2 Pages

    What challenges was VLF facing before the SAP implementation? Before the implementation of SAP, VLF faced major problems that affected their efficiency and effectiveness. The hospital would accept thousands of patient a month, which required coordination from different medical departments. With each patient, numerous forms and preliminary steps needed before and after a medical procedure take place. However, due to an inefficient system, the desired high-quality standard of the VLF was sometimes…

    • 422 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    BW 12B Essay

    • 751 Words
    • 2 Pages

    by Harlan Ellison. **Ben, this essay should, as least in part, focus on the Harlequin and Harrison Bergeron as protagonists fighting against their respective societies, as represented by the antagonists in the story. This is the most compelling parallel between these two stories** **Ben, I left your original spelling and grammar mistakes intact** The human species will never be a utopia, humans are never in agreement in the free world because every culture in some way shape or form disagree with…

    • 751 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    load

    • 7240 Words
    • 29 Pages

    Blue Ocean Strategy: FROM THEORY TO PRACTICE W. Chan Kim Renée Mauborgne F or twenty-five years, competition has been at the heart of corporate strategy. Today, one can hardly speak of strategy without involving the language of competition: competitive strategy, competitive benchmarking, building competitive advantages, and beating the competition. Such focus on the competition traces back to corporate strategy’s roots in military strategy. The very language of corporate strategy is…

    • 7240 Words
    • 29 Pages
    Powerful Essays