Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Hello Colleagues,

Please below are the steps for uploading data to SAP BW using BI 7.0

Create Info Area: (Use TA: RSA1)

Go to Info Provider -> RC_> Create Info Area

1.PNG

Create Info cube :

RC on Info Area and click create info cube

 

 

Give name and desc.

 

3.PNG

 

Push all your chacteristics (including 9AVERSION) under dimension1 and all your keyfigure under

Keyfigure also push 0CALMONTH under time .

Create Source System:

Select source system from modeller and under file RC-> Create Source System

 

Give name and desc

 

6.PNG

 

Create Application Component:

Go to Info Source in modeller menu. RC on the Info Source and Create Application Component

 

RC on Application component and Create Data Source

 

8.PNG

 

Give name and select created Source System and in the Data Source Type select “Transactional data”

 

 

Under General Info tab give desc’s. In Extraction tab,load your CSV file in file field. Give Header rows to be ignored In data format select CSV file. Make sure the data separator is ,

 

 

Under Proposal Tab Load Example data check if data appears same as in your CSV File.

 

Under Proposal Tab Load Example data check if data appears same as in your CSV File

 

 

 

12.PNG

 

 

Under Preview tab check for the preview of the data upload.

 

 

13.PNG

 

 

RC on Application Component nad create Info Source (Optional Step)

 

 

 

Give name and desc and in the Object field select your info cube


 

 

16.PNG

 

 

 

 

 

RC on Info Source Create Transformation.

Map all your Data source info objects to the info source info objects

 

21.PNG

 

Under Info Provider select your Info cube and RC and Create Transformation

 

 

20.PNG

 

Map all your info objects of Info Source to Info cube.

 

 

21.PNG

 

Under Info Source , Select your Data Source and RC create Info Package.

 

 

 

22.PNG

 

Give name for Info Package and Under Schedule tab of Info Package click on Start.

 

 

23.PNG

 

 

Choose Goto Menu and select Monitor check if schedule is successful.

 

24.PNG

 

Now select your Info Cube and RC and Create Data Transfer Process

 

25.PNG

 

Go to Execute Tab and Click on Execute if asks for activation plz go on activating

 

26.PNG

 

 

 

 

27.PNG

Check if everything is ok . All requests in Request Processing are green.

 

 

28.PNG

 

 

Now Select your Info cube RC and Display data and select all characteristics and display.

 

 

29.PNG

 

Hope this is helpful a bit.

Please share your inputs.

 

Thanks & Regards,

Anurag

  • No labels