Search this website
Find Placement Papers, Entrance Exam Question Papers, Aptitude and Technical Questions, How-to Guides, White Papers and Tutorials
Technical Questions, Tutorials, User Guides, Step by step procedures, How to documents in SAP BI (Business Intelligence) or (BW - Business Warehouse). BI is a data warehouse product from SAP.
Transcript of SAP Know How network Conference on using HR with SAP BW. Discusses HR Business Content for SAP BW and how to secure sensitive (authorization) HR data in SAP BW.
This document explains on how to organize various activities in BW production system. Activities like Loading Master Data, Attribute CHane run, Loading data into Infoproviders, Aggregate Rollup etc.
A white paper on increasing the benefit of your BW Implementation
Enterprise Wide BW --BackgroundBackground
A step by step guide on performance tuning SAP BW reports with OLAP Cache
A successful SAP BW implementation requires that end user query response times are consistently running in the fast to reasonable range, in order to gain user acceptance and help drive overall productivity. There are many factors that influence the response time of a BW query, including its complexity, the volume of data involved, architecture of the data model, and the existence of pre-summarized or pre-calcultated objects. A sound OLAP performance strategy includes the utilization of several of the important tools that are available for SAP BW tuning efforts, such as multi-provider, aggregates, and pre-calculated templates. Introduced in SAP BW version 3.0, the OLAP cache offers a valuable compliment to these other useful techniques used for accelerating query response times.
The OLAP cache is architected to store query result sets, and to give all users on an application server access to those result sets. If a user executes a query, the result set for that query’s request can be stored in the OLAP cache. If that same query (or a derivative) is then executed by another user, the subsequent query request can be filled by accessing the result set already stored in the OLAP cache. In most cases, a query request filled from the OLAP cache is
significantly faster than queries that receive their result set from database access. A savvy performance tuning strategy could include scheduling background jobs to load specific query result sets into the OLAP cache. Therefore, initial user query executions against newly loaded data can “hit” and OLAP cache result sets in running queries, boosting performance significantly. For more information about
This is a transcript of SAP Know How conference on SAP BW OLAP Cache to improve reporting performance.
SAP has grown to be the most important information system for many companies. These companies use SAP BI as the central tool for operational and analytical reporting. Companies make decisions of local and global importance based on the results of reporting in SAP BI. As the information stored within SAP BI is used as the basis of company-wide decisions and strategies, data quality plays a crucial role.
One of the most important aspects of data quality is data consistency. Because SAP BI as a data warehouse integrates, stores and transforms (prepares) data, the consistency of data between the different processing steps is a key factor. This how-to-paper describes the possible data reconciliation scenarios and the relevant implementation steps that you can apply in your system to check whether data is consistent in the SAP source system and SAP BI. In addition, these scenarios also support you in determining the causes of data inconsistency.
As well as this how-to paper, you can find the most up-to-date information about this BIrelated issue in SAP Service Marketplace: http://service.sap.com/bi
This is a step by step guide on including ABAP programs in process chains.
You want to incorporate functionality in a process chain that is not provided by the delivered process types. You can implement the needed functionality as an ABAP/4 program and do not need a customer defined process type. For customer defined process types please refer to the documentation of process chains.
This document describes the steps to incorporate an ABAP/4 program into a process chain. The used example of deleting and recreating an existing secondary index of an ODS object can be exchanged by any other example. The sample program does not claim to be complete or correct.
The search for characteristics (e.g. 0VENDOR) within the F4 (value) help is case sensitive, i.e. the vendor ‘WACKER’ is only found if the search pattern contains only upper case characters (other spellings do not lead to the desired result). If you have multiple source systems, which provide the data to the BW system in different spelling, it is not possible to perform a global analysis for the vendor ‘Wacker’.
This paper focuses on the tasks of an ASP vendor when implementing SAP BW. It offers best practice solutions for implementing SAP BW in this context.
The general conditions of this analysis are to provide information on the properties of an SAP BW data warehouse in comparison to operative systems, and to examine what an ASP vendor particularly requires from a data warehouse.
After these general observations, support is given in the areas of modeling, authorizations, reporting, performance and administration. However, it is to be noted that this document does not constitute a complete guide to implementing SAP BW, but focuses on particular aspects of an SAP BW project for ASP vendors.
From a technical viewpoint, all observations and implementation tips are based on the following SAP BW releases:
· SAP BW 3.0B SP 21
· SAP BW 3.1C SP 15
· SAP BW 3.5 SP 3
From SAP BW 3.1 Content onward, SAP BW Business Content will be delivered as a separate Software Component “BI Content Add-On”.
A step by step guide to download SAP BW hierarchy into a flat file.
This document describes the how to download a master data hierarchy to a flat file. The file format matches the hierarchy upload format for sorted and time-depended hierarchies (IDOC).
This document explains how to validate the data in SAP BW for data consistency and how to handle errors in SAP BW.
SAP BW has grown to be the most important information system in many companies. SAP BW provides key information for all core business areas. That is why our customers’ confidence in the correctness of data is very important. This guideline gives suggestions on how to analyze an SAP BW system for data consistency using the information and tools provided by SAP.
This document was written specifically for SAP BW versions 3.x and 2.0B/2.1C. However, some parts only apply to BW 3.x as are highlighted in the text.
The functionality described in this document is for use by skilled consultants and advanced technical team members. Please do not attempt to work with features that could impact the efficiency of the system in areas where you have little or no training or experience.