Process Chain For 0PC_C01

[Former Member]

Hi Expert,

I have to create PC for 0PC_C01 with data source 0CO_PC_01 and 0CO_PC_02 .This infocube does not support delta .I have to do full load every day .Pls help me to create Process chain and it's steps.

Thanks & Regards,

Sanjay

[RamanKorrapati]

Hi,

Which version of bw your using?3.x or 7.x

in your cases you need to delete psa  and cube data on daily before loading the new request.

Use process methods - Delete psa  data and Delete overlapping request from cube when data source was same. use proper selections to delete the overlapping request from cube.

For more information please search from google and help yourself.

Thanks

[Former Member]

Hi Ramanjaneyulu,

Thanks for reply. I am using SAP BI 7.3 SP9.For creating process chain i follow the steps

Start ----> Delete Index for 0PC_C01 ---> Deletion of request from PSA ----> Info package For 0CO_PC_01 --->Delete overlapping requests from Infocube 0PC_C01 ---> DTP ---> Create Index  .

I have done for DS 0CO_PC_01 . Same way i have to create second DS 0CO_PC_02 or what .My PC has correct or i need to change some process or process type.

Thanks,

Sanjay

[KodandaPani_KV]

Hi,

fallow the below steps.

1. start process

2. delete index

3. info package for first cube

4. deleting the request form PSA  (it will happen every day deleting existing request)

5. add the activate the DSO (if your using the DSO)  DTP

4. activate DSO

5. cube DTP

6. create index

7. initial fill of new aggregates (if you are using)

continue the same step to 2 cube also but no need create another process typs.

Thanks,

Phani.

[RamanKorrapati]

Your design was fine.

First there won't be request to delete form psa and cube. so first time you can load the data to targets by manual. next time on wards you can run your process chain.

[former_member202718]

Hi Sanjay,

Can you take the help of your seniors in the Project/Company to get this.

The steps would be as below,

• Delete data from PSA- mention the Datasource/Tech name and delete with Cond Less than Zero Days.
• Create a Infopak - it will be Full load
• Delete Data Target- mention the cube name
• Create DTP With Load

rgds

SVU