Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Combining Data into one Cube from two Data-sources..

Dear Experts,

I am pulling data from two data sources and trying to combine in one Info-Cube. The data are like

Data-Source 01

1. GUID --Common

2.Document No ( User Entry)

3.Dist. Channel

4.Transaction Type

5.Date and Quantity

Data-Source 02

1.GUID -- Common

2.Billing Document ( If User drill down according to Document No , Billing Document should come in the report )

3.Billing date

4.Net Value

Out of the datas , The GUID is common between the 2 data-sources. I was thinking that, tha data will take according to its place and If i select the Document No in Report, it will atomatically fetch all the data like Tran type, dist ch, Billing Document No , Billing date.. .

The problem is , in the report Tha data is not coming as I was thinking.

And Another problem is , In future I need to create a Multiprovider between the above mentioned Info-cube and One ODS. And DOCUMENT NO is common in Cube and ODS.

Please Suggest,

How can I proceed for the following requirement.



Not what you were looking for? View more on this topic or Ask a question