on 04-07-2014 5:52 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@ 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?
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
@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.
Hi Deepesh,
Please refer the below Document for the same
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.
Hi Deepesh,
I have answered your question in DataService Community, Pls Refer the thread
http://scn.sap.com/thread/3532836
Regards,
M. Ramesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.