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

Multiprovider to include a single value

Hello all,

I explain what I'm trying to implement: we have created a multicube which includes two infocubes. This works. Buet now we need to show, for each virtual line of that multicube, a value. This value only depends on time. So I have created an ODS to store this value for each period. Then I include the ODS in our multicube. There is no common characteristics between the ODS and the other infocubes apart from the time characteristic. And the fact is that it doesn't work. I see it in a query: for each line of the multicube no value is assigned but, if we display a register without any value of the characteristic, then I see the value in an empty line, just with the time characteristic. I supposed that the multicube would have to generate a line for each combination of characteristics of every infocube/ODS and adding every value field. Is that so? I've tried including common characteristics in the ODS, and also changing the ODS for another infocube. But all these options didn't work to me.

Is there a limitation to mix more than two infocubes/ODS in a multicube?

How could I add a value at the end of every line in the query of our multicube? The value only depends on time characteristic.

Thank you very much for any help.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 19, 2005 at 09:55 AM

    The most evident "limitation" to be considered when working with MultiProviders is the fact that they do are related to UNION reltional operator rather than JOIN. That's why you see "different" lines.

    Did you considered a different design? I was wondering if using a Custom Characteristic (let's say ZFISCPER)feeded by "period values" (don't now if it's 0FISCPER ...) with a "display" attribute could produce the desired result

    Best regards

    GFV

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      There is another way to achieve your solution. Your query will probably contain a column that contains only KEYFIG3. When you restrict this column to the InfoProvider 'ODS' and rightclick on 0INFOPROV and choose 'Constant Selection' you can achieve the result without manipulating the content of the ODS or the other cubes. Restricting the ODS value to the other chars is fine but you sometimes need to load lots of data for all different combinations into the ODS.

      Best regards

      Dirk

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.