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

Modelling issue for MultiProvider

Hi all,

I have a little modelling issue here.

Cube C1 has KeyFigure K1 and characteristic A2 with navigational A3.

Cube C2 has KeyFigure K2 and characteristic A1 with navigational A2. On his turn A2 has navigational A3.

I would like to combine these cubeu2019s in a Multiprovider and make the following report:

Char A3 KeyFigure K1 KeyFigure K2

We use 7.0 back-end and 3.5 front-end.

Anyone knows how to model this?

Thnx in advance,

Henk.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jun 13, 2008 at 07:35 AM

    Hi Henk,

    build an infoset for the second cube by including the cube C2, the infoobject A2 and the infoobject A3. In this infoset you will have to maintain a join between the infoobjects A1 (contained in the cube) and infoobjects A2 and A3. Finally, create a multiprovider containing the infoset and Cube C1. Over there make the appropriate identifications for infoobject A3 and key figures k1 and k2. This will solve your issue.

    Best regards

    Theodoros

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Theodoros / Bala,

      Problem solved!

      I think my question was a bit confusing but youu2019ve put me on the right direction.

      I've done the following:

      1) InfoSet made on the basis of C2 and InfoObject A1 and A2

      2) Join between Cube C2/IO A1 > Key IO A1

      3) Join between IO A1/Attr A2 > Key A2

      4) By the last join also the navigational A3 of A2 is available

      5) MultiProvider with InfoCube C1 and InfoSet will do the trick.

      Bottom-line: not A2 and A3 had tot be included in the InfoSet but A1 and A2.

      Again: thanx for putting me on the path for the InfoSet. Iu2019ve rewarded points.

      Henk.

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.