I am new to BI Extraction as i worked a lot earlier on Front End (BEX)
I have a requirement like this can you help me out in generating a report from scratch..
Users want a Bex report (So that they can see/drilldonw the data in different angles)
Role name should be the key and he needs the following information in the report
Tcodes in role
Orgn level details for a role
Users assigned to a role (user id , Full name, User group - TERM - USR02)
Orgn level field description/text
And from the below tables (Role Name is the key max. of these tables) we can get the above information....
We have several systems like R/3, CRM, SRM, BI etc... in all the sytems the role related information is stored in the above tables. And i need to extract the data from all the systems mentioned above to DSO or Cube.
Now can you help me through which extraction mode i have to go and how i have to design my DSO or Cube to meet the above requirement.
I am thinking we can go through Generic extraction through Function Module... (if so can you provide me the Steps and also the design of DSO or Cube...)
If any body had similar requirement please help....
Appreciate your help.....