Hi ,
Goto your ODS>Right Click>Click on Generate Export Datasource--->then create transformation choosing target as your Cube.
Then create an DTP,activate it and Execute it.
***PS : Its not mandatory that every field should be mapped.Map the fields which are matching and create DTP.If there are any extra fields in ODS n not in the Cube data for those Objects will be missing - Columns will be missing in the Cube also there may be some aggregation n thus resulting less number of records in Cube when compared to DSO.
pls refer to this:
A beginner's guide to your first BI model in NW2004S: Reference: sdn.sap.com
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.
- Execute transaction SE16 and type SFLIGHT in the table name.
- Click on the green checkmark and click on "Number of entries".
- If the number of entries is 0, we can safely assume that the SAP Flight tables weren't populated.
2. Populate the SAP Flight tables (skip this step if you found some data in table SFLIGHT in the previous step).
- Execute transaction BC_DATA_GEN and click on the Execute icon.
- The SAP Flight data model will be now populated with demo data. This will take around 10 minutes (depends on your system’s resources).Note that in case that data is currently available in the SAP Flight tables, it will now be suppressed by the auto-generated data.
- Lets now look into the SFLIGHT table data model (transaction SE11):
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).
- Execute transaction RSA1, from the left navigation pane, click on "InfoObjects".
- Right Click on the upper node in the InfoObjects tree and click on "Create InfoArea"
- Create an InfoArea with technical name ZFLIGHT and description "Flights".
- Right click on the new created InfoArea and create two InfoObject Catalogs (that will be used to contain your custom InfoObjects). Activate your InfoObjects Catalogs using the path InfoObject Catalog>> Activate :
- Flights Characteristics – ZFLIGHT_CHAR
- Flights Key Figures – ZFLIGHT_KF
- Right click on the “Flights Characteristics” InfoObject Catalog and click on “Create InfoObject” to create the following Characteristics with the following Char id, description, data type and length:
ZCARR_ID – Carrier ID, CHAR, 2
ZCONNID – Connection ID, NUMC, 4
ZFLDATE – Flight Date, Reference Characteristic: 0calday
ZPLANTYPE – Plane Type, CHAR, 10
- Right click on the “Flights Key Figures” InfoObject Catalog and click on “Create InfoObject” to create the following Key Figures with the following id, description and data type:
ZPRICE Flight Price, Amount, Unit/Currency: 0currency
ZPAYMENTSUM Flight Total Income, Quantity, Number
- Make sure you activate each of the InfoObjects
- Refresh the InfoObjects tree to make sure all InfoObjects are listed under their InfoObject Catalog
4. Build your DataStore Object (DSO)
- Execute RSA1 and click on InfoProviders tab
- You’ll notice the “Flights” InfoArea. Create and Activate your DataStore under that InfoArea. Name it Flight DataStore (technical name – ZFLIGHTS).
- In the DSO settings, set the Type of DataStore object to be “Write Optimized”. This type of DataSource consists only of one table of active data (thus, there is no need to activate requests after loading them). This allows for faster data loads into the Enterprise Data Warehousing layer.
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 :(:
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.
- Execute transaction RSO2.
- Create a transaction data DataSource named ZFLIGHT_DS
- Complete the screen as shown below:
- If you are working on the ABAP Sneak Preview, make sure you are logged in to client 001.
- Execute RSA1 and select Source Systems
- Highlight your BI system, right click and select display DataSource tree.
- Right click on DataSources for <your_BI_system_name> and select Replicate DataSources.
- Select to create your ZFLIGHT_DS DataSource as a DataSource and click the green check mark.
- Right Click on your DataSource and activate it.
6. Now we need to create and execute an InfoPackage. Note that in NW2004S, the InfoPackage is used to transfer the data from the source system to the PSA. We will use the Transformation and the Data Transfer Process (DTP) to actually execute the transfer of data from the PSA to the InfoProviders.
- Right click on your DataSource and select, create InfoPackage.
- Create an InfoPackage named “Transfer Flights Data”.
- Note that the option “Only PSA” is the only one available in the InfoPackage Processing tab.
- Execute the InfoPackage
- From your DataSources screen, right click the ZFLIGHT_DS DataSource and click on “Manage”. This is the new place to perform PSA maintenance activities.
7. Create a Transformation object. For more information on transformations see: Transformations
- Right click the ZFLIGHT_DS DataSource and select “Create Transformation”.
- Specify the ZFLIGHTS DSO as the transformation target
- Map the transformations as specified below
- 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 Process
- In RSA1, go to the InfoProvider tab, right click the ZFLIGHTS DSO and select “Create Data Transfer Process”
- The source and targets objects will be filled automatically
- Click on the green checkmark
- Activate the DTP
- From the Execute tab, click on “Execute”
- When prompted whether you want to Change the load method, select yes.
9. Verify your Data reached the DSO Active table
- Right click your ZFLIGHTS DSO; select manage, go to the contents tab, click on “Active Data” and preview your SFLIGHT data in the DSO.
References:
Keller H, Sascha Krugger, ABAP Objects, An Introduction to programming SAP applications.
BI350 course material
Help.sap.com - NW2004S
**PLS assign points if info is useful**
Regards
CSM Reddy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.