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

Multiprovider Issue

Hi Guys

We have one cube (A) which is coming out of 2 LO Cockpit data sources (VAKON and VAITM)

Another cube (B) which is purely coming out of VAKON.

We have a multiprovider with this 2 cubes...

Now When we created a query on this multi provider and bring some KFs from Cube A (KF1, KF2, KF3) and Some From Cube B (KF4, KF5,KF6) , we are not able to see the values for Cube B KeyFigures..Its always showing 0

I checked in Cube B data my manage and those KeyFigure values are coming perfect....But why the query is not showing those values ? where as Cube A's Key Figures are showing correctly in the Report...Is there any reasons for this..Any one has any idea...Help will be apprecicated

Regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 19, 2007 at 07:49 PM

    debug our query in RSRT with Multiprovider+ Explain option , you shd be able to figure it out.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Check the definition of your Multiprovider , for cube B fields that are joined with cube A and check those records are matching..

      If you are leaving your query wide open and you dont see any reocrds coming from Cube B then you might have to check your MP definition and how you have choosen your fields.

  • author's profile photo Former Member
    Former Member
    Posted on Nov 19, 2007 at 08:18 PM

    Do you have aggregates,if yes have they been rolled up?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 19, 2007 at 08:26 PM

    Check following:

    1) Aggregates on cube B: rolel dup or not...any red req..

    2) Check Multiprovider definition: whether KF have been selected from cube b or not...

    If nothing is working -> then go to RSRT : Run> KF explain..

    Hope it helps

    --SA

    Add a comment
    10|10000 characters needed characters exceeded

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.