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

Data Modelling in BI

please help me on this to be clear and firm up the data model in BI 7.0.please answer step by step eg 1,2 3,

1. I am trying to load the two purchasing cube 0pur_c01 and 0pur_c02 from the data sources scheline 2lis_02_scl and 2lis_02_ITM and 2lis_02_hdr

2. Now question is that i see confusion here to load and design the data model. please tell how

option 1. create transformation from data source 2lis_02_scl to infosource 2lis_02_scl and then create the transformation from infosource 2lis_02_scl to cube 0pur_c01 and the repeat same thing for other data source

now create IP from DS to load PSA and create the DTP to load the from DS to CUBE

3. nOW I SEE peoploe making transfer structure for IS 2lis_02_scl AND connect to DS 2lis_02_scl and then going to cube and creating UR from IS 2lis_02_scl TO CUBE like in 3.5 WHY THis is needed now in BI 7.0??? if we are going by transformation FROM DS TO IS AND IS TO CUBE AND THEN DO THE DTP

Please clarify the right approach to solve the requiremnt

4. i also see the way suggested by sap

to make 2 transform from IS To IS in case 3 why this is required since sap provided different IS

5. why not create the DS TO IS transform for each ds such as 2lis_02_scl , 2lis_02_itm and DTP to cube seperately for each DS.

please help


soniya kapoor

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2006 at 07:24 PM

    Hi Soniya,

    Infosources are no more mandatory with BI 2004s, you can directly load data from data sources to data targets using transformation and DTPs.

    In ur case you can load data to data target just by creating taransformation for ur datasources. While creating tranformation it will ask you for data target name, specify the name and now u can laod data to ur data target.

    Rather than loading data to cube directly i will suggest you to use DSO (ODS) to load data from data source to DSO, and then use data mart to load from DSO to Cube.


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      About update rules/transfer rules, with the 2004s system you can still use to 3.5 functionalities, anyhow in near future everyone has to migarte from older tech to new one. So if u r building things from scratch its better to go for new approach rather than the old transformation concept.


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.