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

Data Flow From DSO --> Info Cube...

From Which table ie (Active Data, change log, New Table) the data will be loaded to infocube for first full load....?

Later there is change in the Data so the delta Upload is done, in this case how the staging takes place ? And From which table the data goes to info cube ?

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 02, 2012 at 09:16 AM

    Hello Karthik,

    Please find below the answer to ur queries.

    1. The full load should be always from active table .

    2. Once ur loading the data to info cube , very first time , check the DTP setting the setting should be like that that data should be fethed from active table.

    3. Once the first full load is done , you can set up delta time stamp from DSO to infocune , by doing init with zero records fetched .

    4. Once you do the int the time stamo got maintained and the 0 records will be added to the infocube.

    5. Pnce init is done you can start loading the data to infocube from delta DTP and you can put the setting of DTP to take the data from active table only. though the setting is from active table it will take the data from changelog table whenever the delta come.

    Hope this helps , if u need more clarification .. pls let me know

    Regards,

    Varsha Mishra

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi ,

      If the data load is Full from DSO to Cube ,the data will move from active table as it contains the current status of the data.

      To set up the delta we have to do initialisation.But for a DSO we cannot do Initialisation or Delta after a full request.

      so change the settings from Full upload to Repair full requests and then do Initialisation without data transfer.which will set the delta.

      Now you can proceed with Delta.For a delta the data will be moved from change log table of DSo to cube.

      Regards,

      Ramitha

  • Posted on Jul 02, 2012 at 08:15 AM

    Hi


    Please note that you have posted into the wrong forum and I have therefore moved the thread.

    The Business Intelligence Solution Architecture is for SAP BusinessObjects BI Platform and SAP BusinessObjects Enterprise XI products


    Thanks and Regards
    Roland Hoeller

    Forum Moderator

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 02, 2012 at 09:00 AM

    Hi,

    Data will be loaded from Active Table for Full load.

    The delta load is taking place from Change Log Table.

    Regards,

    Rajesh

    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.