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

create the process chain

Hi all,

Can someone tell me if my steps are correct for creating the process chain for uploading from ODS into the cube.

Here are steps that I did:

1. created the 'full load' infopackage in the infosource for uploading from the Infosource into the ODS.

2. right click on ODS and select 'update ODS Data in Data Target' to upload into the cube (select 'init load').

3. create another 'full load' infopackage in the infosource and use it to create the process chain by pressing the 'process chain maintenance'.

Thank you.

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 16, 2005 at 08:15 AM

    Hi,

    if that is the case then u have to replicate ur data sources for ur BW system.

    right click on ur BW sosurce system and then select the replicate data sources. later u will find ur data sources.

    check it and let me know the details-

    Regards-

    MM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi john,

      I will try to answer to my level best

      1. Sorry if got confused with my previous post.. you cannot see the infosource when you say 'show generated ODS object'. Its for an IP which is used for the infosource with export datasource. Sorry for that. You have to create one new info source and then replicate your already created data source and assign it to the newly created infosource.

      2. I think i have answered this question also in the first one.

      3. Once you create an infosource, assign this infosource to export datasource (8xxxx), you have to create one IP. Then if you run this ip with init, it will initialise the delta and then you can go for delta. This will take care of loading data to the final data target. So executing this IP is as gud as Update the ODS data to final targets.

      4.Yes. I mean use the "Execute infopackage" process type and maintain the delta IP as variant in your process chain. ( this works only if you have successfully run the init IP )

      Hope i cleared your doubts.. If anything else, pls post it

      Sriram

  • author's profile photo Former Member
    Former Member
    Posted on Aug 16, 2005 at 01:06 AM

    Hi John,

    The better option to load data from ODS to cube is to create an export datasource and then upload. So i will brief the stpes involved for that.

    1. Ofcourse load ur first ODS with the stpes u have mentioned.

    2. create an Export datasource for this ODS. ( Right click on the ODS and generate export datasource )

    3. For your infosource, assign this datasource and for ur cube, create an update rule with this infosource.

    4. For the first time loading cube, create an IP for the above said infosource with Init option and load.

    5. Create a delta IP for the same infosource and add it in the process chain.

    P.S: The option 'update ODS Data in Data Target' is not required in this case.

    Regards

    Sriram

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Sriram,

      Can you clarify some of steps? I am not familiar with this process.

      <b>3. For your infosource, assign this datasource and for ur cube, create an update rule with this infosource.</b> Do I need to create another infosource to assign this datasource? I have to create another update rule for it, right?

      <b>4. For the first time loading cube, create an IP for the above said infosource with Init option and load.</b>

      Where can I create IP for the infosource?

      <b>5. Create a delta IP for the same infosource and add it in the process chain.</b> Where do I add IP in the process chain.

      Thank you so much for sharing your experience.

  • author's profile photo Former Member
    Former Member
    Posted on Aug 16, 2005 at 06:46 AM

    Hi,

    -after creating ur export data source for ur ODS, g and right click ur cube to create Update rules based on this export data source i.e 8ODSName.

    - later u create an IP for that 8ODSNAME with init with delta and then load.

    -and there after create a delta IP for that 8ODSNAME. which shud be used as a load process in the Process chain.

    Use the delta IP in for ur ODS in the process chain but not the init IP.

    Hope it will help u.

    Regards-

    MM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi MM,

      Do you know where I can create IP for the 8ODSxxx with init with delta load? When you said: with init with delta and then loan, do you mean: one init load, one delta load?

      Thank you very much for sharing ur experience

  • author's profile photo Former Member
    Former Member
    Posted on Aug 16, 2005 at 07:40 AM

    Hi John,

    -Goto RSA1-> Infosources-> select ur info source i.e 8xxx[xxxx refers to ur ODS name] -> right click on the source system and select create Info package.

    - create 2 IP's, one is for INIT and one is for Delta.

    Hope it helps-

    Regards-

    MM

    Message was edited by: vishnuC

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 16, 2005 at 02:49 AM

    Hi John,

    First this is that u initialize ur ODS with delta without going for full load. If u take full load into consideration then u have to do the repair full request. So first of all u initialize with delta for ODS. Later maintain export data source on ur ODS and give the name of ur Data source and then select 'update ODS Data in Data Target'. for updating the data to ur cube.

    in process chain-

    -use the Delat infopackage of ur ODS after the start process.

    - after this include the Activation process for ur ODS.

    -use the process called further process to update from ur ODS to ur cube or u can put seperate load process to update the data to ur Cube.

    Hope it helps-

    Regards-

    MM

    Message was edited by: vishnuC

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 16, 2005 at 07:57 AM

    Hi,

    guess that u have created the Updaterules based on datasource [8XXXXX].

    Goto Menu -> Settings->Display Generated Objects ->select Show generated ODS Objects. and then refresh ur screen.

    guess u wil get ur infosource..

    Regards-

    MM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      MM,

      Do I need to create one infosource for assigning this datasource? I followed ur advices and still cannot find the infosource 8xxxx to create IP for running the process chain? Please help.

      Thank you.

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.