cancel
Showing results for 
Search instead for 
Did you mean: 

BODS to BW load - PC trigger

deepesh_kumar
Participant
0 Kudos

Hi All,

I am loading data from Flat file to BW using BODS.

BW 7.3

BODS - 4.0

I am able to get the connection established and able to load the data till PSA.

Now I need to trigger a specific process chain in the BW side from BODS. Is there any standard object for the same?

Regards

Accepted Solutions (1)

Accepted Solutions (1)

former_member193085
Participant
0 Kudos

Hi Deepesh,

You could follow the exact way how Raman explained. For triggering the PC, event could be created using tcode SM62 and it could be triggered in SM64.

Regards,

Nitesh

deepesh_kumar
Participant
0 Kudos

@ Raman & Nitesh,

I am clear on the purpose of IP & DTP. The situation is - Load till PSA is not controlled by BW. It is controlled by BODS.

When a BODS job is run the data will get loaded up to PSA. When the request is available in PSA - I have to trigger the process chain which will use the DTP to move the data to DSO and then to Cube.

The triggering point is new request in PSA, and I do not want to control the trigger from BW because of the requirement reason.

Any thoughts?

RamanKorrapati
Active Contributor
0 Kudos

in BODS, how your loading data to psa? thru any job or any program?

former_member183012
Active Contributor
0 Kudos

Hi Deepesh,

Think about following solution.

1)After your BODS job completion you can trigger an event in BW side.

how to tringer event from source system - you will find lot of documents

2) Create event based chain which consist of start -> your DTP-> activation of DSO-> load cube etc..

After Job completion event will trigger and your process chain will start In this way you can automate your data load.

hope it will help.

Regards,

Ganesh Bothe


deepesh_kumar
Participant
0 Kudos

@Raman

BODS side there is an object called Job. Which similar to Process chain in BW. I am able to load to PSA using this BODS job. The trigger for BODS job is from a web interface DS management Console. The user wants the trigger to be at the BODS.

@ Ganesh

The solution you have mentioned above is the one I am evaluating. How to trigger an Event from BODS is where I am stuck.

I read another thread and solution provided is -

Create BI source data store 

Import BAPI RSPC_API_CHAIN_START

create a data flow with row generatot as input, query transform and a template as output

Click on the query transform and in the schema out Add New Function Call .

Enter process chain name in the BAPI input parameters section 

Make sure that schema in and schema out has same fields by propogating the fields.

Validate and run this job ...which will execute the process chain that loads data into BI ( or you can do pretty much anything using process chain)

Will this work? Any thoughts?

This is a solution at the BODS side - I am not sure this is the right forum , Anyway I have posted the same in BODS forum also. Lets see.

former_member189153
Active Participant
0 Kudos

Hi Deepesh,

Please try this, you can able to execute the BABI from Dataservice.

Regards

M Ramesh

former_member189153
Active Participant
0 Kudos

Hi Deepesh,

I have tried BAPI RSPC_API_CHAIN_START and i can able to trigger BW Process Chain from BODS.

I hope this will work for your needs.

deepesh_kumar
Participant
0 Kudos

Thanks a lot for the inputs.

Can you please provide some more inputs on the How to part?

May be couple of screenshots and steps on BODS will be really helpful. I am from a BW world, pretty much new to BODS.

Thanks in advance.


deepesh_kumar
Participant
0 Kudos

Hi Ramesh,

Did you create the BW data store as Source or Target. I am able to import the BAPI when creating the Data store as Source. Can you please confirm the same from your end too?

Regards

Deepesh Kumar

former_member189153
Active Participant
former_member189153
Active Participant
0 Kudos

Hi,

Data Store as BW Source.

deepesh_kumar
Participant
0 Kudos

hi Ramesh,

I created BW as source datastore and imported RSPC_API_CHAIN_START function. Created dataflow with row generator as source then a query transform. In this query trasform created a new function call. In this passed Process chain as input parameter. When selecting the output parameter it is showing only the parameters but the not table I_T_VARIABLE. After the query transform added a query transform and template table as target.

When i run the job now it is showing the follwing warning and it is not triggering the process chain:

Also the return value in the template table is null.

Can you please help me to sort this out.

former_member189153
Active Participant
0 Kudos

Hi Deepesh,

Seems, your process chain require few input for scheduling.  Change your process chain start variant start time as “Immediate start”. Then try again.

Note: Process Chain name in the input screen must be quoted.

deepesh_kumar
Participant
0 Kudos

Hi Ramesh

Thanks a lot. You saved lot of time for me .

In the blog - see if you can add few more screenshots like PC start variant in this thread. It will be helpful for others also.

Regards,

Deepesh Kumar

Answers (2)

Answers (2)

former_member189153
Active Participant
0 Kudos

Hi Deepesh,

I have answered your question in DataService Community, Pls Refer the thread

http://scn.sap.com/thread/3532836

Regards,

M. Ramesh

RamanKorrapati
Active Contributor
0 Kudos

Hi,

Info pack - its always loads data from source system to PSA

DTP - its loads data from psa to further any targets.

So you can use simple process chain like

Start variant---> info pack---->delete index(cube) --->dtp-->create index(cube)-->rollup  if exist.

You can add your info pack and dtp  by using related process types.

Assumed as your loading data to cube.

Thanks