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

bi

I want sap bi modeling and how to create objects and how to load the data in bi 7.0 plz send me any material

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 15, 2010 at 08:40 AM

    Hi, Follow the below steps and let me know if any issues on this BW 7.0

    Uploading of master data Log on to your SAP Transaction code RSA1u2014LEAD YOU TO MODELLING 1. Creation of Info Objects u2022 In left panel select info object u2022 Create info area u2022 Create info object catalog ( characteristics & Key figures ) by right clicking the created info area u2022 Create new characteristics and key figures under respective catalogs according to the project requirement u2022 Create required info objects and Activate. 2. Creation of Data Source u2022 In the left panel select data sources u2022 Create application component(AC) u2022 Right click AC and create datasource u2022 Specify data source name, source system, and data type ( master data attributes, text, hierarchies) u2022 In general tab give short, medium, and long description. u2022 In extraction tab specify file path, header rows to be ignored, data format(csv) and data separator( , ) u2022 In proposal tab load example data and verify it. u2022 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. u2022 Activate data source and read preview data under preview tab. u2022 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 u2022 In left panel select info provider u2022 Select created info area and right click to select Insert Characteristics as info provider u2022 Select required info object ( Ex : Employee ID) u2022 Under that info object select attributes u2022 Right click on attributes and select create transformation. u2022 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 u2022 Activate created transformation u2022 Create Data transfer process (DTP) by right clicking the master data attributes u2022 In extraction tab specify extraction mode ( full) u2022 In update tab specify error handling ( request green) u2022 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 RSA1u2014LEAD YOU TO MODELLING 5. Creation of Info Objects u2022 In left panel select info object u2022 Create info area u2022 Create info object catalog ( characteristics & Key figures ) by right clicking the created info area u2022 Create new characteristics and key figures under respective catalogs according to the project requirement u2022 Create required info objects and Activate. 6. Creation of Data Source u2022 In the left panel select data sources u2022 Create application component(AC) u2022 Right click AC and create datasource u2022 Specify data source name, source system, and data type ( Transaction data ) u2022 In general tab give short, medium, and long description. u2022 In extraction tab specify file path, header rows to be ignored, data format(csv) and data separator( , ) u2022 In proposal tab load example data and verify it. u2022 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. u2022 Activate data source and read preview data under preview tab. u2022 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 u2022 In left panel select info provider u2022 Select created info area and right click to create ODS( Data store object ) or Cube. u2022 Specify name fro the ODS or cube and click create u2022 From the template window select the required characteristics and key figures and drag and drop it into the DATA FIELD and KEY FIELDS u2022 Click Activate. u2022 Right click on ODS or Cube and select create transformation. u2022 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 u2022 Activate created transformation u2022 Create Data transfer process (DTP) by right clicking the master data attributes u2022 In extraction tab specify extraction mode ( full) u2022 In update tab specify error handling ( request green) u2022 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 Regards Sivaraju

    Edited by: kolli sivaraju on Feb 15, 2010 6:11 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 15, 2010 at 08:58 AM

    Hi

    As this is Forum people can answer specific issues faced. It will be very difficult to respond generic questions.

    There is very help documentation for SAP BI, please find below link for the same:

    http://help.sap.com/saphelp_nw70ehp1/helpdata/en/fc/1251421705be30e10000000a155106/frameset.htm

    Even u can search this forum for specific issues faced during practice.

    Ravi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 15, 2010 at 09:50 AM

    Hi Rani,

    To tell all process for Data modeling and loding process is very lenghty so

    Just refer the STEP BY STEP BW GUIDE book by FUFU. It is very useful for data modelling.

    Sure it will help to you.

    Thanks

    Abha

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 15, 2010 at 12:24 PM

    HI visit,

    www.bw4all.blogspot.com

    thanks,

    karthik

    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.