Multicube query

[Former Member]

Hello all,

I have 2 issues that i am facing with multicubes.

1. We have a sales order cube which is being fed from 2ODS sales order header&item and the other being sales order schedule line. When i run the query i want to see only one line with the details of the few characteristics that are on the header.

2. I have multicubed sales order and deliveries.The report requires that i give selection criteria on goods issue date which is present only on th deliveries cube. How do i get the corresponding values of the characteristics present in the sales order cube based on delivery number.Also I want to have only one line in the report with data coming from both cubes.

thanks in advance

amit

[Former Member]

Could be an application for an Infoset, which would let you perform a true relational join between the header ODS and the line item ODS.

[Former Member]

hi amit,

2- unfortunately, since multiproviders are joined (via union) against their dimensions, if you have a dimension that isn't common for all infocubes in the multiprovider, you won't be able to make a report filtering on that dimension.

in both cases, it's a bit unclear to me what you mean by only having one line in the report... could you clarify this for us?

ryan.

[Former Member]

Ryan,

Let us take the case where we are pushing data from 2 ODS where in which for each header we have a number of items.

Now for any query on the cube i beleive we get for 1 order number of the header we get a number of lines= number of items for that order number.But the users do not want to see the items but only 1 line which says if any of items fail to be delivered we get 1 line stating the order number and the reason.

Is this possible to be done.

With respect to your answer i understand that is not possible. But i read somewhere its possible to overcome using restricted key figure but not sure how.

thanks

amit

[Former Member]

amit,

ah, now i understand...

i think you could do what you need by creating a query on a multiprovider on the two ODS, and put the header detail information and order item information (like, total quantity ordered and delivered, which you can produce in a calculated KF) in your query output. then, create a condition stating that the report will only output records based on a certain condition, like in this case, if the total ordered is not equal to the total delivered.

you could play around with this a bit more, but this is more or less how you should go about it.

ryan.