ABAP REPORTS: February 2009

SAP BW Complete Course

Here is the list of all posts labeled under SAP BW and you can browse all the topics here below.

Components of data ware house

How to construct data ware house?

How to get better performance with data ware house?

Data ware house building strategies

Data flow in SAP BW

Sample SAP BW report

SAP BW third party solutions

How to log on to SAP BW admin. environment

How to start SAP BW project ?

Data flow between SAP and BW

Activating BW business componets part one and two and three

Preparing SAP for BW

ABAP TOPIC WISE COMPLETE COURSE

BDC OOPS ABAP ALE IDOC'S BADI BAPI Syntax Check
Interview Questions ALV Reports with sample code ABAP complete course
ABAP Dictionary SAP Scripts Script Controls Smart Forms
Work Flow Work Flow MM Work Flow SD Communication Interface

After installing the BW add-on in the SAP R/3 OLTP instance, we need to define the remote logon connection in SAP R/3 OLTP for the SAP BW instance. This is a five-step process for the SAP BW 1.2B add-on, as outlined here:

Create an ALE user, transaction SU01, to be used for remote logon to SAP BW from SAP R/3 OLTP. Make sure that this user, usually ALEREMOTE, has sufficient authorizations for the RFC and ALE components, as described in the installation guide. The ALE user must have profile S_BI-WX_RFC. This profile consists of sub-profiles such as B_ALE_ALL, S_APPL_LOG_A, S_IDOC_ALL, and S_RS_ALL.
Set up a logical system name for SAP BW. The logical system is used by SAP R/3 to connect the SAP BW instance for data transfer. To set up a logical system name on SAP R/3 OLTP, run transaction SM30 and edit table V_TBDLS. Create a new entry for the SAP BW logical name, such as XDWCLNT100.
Assign SAP BW client to the logical system name. Here you associate SAP BW client to a logical name. Using transaction SM30, edit table T000 and add entry.
Define an RFC destination for SAP BW. In Steps 1 and 2, you simply defined a logical system name and associated it to an SAP BW client, but you cannot connect to the remote SAP BW instance. This is because you have not defined the network-level information for such communication links. To make this happen, you need to define an RFC destination in SAP R/3 OLTP for SAP BW using transaction SM59. Here the DEST is your system logical name defined in Step 1, XDWCLNT100, and the connection type is 3; enter the IP address and other user information to log on. Select the Test Connection and Remote Logon options to make sure that you can access the remote BW instance. If the Test Connection option fails, check to make sure that SAP R/3 and SAP BW are on the network, that SAP BW is running, that both have the correct network configuration, and that both servers are visible on the network. Check with your networking support team to resolve these issues.
Verify the workflow basic setting. Run transaction SWU3 and create the workflow basic setting. Click the AutoCustomize menu option to verify that the workflow setting for SAP BW components is set properly, as shown below on SAP R/3 version 3.1H. Remember that only the Workflow runtime system needs to be confirmed here. Verify that the results show a green check mark or traffic lights for the following items:

An active plan version exists
RFC Destination Workflow
Workflow runtime customizing complete

Activating business content in SAP part three

How to logon to SAP BW

SAP BW third party solutions

Data flow between SAP and BW

SAP BW activacting business content part three

This part is in continuation with activation of SAP BW business content part one and two.

Loading Queries for the InfoCubes from the Business Content

To actually use an InfoCube for business analysis, you need queries. Four types of Query objects are provided in SAP BW business content:

REP: Query
STR: Templates
CKF: Calculated Key Figures
VAR: Variables

A REP is a complete query that is ready to perform an analytical function; for example, Sales Analysis by Geography. Moreover, REP-type queries are formatted specifically to customer needs.

The query template STR is simply a raw definition of a query to fetch data from an InfoCube. Because these templates are generic, they are not very sophisticated in terms of query formats and restrictions. These are used to quickly build queries for end users.

A query consists of several elements. Calculated Key Figures, CKF, and Variables, VAR, serve a unique role in query logic. The CKF are used to define a new key figure based on some existing key figures or by means of formulas. Calculated Key Figures can be defined at the InfoCube level or within a query.

If Calculated Key Figures need to be used by many queries or users, define them at the InfoCube level. You do this because when a key figure is defined in a query, it is limited to that specific query. However, when you define it at an InfoCube level, it is available to all users.

Calculated Key Figures in SAP BW queries are used to compute values for new data elements. For example, a new key figure sales tax is calculated based on an order taxable amount multiplied by the tax rate. However, the Variables, VAR, defined in SAP BW queries, are most often used to filter data for the queries.

Sometimes such variables are also used in formulas for Calculated Key Figures. For example, if you want to select data for a specific time period, you can define two variables to hold start and end dates for that selection criterion. Moreover, begin and end date periods can also be used by a Calculated Key Figure for average sales during that begin and end date period.

SAP BW business content consists of all of the preceding types of query objects for InfoCubes. To activate query objects for a specific InfoCube, select Query Objects from the Business Content menu, and select the query type and the InfoCube. The system displays all available queries. Select all queries and activate, as shown in the figure.

Then activate the Templates, Calculated Key Figures, and Variables associated with each InfoCube.

Activating Channels

Channels are primary components of the SAP BW information delivery model. Channels are based on information objects, such as queries, that are managed within the InfoCatalog. To use SAP delivered channels, select Channels from the Business Content menu.

Select Channels from the Technical Name list, as shown in figure below. In this example, I selected 0SD_CH01, Sales and Distribution Channel to copy from the SAP delivered content. After successfully loading the selected channel in SAP BW, verify that InfoCatalog recognizes the added channels. To do so, go back to the Administrator Workbench and click the InfoCatalog icon.

To assign channels to users, click the User channel assignment tabstrip. All users defined in SAP BW are listed on the left under the User tree. All channels defined in the InfoCatalog are shown on the right. To assign channels to users, select a user from the left, then drag and drop to the User-channel assignment folder.

This completes the Business Content activation in the SAP BW instance. It is a very manual process. In SAP BW version 2.0, however, these processes are very much automated. Once you activate a higher level object (for example, an InfoCube), the system automatically activates everything needed to completely build and activate the InfoCube. In SAP BW 1.2A Patch 12, a similar automated process is used to activate the SD Demo InfoCube. (8)

How to logon to SAP BW

SAP BW third party solutions

Data flow between SAP and BW

SAP BW Activating Business Content part Two

This post is in continuation with SAP BW activating business content part one . Going through that article first will give you comfort in understanding the present topic.

Enabling Business Content in SAP BW

The enabling of business content is a long process. First you have SAP R/3 instances defined as a data source in SAP BW. Then select object categories one by one, transfer SAP versioned objects to your active client, and, depending on individual object types, construct or verify transfer/communication structures and update rules to populate the InfoCubes. Finally, activate queries and channels associated with an InfoCube.

From the Administrator Workbench, choose Tools. From the drop-down menu, select Business Content. This opens another submenu and displays a list of objects, as shown below.

Activating InfoObjects

To activate InfoObjects for a specific InfoCube, such as the Customer InfoCube, select InfoObjects from the Business Content menu. This launches the InfoObject display screen.

Select all InfoObjects, transfer the SAP delivered version, and save. Then go back to the InfoObject Edit window, select these new InfoObjects, and click the Activate icon. This activates all selected InfoObjects.

After you activate InfoObjects, SAP BW displays an activation report. Make sure that there are no activation errors. If there are, first correct the InfoObjects causing the problems and then activate only the inactive InfoObjects.

InfoObjectCatalogs

After activating the InfoObjects, activate the InfoObjectCatalogs. Select the InfoObject Catalogs option from the Business Content menu. The activation process is similar to activating the InfoObjects, but you select InfoCatalog for characteristic or key figure for individual InfoCubes.

Activating InfoCubes

Business Content (SAP BW 1.2B Patch 12) provides more than 45 InfoCubes . Again, not all customers need to activate all InfoCubes. Most customers will load specific InfoCubes to assess their functionality and enhance the content to meet their needs. You can create new InfoCubes based on SAP BW-provided InfoCubes as templates. Then you remove or add elements as needed to implement your analytical applications.

To activate an InfoCube, select InfoObjects from the Business Content menu, and then select an InfoCube to activate. For example, to activate the SD Customer InfoCube, select 0SD_C01 from the list of available InfoCubes, as shown below.