This whitepaper, provided by SAP, is a must for those use SAP BW and it provides recommendations about jobs and tasks that have to be performed on a regular basis to ensure system performance and stability in a BW system. It may be also useful for you to check Daily BW Systems Checklist
This list of transactions is designed to guide a Basis Admin team member through the process of keeping tabs on major systems issues and root cause issues and trends for each system in the landscape.
This will only identify and help triage issues to Helpdesk, Infrastructure, OS team or DBA team, Basis or functional developers or whomever…but guarantees that each system in a landscape gets a regular, weekly look. The goal is to eliminate root causes of repeating issues.
Master data is reference data about an organization’s core business entitles. These entities include people (customers, employees, suppliers), things (products, assets, ledgers), and places (countries, cities, locations). The applications and technologies used to create and maintain master data are part of a master data management (MDM) system. MDM, however, involves more that applications and technologies, it also requires an organization to implement policies and procedures for controlling how master data is created and used.
SAP NetWeaver BI Integrated Planning now has the ability to allow users to upload data directly into transactional cubes. The solution outlined in this paper provides a how-to guide to use flat file upload functionality in BEx. It also shows step-by-step how to use a query to preview the data uploaded before deciding whether to save (write) the data to the target cube. This is basically replicating the BPS file upload functionality in IP. The solution depicted in this paper provides the user with the familiarity of BEx, but with the flexibility of Integrated Planning.
The BEx-Query Designer is used to prepare analysis – known as queries – of all data stored in the SAP BW. The Query Designer can be invoked via the Web or from MS Excel or can be installed as a desktop application. After the Query Designer has been started, the Open dialog allows a fast access to the InfoProviders in the SAP BW and the queries already present.
This presentation package consists of the following topics:
Currency translation allows you to translate key figures with currency field that are present at the InfoProvider level with different currencies to a specific currency on the fly while executing the report. It can also be used in transformation rules to translate the amount key figures with different currencies to a standard currency while loading the data into BW data targets. The document explains the step by step procedure to implement the currency translation scenario.
There are several methods to generate reports in SAP, including