Step by Step Guide to load data to BW using BI 7.0

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

Create Info cube :

  RC on Info Area and click create info cube

Give name and desc.

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

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

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

Under Generel 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 separater 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

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

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

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

RC on Info Source Create Transformation.

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

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

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

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

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

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

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

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

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

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

Hope this is helpful a bit.

Please share your inputs.

Thanks & Regards,

Anurag