Skip to Content
avatar image
Former Member

Info package

Hi,

I created a process chain that loads from an ods to cube both are full loads.

i included the Full load info package for the cube but when i run the Process chain the system creates 3 more info packages to the info source which are Init Delat and full and the process chain loads a Init load that the system created and then the Full load that is in the process chain. so when i look at the contents of the cube i always have 2 similar records.

Can someone help me fix this issue.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 10, 2007 at 08:08 PM

    Hi kim s

    Jus make sure of your requests in the cube and go to the ODS observe the data

    flow if its not updating to other targets then u can jus go throght the ODS

    SETTINGS and remove update automatically flag. If its updating to some other

    targets n that case also just remove the update automatically to targets setting

    and place job which will trigger after the activation and it will triggera pak as per

    the schedule..!

    Hope itz clear.

    Thanks

    Kishore M Reddy

    > Hi,

    >

    > I created a process chain that loads from an ods to

    > cube both are full loads.

    > i included the Full load info package for the cube

    > but when i run the Process chain the system creates 3

    > more info packages to the info source which are Init

    > Delat and full and the process chain loads a Init

    > load that the system created and then the Full load

    > that is in the process chain. so when i look at the

    > contents of the cube i always have 2 similar

    > records.

    >

    > Can someone help me fix this issue.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      If u have request 1. request 2 in the DSO n u run a Full to Cube from DSO it will pull both the requests ( 1 + 2 ) - There may be aggregation of data though.

      If on the next day request 3 comes n sits in DSO - a delta load from DSO to Cube will only pull request 3.

  • avatar image
    Former Member
    Oct 10, 2007 at 07:58 PM

    uncheck the "update data automatically" in the ODS maintenance. You will find that in ODS settings tab.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Voodi,

      It is unchecked. actually i m only creating the Process chain part of an existing data flow.

      fore example: The ODS gets 1026 records for the full load and since the process chain is doing an init and also a Full load one after the other for the same process kick off the cube has 1026 from the init load and then plus 1026 again from the full load. Isnt the load suppose to be a delta because the cube always adds up the records to the previous number?

      and the second thing i dont understand is that when i am only including the full oad in the PC why is the system creating a init and then doing a inti load and then doing the full load that i included. The init and the Full are both happeing for the same prcess kick off.

      every time i kick off my Pc the cube has a init and then the full and for the second time i kick the Pc it has a delta and then a full load i m confused.

      Please help.