Skip to Content
author's profile photo Former Member
Former Member

loading

could anybody pls help me.i have been allocated to new work which iam not experienced and provide me some materail to leran about loading.like how to work in this area.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2007 at 05:24 AM

    Hi SK,

    BW 7.0

    Uploading of master data

    Log on to your SAP

    Transaction code RSA1—LEAD 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 RSA1—LEAD 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 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

    Cheers

    Sunil

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2007 at 05:31 AM

    Hi,

    Generally we monitor the loads using Process chains.

    In BW we use Infopackages to load data from source to BW.

    In BI new concept called DTP is using to load data from PSA to data targets.

    Load to PSA we use infopackage and from PSA to any Data target we use DTP(Data Transfer Process).

    Regards

    Rajanikanth Reddy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2007 at 06:23 AM

    thanks every body for all of ur valuable answer.it will be much better for me if you all sent any doc related to loading then it will be appreciated.

    thanks once again

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.