flat file loading in bi7.0

[Former Member]

hi,

can anyone plz tel me the procedure of flat file loading in bi 7.0 for master and transaction using flat file .

regards

[Former Member]

hi,

if u want to load a flat file the steps are given in this thread:

cheers

sunil

[Former Member]

thnaks a ton sunil , will reach u if any issues....

[Former Member]

hi sruthi..

Infocube loading steps:

1. keep flat file in csv format

2.Create data source and give flat file path,activate data source.

3.Right click data source and create info package

4.Schedule info package to load data in PSA

5.To check data in PSA,right click data source and select manage

6.Create Cube structure and activate

7.Create transformation between cube and data source by right clicking cube

8.In create transformation window specify data source name and its source system(Ex.flat file)

9.Activate transformation

10.Right click cube and select create DTP

11.Activate and execute to load data

hopr this helps.