Combining Data into one Cube from two Data-sources..
I am pulling data from two data sources and trying to combine in one Info-Cube. The data are like
1. GUID --Common
2.Document No ( User Entry)
5.Date and Quantity
1.GUID -- Common
2.Billing Document ( If User drill down according to Document No , Billing Document should come in the report )
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.
How can I proceed for the following requirement.