Well, If you are reading these lines, you must have heard the buzz around BI in Netweaver 2004S. You might even browsed the “BI in SAP NetWeaver 2004s” forum, and now you are ready to jump into the (deep) water and build your first model in NW2004S. This comprehensive blog post is aimed to help you to get started and minimize the potential frustrations along the way.
I assume that (1) you either have access to a NW2004S sandbox system at your company or you have downloaded and installed the nice NW2004S ABAP Sneak Preview system (load it at Load NW2004S Sneak Preview) and (2) that you have at least some theoretical experience with previous versions of BW .
Ok, so let's get started.
Our goal is to build and populate a DSO (DataStore Object, the new ODS) that will display Flights data. More specifically, data will be sourced from the SFLIGHT table available in our NW2004S system. The SFLIGHT table is part of the SAP Flight data model (A simplified modeling of an airline flight booking system available in every SAP system).
1.
First let's check whether the SFLIGHT table in our system is populated with data.
Populate the SAP Flight tables (skip this step if you found some data in table SFLIGHT in the previous step).
3.
We will now build the InfoObjects required in our data model. For the sake of convenience, we will build only 6 InfoObjects ( 4 characteristics and 2 key figures).
Build your DataStore Object (DSO)
5.
Create your DataSource in the NW2004S system. Our DataSource will be a generic datasource (built from transaction RSO2) that will source data from the SFLIGHT table in our BI system.
Important note: Creating a DataSource in the source system requires that you’ll provide a developer key. In case you are working on your company’s sandbox system, ask your Basis team to supply you one. In case you are following these steps in an NW2004 ABAP Sneak Preview system, you will find your developer key at http://www.sap.com/platform/netweaver/minisap.epx. When trying to apply it you will however receive an error :sad: :
The reason is that the developer key works only for user BCUSER, and here I tried to apply it for user GILADW.
Two possible workarounds for this problem:
a. In client 001 (the BI client) Execute transaction SU01, Create a user named BCUSER , provide it with SAP_BW_ALL role and SAP_ALL profile. Then login to client 001 with the newly created user and execute the steps outlined below.
b. Login to client 000 with user BCUSER and password minisap and execute the steps outlined below.
o Execute transaction RSO2.
o Create a transaction data DataSource named ZFLIGHT_DS
o Complete the screen as shown below:
For more information on transformations see: Transformations
o Right click the ZFLIGHT_DS datasource and select “Create Transformation”.
o Specify the ZFLIGHTS DSO as the transformation target
o Map the transformations as specified below:
o Activate the transformation object
8.
Create and execute a DTP.
The DTP is a runtime object used in order to transfer data from persistent objects in BI. For more information on DTPs see: Data Transfer Processo In RSA1, go to the InfoProvider tab, right click the ZFLIGHTS DSO and select “Create Data Transfer Process”
o The source and targets objects will be filled automatically
o Click on the green checkmark
o Activate the DTP
o From the Execute tab, click on “Execute”
o When prompted whether you want to Change the load method, select yes.
9.
Verify your Data reached the DSO Active table
References:
Keller H, Sascha Krugger, ABAP Objects, An Introduction to programming SAP applications.
BI350 course material
Help.sap.com - NW2004S