Tuesday, 17 July 2012

Creating dataflows through wizard in SAP BW 7.3

This documentation is copyright by SAP AG.
SAP BW 7.3 version has come up with some quite new features which enable less effort for developers to develop the BW objects. Following is the one reduces lot of developer’s time & efforts.
Here I am going to talk about the customization of BW developments which involves creations of dataflow or copying of existing dataflow for customizations.
In our projects we might have faced thesituation where we have to upload the data through file system (flat file) or through existing Data sources, for uploading data to data target we need to create data source for Flat File, data target, transformation and DTP manually, for simplifying the creation of dataflow process a new wizard tool introduced in SAP BW 7.3. By using dataflow wizard tool we can create an entire dataflow with existing/new objects, also dataflow templates can created with SAP delivered pre-defined dataflow template, this tool reduce the considerable amount of time for creation of data model .

Steps for dataflow from flat file to Cubes are given below:

Go to T Code – RSA1 then click on Wizard tool icon.
Untitled.jpg

It will take you to wizard screen where developer will create the entire dataflow.
2.jpg


Click on continue.
Specify the file path in the wizard initial screen (Flat file Path) check below
Give a technical name of the data source (For creating new data source for uploading data from flat file),Description of the data source, Specify the file system name
and 
Type of data source (Transaction, master data attribute and text) then click on continues
3.jpg
4.jpg
5.jpg
6.jpg


We can preview the .csv file from this wizard itself by clicking the Display button next to File type text box.
7.jpg


Click on continue then it will take you to next level of wizard selection.
Now we can see the datatarget area, here we have to specify type of infoprovider like DSO,InfoObject,Cube..etc..then subtype for Infoproviders ( Standared/writeoptimized for DSO,Attribute/text for InfoObject etc...)then give technical name and description of the infoprovider (can also create new data target)
8.jpg
9.jpg


After providing infoprovider details then click on continue
Next step :Field assignment
In this step we can assign(map) existing Infoobjects to specified fields, also we can create new IinfoObject by clicking New InfoObjects icon in the field assignment of wizardtool .
You need to specify field type like Primary characteristic/Display attribute/ Compounded characteristic/Navigation Attribute for IinfoObjects,Key fields and data fields
for DSO,refer below screen.
10.jpg
11.jpg


Before clicking finish icon you can check the information about generated/created objects like transformation and DTP then click on finish .

Restart the transaction RSA1, now you can see a new dataflow under infoprovider segment .

With new dataflow wizard tool we can create entaire data flow model with less effort, hence we can save time and it’s very simple to perform.
12.jpg
13.jpg
Here the entire data flow we defined is reflected here , then we can activate the transformations,define Info packs & DTP's for data loadings.

Note: Using this wizard we can even copy the existing data flow and change the flow as per our requirment.once right click on any infoprovider ( DSO or Cube) then from the context menu select copy data flow it will take you to wizard screen which we discussed now.

No comments:

Post a Comment