on 10-08-2007 10:34 PM
Hi Experts
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
System
Role name
Role Description
Parent Role
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....
AGR_1016
AGR_TEXTS
AGR_DEFINE
AGR_TCODES
AGR_1252
AGR_USERS
AGR_TEXTS
AGR_DEFINE
AGR_TCODES
AGR_1252
USER_ADDR
USER_ADDR
USR02
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.....
Hi,
You have asked entire Bw concept in one single Q
the detail explanation is laborious task
in a brief
if Sap delivers any standard datasource ,and other objects which you can find in business content ,
you can install it
if not
go for generic extraction,for details chk this link
/thread/202749 [original link is broken]
also chk this for step by step Procedure is their u can follow this BI7 version which i found in SDN
credit goes to the writer
here step by step Procedure is their u can follow this BI7 version
) Create a data source
RSA1->Source Systems->FILE(File)->PC_FILE(Filesourcesystem)->Create Application Component(optional)-Create Data source
2) Create infoPackage
Right click on the data source and do
3) Create the data provider
4) Create Transformation
Right click on the data provider, choose 'create transformation' and choose your data source (give relevant data source and its type)
Just connect the relavant fields between your data source and data provider.
4) Create DTP
Then Double click on the DTP node created under yous transformations. choose the extraction mode as delta.
5) Load the data: there are 2 ways:
you can run the infopackage and DTP separately or create a process chain consisting of these infopackage and DTP and run.
Hope this helps.
Uploading of master data
Log on to your SAP
Transaction code RSA1LEAD YOU TO MODELLING
1. Creation of Info Objects
In left panel select info object
Create info area
Create info object catalog ( characteristics & Key figures ) by right clicking the created info area
Create new characteristics and key figures under respective catalogs according to the project requirement
Create required info objects and Activate.
2. Creation of Data Source
In the left panel select data sources
Create application component(AC)
Right click AC and create datasource
Specify data source name, source system, and data type ( master data attributes, text, hierarchies)
In general tab give short, medium, and long description.
In extraction tab specify file path, header rows to be ignored, data format(csv) and data separator( , )
In proposal tab load example data and verify it.
In field tab you can you can give the technical name of info objects in the template and you not have to map during the transformation the server will automatically map accordingly. If you are not mapping in this field tab you have to manually map during the transformation in Info providers.
Activate data source and read preview data under preview tab.
Create info package by right clicking data source and in schedule tab click star to load data to PSA.( make sure to close the flat file during loading )
3. Creation of data targets
In left panel select info provider
Select created info area and right click to select Insert Characteristics as info provider
Select required info object ( Ex : Employee ID)
Under that info object select attributes
Right click on attributes and select create transformation.
In source of transformation , select object type( data source) and specify its name and source system Note: Source system will be a temporary folder or package into which data is getting stored
Activate created transformation
Create Data transfer process (DTP) by right clicking the master data attributes
In extraction tab specify extraction mode ( full)
In update tab specify error handling ( request green)
Activate DTP and in execute tab click execute button to load data in data targets.
4. Monitor
Right Click data targets and select manage and in contents tab select contents to view the loaded data. Alternatively monitor icon can be used.
BW 7.0
Uploading of Transaction data
Log on to your SAP
Transaction code RSA1LEAD YOU TO MODELLING
5. Creation of Info Objects
In left panel select info object
Create info area
Create info object catalog ( characteristics & Key figures ) by right clicking the created info area
Create new characteristics and key figures under respective catalogs according to the project requirement
Create required info objects and Activate.
6. Creation of Data Source
In the left panel select data sources
Create application component(AC)
Right click AC and create datasource
Specify data source name, source system, and data type ( Transaction data )
In general tab give short, medium, and long description.
In extraction tab specify file path, header rows to be ignored, data format(csv) and data separator( , )
In proposal tab load example data and verify it.
In field tab you can give the technical name of info objects in the template and you not have to map during the transformation the server will automatically map accordingly. If you are not mapping in this field tab you have to manually map during the transformation in Info providers.
Activate data source and read preview data under preview tab.
Create info package by right clicking data source and in schedule tab click star to load data to PSA.( make sure to close the flat file during loading )
7. Creation of data targets
In left panel select info provider
Select created info area and right click to create ODS( Data store object ) or Cube.
Specify name fro the ODS or cube and click create
From the template window select the required characteristics and key figures and drag and drop it into the DATA FIELD and KEY FIELDS
Click Activate.
Right click on ODS or Cube and select create transformation.
In source of transformation , select object type( data source) and specify its name and source system Note: Source system will be a temporary folder or package into which data is getting stored
Activate created transformation
Create Data transfer process (DTP) by right clicking the master data attributes
In extraction tab specify extraction mode ( full)
In update tab specify error handling ( request green)
Activate DTP and in execute tab click execute button to load data in data targets.
8. Monitor
Right Click data targets and select manage and in contents tab select contents to view the loaded data. There are two tables in ODS new table and active table to load data from new table to active table you have to activate after selecting the loaded data . Alternatively monitor icon can be used.
Create info package by right clicking data source and in schedule tab click star to load data to PSA.( make sure to close the flat file during loading )
...
Activate DTP and in execute tab click execute button to load data in data targets.
cheers,
swapna.G
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Rohith,
I have the same requirement like you... Go with Generic Extraction with Function module option.... for all the tables with Role name as Key. For other Tables (other than Role name as Key) enhance the Data source (Which you created through Generic Extraction - Function Module) through CMOD by adding the fields in the append structure.
Let me know if you have any questions.....
Thanks
Mahesh Reddi
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.