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

data selection

Hi mates,

i need to load data selctiveley from 1 ODS to 2 cubes.Cube is load with FULL( repair of full load) , initialize delta with out data tranfer. now i need to load data from ODS to 2 cubes selectively, the update mathod is initialize delta , when i do that , i can,t see any fields in data selection tab , but when select full update i can see fields in data selection tab. so how i load data selectively with initilize data .

regards.

hari

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 15, 2006 at 10:53 AM

    Hari,

    Initializations are by datasource and not by data target. So if one ODS feeds to 2 cubes selectively, then the filter for data must be done in the udpate rules. the datasource needs to send out all data.

    Aneesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 15, 2006 at 10:55 AM

    Hi

    YOu need to write an update routine to move selectively to both the cubes depedning upon your conditions.

    Regards

    Bharath

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 15, 2006 at 10:57 AM

    hi,

    what best u can do is a full request with whatever selection and a initialize delta without data transfer. This will allow u to carry on with deltas..

    sriram

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 15, 2006 at 11:04 AM

    hi,

    init without data transfer sets the delta pointer on the source system side but does not transfer any records from source table to BW.BW request shows '0 from 0' records.

    Init without data transfer used when..

    -u have done full update from source system.And u want to init so that u can do delta later.so dont need to do data transfer init as already full update has sent all data.so u do init with data transfer.

    -u also use init without data transfer when some deltas in past few days are gone wrong.u arent able to repair.so u do a full update and then use init without data transfer to reset delta pointer from source system.

    I think there is no select options in this method..

    Siddhu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 16, 2006 at 01:55 AM

    hari

    Good Day Mate !

    Change your view settings in RSA1 to be able

    to see the System Generated objects under the

    DM application component. The infosource you are

    looking for will be your ODS Tech name with a prefix

    of 8.

    here you you be able to set your selections and type

    of updates via info_packages.

    Hope this help's

    No worry's

    George

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 16, 2006 at 01:55 PM

    In NW2004s BI, it would be possible to do multi-selections with delta 😉

    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.