cancel
Showing results for 
Search instead for 
Did you mean: 

multi provider

Former Member
0 Kudos

Hi All,

I am facing below problem, please help me on this.

The data is extracting from non-sap system and sap system. For non-SAP system we have one cube as well as for sap system. From these I have to create the new report. So I want to create new multi provider for combined data. But I donu2019t have any common field in these cubes.

Please let me know the solution.

Thanks in Advance.

Ravi

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

common field is not required for multiprovider because muliprovider is based on the union .

Thanks,

Sai.

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Ravi,

in this coexistence scenario you may try the following:

key figures: define calculated key figures as sum of key figures of both cubes,

characteristics: define common characteristics, e.g. ZCMAT ("coex material") to hold both SAP keys and non-sap keys. If number ranges overlap, you will have to concatenate a prefix into the non-sap keys. Then use this common object as navigation attribut of the SAP object (e.g. 0MATERIAL) and of the corresponding non-sap object (e.g. ZLGMAT "legacy material"). put the the common object into an empty dummy cube just to get it into the multiprovider. Finally map the common object in the multiprovider to the two navigation attributes.

This allows to report on one coexistence material.

Even better: if a mapping from non-sap keys to sap keys is available (or the other way around), you may fill ZCMAT with sap keys also for non-sap data. then you can run a year to year comparison based on sap keys, although previous years data is non-sap data.

Hope that helps.

Best regards,

Jürgen

Former Member
0 Kudos

Hi Ravi,

You dont require to have a common field for creating a multiprovider.

Multiprovider is a Union, and it combines data of underlying infoproviders.

Revert in case of doubts.

Regards,

Hardik

Former Member
0 Kudos

Hi ravi

You do not require a common field in the 2 cubes to include them in multiprovider as Multiprovider is a union and not inetrsection (like infoset). You can directly include the infocubes in the multiprovider and assign the fields in the multiprovider to the cube fields as required.

Regards,

Ninad

former_member222556
Contributor
0 Kudos

Hi,

Multiprovider is a Union of Multiple Target

EX:-

Cube 1 :- MAterial, Customer , Amount

Cube 2 :- Po Number, Date, Qty

then Multiprovider of these two will have:-

MAterial, Customer , Amount, Po Number, Date, Qty.

But while creation of MP, identification should be done properly (from which target, the data is coming)

Best Regards

Obaid