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

Duplicate record in multiprovider based on an infocube and an infoobject

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jul 06, 2010 at 10:46 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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.

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.