cancel
Showing results for 
Search instead for 
Did you mean: 

DSO creation

Former Member
0 Kudos

Hi Everybody,

I am a beginner in SAP-BW.Can somebody please tell me how to load data into DSO from flat file and then into Infocube in BW 7.0.

Thanks,

Shravani.

Accepted Solutions (0)

Answers (4)

Answers (4)

raghu_ram
Active Contributor
0 Kudos

hii shravani,

there was a name mistake in my previous thread. pls excuse 4 that.

raghu.

raghu_ram
Active Contributor
0 Kudos

hii supriya,

check the foll link.

http://help.sap.com/saphelp_nw70/helpdata/en/b2/e50138fede083de10000009b38f8cf/frameset.htm

hope it helps,

regards,

raghu.

chemicala_srimallikarjuna
Active Contributor
0 Kudos

Hi,

In BI7.0 Data is loaded using infopackage upto PSA only.Inorder to update the data from PSA to the target u need to perform the DTP(data transfer Process).

Steps;

1.Create Info Area and Info Objects

2.Create Characteristic Info Objects Catalog. Then Create Info Objects as per your requirements

3.Create Data Source under your Source System.

4.Select Data Source under Modeling, Choose Source System as per your requirement

5.Create Application Component and then create Data Source.-->Enter short, medium and long descriptions in General Info Tab

6.Then Load Example data and then go to next tab Fields. Enter name of Info Objects in the Template (Optional). The Transformations will take place automatically when we enter the Info Objects in Template.

7.Then Activate the Data Source and then see in the next tab Preview.

Then select Read Preview Data...

pls Go through the link for DTP

http://help.sap.com/saphelp_nw2004s/helpdata/en/42/f98e07cc483255e10000000a1553f7/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/43/01ed2fe3811a77e10000000a422035/frameset.htm

Hope this helps,

Regards

CSM Reddy

Former Member
0 Kudos

Hi

Uploading of Transaction data

-


Log on to your SAP

Transaction code RSA1—LEAD YOU TO MODELLING

1.. Creation of Info Objects

• In left panel select info object

• Create info area

• Create info object catalog ( characteristics & Key figures ) by right clicking the created info area

• Create new characteristics and key figures under respective catalogs according to the project requirement

• Create required info objects and Activate.

2. Creation of Data Source

• In the left panel select data sources

• Create application component(AC)

• Right click AC and create datasource

• Specify data source name, source system, and data type ( Transaction data )

• In general tab give short, medium, and long description.

• In extraction tab specify file path, header rows to be ignored, data format(csv) and data separator( , )

• In proposal tab load example data and verify it.

• In field tab you can you can give the technical name of info objects in the template and you not have to map during the transformation the server will automatically map accordingly. If you are not mapping in this field tab you have to manually map during the transformation in Info providers.

• Activate data source and read preview data under preview tab.

• Create info package by right clicking data source and in schedule tab click star to load data to PSA.( make sure to close the flat file during loading )

3. Creation of data targets

• In left panel select info provider

• Select created info area and right click to create ODS( Data store object ) or Cube.

• Specify name fro the ODS or cube and click create

• From the template window select the required characteristics and key figures and drag and drop it into the DATA FIELD and KEY FIELDS

• Click Activate.

• Right click on ODS or Cube and select create transformation.

• In source of transformation , select object type( data source) and specify its name and source system Note: Source system will be a temporary folder or package into which data is getting stored

• Activate created transformation

• Create Data transfer process (DTP) by right clicking the master data attributes

• In extraction tab specify extraction mode ( full)

• In update tab specify error handling ( request green)

• Activate DTP and in execute tab click execute button to load data in data targets.

4. Monitor

Right Click data targets and select manage and in contents tab select contents to view the loaded data. There are two tables in ODS new table and active table to load data from new table to active table you have to activate after selecting the loaded data . Alternatively monitor icon can be used

Hope it helps.........