Navigational attribute in ODP based BW extractor

[darshil14]

Hi,

Currently, we are working on SAP BW 7.5 SP11.

I have a requirement to load BW Infoprovider (Composite provider) data to other BW system.

I have implemented ODP extractor in target BW system based on composite provider available in source BW system.

My requirement is to extract navigation attributes along with other fields of composite provider in ODP data source. I tried but I am unable to get it.

Any one has any idea, how can we get navigation attribute of composite provider in ODP extractor?

Thanks in advance!

Darshil Shah

[BEva · Accepted solution]

Hi Darshil,

The ODP BW context offers BW InfoProviders without navigational attributes. It is not planned to add the navigational attributes.

The only possibility could be to extract the data of the composite provider without navigational attributes. And then separately you can extract the master data via the ODP for the InfoObject and use it as navigational attribute in the target.

Regards, Eva

[darshil14 · Accepted solution]

Hi Eva,

Thanks for the information.

Thanks,

Darshil Shah

[blipchen]

I don't think that you'll be able to use navigational attribute sin the composite provider. You will need your compositeprovider to include all infoobjects (may require new dataflow to populate newly added InfoObjects) and remove navigational.

This is a similar issue to working with OpenHub (you cannot get navigation attributes, texts) and will have to add target fields in the OpenHub to contain these values.