data selection

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Sriram,

But then delta data for all selections would go across.

Aneesh

[Former Member]

you can always restrict them in update rule start routine

[Former Member]

Sriram,

That is the only option. If that is done, then it might as well work for the init.

Cheers

Aneesh

[Former Member]

Hi sriram,

Thanks.

i hope i need to do samething what u told me , is it right we can,t see any selection fields in data selection tab, if you select initilize delta?

hari

[Former Member]

true,

how abt restricting data to ODS by selections? He can try by restricting the data to ODS by the selections, then can go ahead with usual delta

sriram

[Former Member]

Hi

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

Regards

Bharath

[Former Member]

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