Skip to Content
0
Former Member
Aug 02, 2006 at 12:38 PM

Multiprovider query

25 Views

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.