Error when adding new infoprovider to multiprovider BPC

[former_member782044]

Hello,

I'd like to add a source to my BPC multiprovider (CPMB/...) in order to see the data of this source in my BPC reports.

After having added this new source, I have assigned the objects of the 2 sources (the BW cube and the native BPC cube) in the BPC multiprovider.

In the EPM Add-In Excel, I encountered the following error after having launched a new BPC query on this model. Here is the message I have :

"One or more errors occurred. The execution of report Default Report failed. Please contact your administrator. Bad request. Server message: code: UJHANA_SQE_EXCEPTION_008 severity: error description: Failed to execute query: multiple cube found in multi- provider"

Does anybody have any idea about the cause of this error and the way to fix it?

We are running BPC 10.1 (SP7) on standard Model.

We have BW 7.4 SP12

My EPM add-in used is the last one : SP25..

Thanks in advance for your help.

Regards

[former_member224301]

Hello Jean-François,

My suggestion would be to create a new local connection in EPM add-in (BW ODBO provider one) to your new BW infocube (or BW query since SP25) then create two reports in the same worksheet : one connected to BPC model, another one to the BW infocube or query then if they have some common master data for some dimensions, you can even perform axis sharing between both reports to have some columns (or rows) with data from BPC and other ones with data from BW object.

NB : you need BW MDX provider on your machine to get the BW OLE DB provider connection in the list of EPM add-in local connections.

Axis sharing feature is documented in EPM add-in user guide.

Hope that helps.

best regards,

Florent

[jerome_chatenay]

Hello Jean-François,

Following our discussion through the OSS incident my support statement was that what you want to do is not possible. The solution would be to import your ERP data in a BPC cube. But this is a Standard Support point of view. Support dpt is not Consutling dpt.

You answered that this possibility is described in foolowing snc post :

http://scn.sap.com/people/pravin.datar/blog/2010/05/04/reporting-plan-and-actual-values-in-bpc-nw

and that your first tests on the topic were completely successful.

I will ask my dev team to review your post and give their feedback.

Regards

Jérôme

[Shrikant_Jadhav]

Hi Jean,

You are not supposed to change any standard object of BPC from back end.

If you want do reporting on data which is not in BPC cube then -

1) You can create different connection to BW cube in EPM and create report.

2) Retract data of BPC in another BW cube and do reporting.

Shri