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