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)
/ 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 a comment