A) I have a COPA cube that contains a characteristic called 0SALESDEAL which basicly contains a deal number.
B) I have a DEAL ODS that contains the same characteristic 0SALESDEAL and also a new characteristic ZDEALDESC that contains the description of the deal. This deal number/deal description information is loaded to the ODS from a flat file.
C) The user would like a report that combines deal information in COPA with the actual deal description that is available in my DEAL ODS.
I have created a multiprovider that contains 0SALES DEAL as well as ALL of the characteristics of the COPA cube and also contains 0SALESDEAL and ZDEALDESC from the DEAL ODS yet it does not seem to work. Should this theoretically work?