Simulating measures in BW Queries on BPC Standard CPMB infoproviders

[Former Member]

Hi Experts,

We're facing issues while creating BW queries on CPMB infoproviders.

System: BPC 11 standard on BW/4 HANA 1.0

Requirement: Bex queries on CPMB composite providers to consume the data on SAP Analytics Cloud using Live connections

Scenario: We have created BW Bex queries on top of /CPMB composite provider and faced few challenges.

Few of them like the sign reversal was handled by creating a custom calculation key figure in BW query and the BPC hierarchies were also enabled in BW queries as they are available as native hierarchies on CPMB infoobjects.

The challenging one is in handling the different measures in the BW query. We're unable to handle the different measures dynamically on the fly.

Can any of you please help us understand this approach, whether this is a recommended approach to report BPC data on SAP Analytics Cloud?

Please note, the client does not have a policy for data storage on any cloud servers, hence we are unable to use the native SAP BPC connection in SAC.

Regards,

Sushant Pradhan

[former_member186338]

In past for BPC standard I used model setting - "Use as a Source of Data" Then you will have measures...