Generic Extraction based on a View – Part 4
This is Part 4 of the Generic Extraction.
Part 1 detailed about the steps to be performed in ECC, Part 2 detailed abouts steps in BI till records are fetched successfully to PSA, and
Part 3 till bringing the data records to DSO. The links to all parts can be found at the bottom of the document.
1) Creating an InfoCube
The next step would be creating an InfoCube
Activate the InfoCube.
2) Create Transformation between DSO and the InfoCube
3) Create the Data Transfer Process
Activate and Execute the DTP as detailed in Part 3
DTP Monitor
Click on Administer DataTargets
The load has been successful. Now you can take the data records for reporting.
Open BEx Query Designer and add the InfoObjects to Rows and Columns as needed.
Execute and view the report.
Thank you for taking time out to go through the document. Hope its been helpful.
The links to previous parts
Part 1
http://scn.sap.com/docs/DOC-32025
Part 2
http://scn.sap.com/docs/DOC-32026
Part 3
Anjali....excellent work ....the way described is very intresting...keep post same like Function module if possible???
Thanks Ravi!!! Will try to post on function module 🙂
Cheers,
Anjali
hai anjali...i want one requirement that based on fucntion moduel extraction...do u hav any experience eith this? just requirement enough....
Hi Ravi,
Currently, I am working on Generic Extraction based on function module in HR module. Meanwhile, if you want to try here is a brief requirement.
Usually we go for function module when we want to extract from different tables. So create a structure with some fields ( CHAR + KEYFIG) from any two tables eg: VBAK, VBAP. The only point you have to keep in mind is that it should have a common key field. Here VBELN is that field. Now fetch the records for these fields using function module.
Just published LO MasterData datasource enhancement- have a look!!
Hope this helps,
Anjali
thnk u so much anjali......and awaiting u r post on FM extraction (this Hr requirement).
Thanks and regards,
Ravi kiran.
nice document thanks
Thank you Martin!!! Good work in the forums!!
These docs are really helpfull anjali.....
Great job!!
Hi Anjali,
I must say all the 4 parts of this document is really helpful for every BI practitioners. The way you explained the topic is very good.
Could you please post same kind of detailed document for LO-Extraction ? 😀
Best regards
Albin
Hi Albin,
Thanks!
For LO Extraction please follow these documents...they are really informative
Part 1 http://scn.sap.com/docs/DOC-11443
Part 2 http://scn.sap.com/docs/DOC-11986
Part 3 http://scn.sap.com/docs/DOC-11988
Part 4 http://scn.sap.com/docs/DOC-11990
Part 5 http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d07aa007-84ab-2d10-46ba-a5a2679f0d7b?quicklink=index&overridelayout=true
Part 6 http://scn.sap.com/docs/DOC-12007
Part 7 http://scn.sap.com/docs/DOC-12018
Hope its helpful,
Anjali
Thank you Anjali for sharing knowledge. Keep it up. Your help counts a lot.
Nice documentation 🙂
Regards,
SM
Hi anjali it a very informative doc i have a ques though. Re info cube how did u choose the cube i mean its a standard cube right. if u could pls elaborate on that it would be really helpful.
Regards,
Ram
Hi Anjali...Excellent documentation with proper screenshots....keep it on....
Thanks Anjali,
You did a very good Job! 🙂
Hi Anjali,
Thank you so much for these documents.
it really helped me like other.
Hats Off.