Multiprovider

[Former Member]

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.

QUESTION:

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?

[Former Member]

Basicly I want to see all characteristics and all key figures in the COPA cube. The only thing I want from the Deal ODS is the deal description. So essentially I'm trying to perform the equivalent of a 'lookup'... you could even say I want to mimic what master data would give me... for example I have deal number in my cube but the description texts is not loaded into the cube from SAP. So I'm trying to get around that by loaded the texts from an external data source. Maybe I should be approaching it differently?

In regards to master data is it possible to have part of the master data pull from SAP (ie: Number) and another part (ie: texts) pull from a flat file? Essensially this is what I'm attempting to do in the easiest way possible.

Unfortunately I'm being pressured to have a solution fast so I'm resort to simple modifying my update rules for my COPA cube so that it performs a routine that looks up the data in the DEAL ODS. I've done this before but don't think it's ideal.

[former_member188975]

Hi Patrick,

I think it is a good idea to have the Deal description as part of the master data. It is possible to to have part of the master data pull from SAP (ie: Number) and another part (ie: texts) pull from a flat file. You will have to do a flexible update to your SalesDeal number InfoObject, i.e. use update rules. You can then assign the SAP and the Flat File data source to the infosource and load.

Take a look at this link for more info:

http://help.sap.com/saphelp_nw04/helpdata/en/87/3fdf9587f211d5b2ff0050da4c74dc/content.htm

Hope this helps...

[Former Member]

If you have ZDEALDISC in your report you will not be able to see the Key figures from the cube..

If you give the layout of the report it will be helpful..

Ashish.

[former_member188975]

Have you checked the Identification screen to see that 0SALESDEAL is being included from both the Cube and the ODS? Is all the data in the ODS Active? What happens when you run the report?