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

Multiprovider query

Hi experts,

Im printing a query from a multiprovider (cube 1 + cube 2, objects and cubes are Zs) which works fine. Now I need to add and print a new object (Sales Center) from cube 1 which does not have a correspondent identification in Cube 2. But adding this object makes the query to split the items info wrongly, in two rows. In fact, any new object I add to the multiprovider without a correspondent identification in the other cube is printed as #

To exemplify the above:

SalesC / Item / week / Invoice $ (CUBE 1)

AA / 1425 / 2006.01 / 201

AA / 1425 / 2006.02 / 301

AA / 1425 / 2006.03 / 401

SalesC / Item / week / Payment $ (CUBE 2)

  1. / 1425 / 2006.03 / 650

Ideal result:

SalesC / Item / week / Invoice $ / Payment $

1425 / 2006.01 / 201 /

1425 / 2006.02 / 301 /

1425 / 2006.03 / 401 / 650

Sales Center will be used for navigation and summarization purposes. Any idea how to fix this? Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 01:11 PM

    Restrict the characteristic by infoprovider and choose constant selection

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Brad and thanks for your answer, I am not sure how to do your recommendation. Should I do it by cube or multiprovider? Could you give me a hint? Thanks