Duplicate record in multiprovider based on an infocube and an infoobject

[Former Member]

Hi,

We have a problem with a multiprovider based on an infocube and an Infoobject. We have 2 lines for the same records records in the report, one linewith the infocube data and another line with the InfoObject data.

Here our context:

We have a multprovider based on an infocube INFOCUBE_1 and an infoobject INFOOBJECT_2.

The IO INFOOBJECT_1 is stored in the Infocube INFOCUBE_1.

The IO INFOOBJECT_2 has an nav attr INFOOBJECT_3 and is a nav attribut of another IO INFOOBJECT_1.

In order to use the IO INFOOBJECT_3 as a nav attr in the multiprovider, we assigned the IO INFOOBJECT_2 (Master data Key) with the IO INFOOBJECT_2 (nav attr of IO INFOOBJECT_1 of the infocube). Therefor, we identified the IO INFOOBJECT_3 as nav attr in the multiprovider.

Do you have any idea please to have a unique line in the report (with data of the 2 infoproviders (Infocube and Infoobjet).

Thanks.

Radjech.

Edited by: monsdn on Jul 6, 2010 12:37 PM

Edited by: monsdn on Jul 6, 2010 12:38 PM

[Former Member]

Hi there,

Can't you change your INFOCUBE_1 so it also has the INFOOBJECT_3.

While loading the data to the InfoCube you would fill INFOOBJECT_3 throught reading INFOOBJECT_1. Whith INFOOBJECT_1 you would read its attribute INFOOBJECT_2, and with INFOOBJECT_2 you also would read its attribute INFOOBJECT_3.

In this way, you could in the MultiProvider match INFOOBJECT_3 from INFOCUBE_1 with the navegational attribute of INFOOBJECT_2 (INFOOBJECT_2__INFOOBJECT_3)

Regards,

Diogo.

[Former Member]

Hi Diogo,

We can't store the IO INFOOBJECT_3 in the Infocube, because we have to use it as nav attr. In other words, we have to use the last image of the link between INFOOBJECT_2 and INFOOBJECT_3. The fact to store it in the Infocube couldn't give us this last image without unload and relaod the infocube.

Do you have another suggestions please?

Radjech.

[Former Member]

Hi there again,

Ok, so why not just do what I said before, but instead of directly feeding the INFOCUBE_1 with the INFOOBJECT_3, simply insert the INFOOBJECT_2 in the INFOCUBE_1 and in the transformation read it from the attribute of INFOOBJECT_1.

This way you'll have in INFOCUBE_1 not only INFOOBJECT_1 but also INFOOBJECT_2.

Therefore you could in the MultiProvider match INFOOBJECT_2__INFOOBJECT_3 from INFOCUBE_1 with INFOOBJECT_2__INFOOBJECT_3 from INFOOBJECT_2

Regards,

Diogo.

[Former Member]

Hi,

Thank you for the answer.

I already tried it, because we have in the infocube a reference IO of IO INFOOBJECT_2, I assigned the nav attr of this refernce IO with the nav attr of the IO INFOOBJECT_2 (INFOOBJECT_3), but we have always 2 lines as detailled above.