Multidimensional Reporting

49 Views

Dear experts,

I want to join an existing data model containing the following 2 data flows:

1) Content Flow from DataSource 1_CO_PAxx to Cube 0COPA_C01 (via Content InfoSource)

2) Customed Flow with Billing-Data to Cube from 2LIS_13_VDITM (via InfoSource and DSO)

- 0COPA_C01 contains (amongst others):

- - CO-Document Number (0ME_CO_DOC)

- - Reference document for COPA (0ME_REFDOC) containing the Bill-Number

- - 0CALDAY

- - Lots of Key figures

- SD Cube contains (amongst others):

- - Bill-Number (0BILL_NUM)

- - 0CALDAY

- - Lots of Key figures

- - Key Fields in DSO are 0BILL_NUM AND 0BILL_ITEM

How can I join the two cubes in a MultiProvider so that I get selected data from both cubes in one single row per CO-Document?

Example:

0COPA_C01 contains:

- 0ME_CO_DOC = "123"

- 0ME_REFDOC = "456"

- 0CALDAY = 28.04.2011

- KYF 1 = 111

- KYF 2 = 222

SD Cube contains:

- 0BILL_NUM = "456"

- 0CALDAY = 28.04.2011

- KYF 3 = 333

- KYF 4 = 444

In a Query I'd like to select by 0CALDAY = 28.04.2011

Expected Output:

0ME_CO_DOC, 0BILL_NUM, KYF1, KYF2, KYF3, KYF4

123, 456, 111, 222, 333, 444

Thanks very much for any help

Patrick