BPC XMLA Documentation or How to use?

[former_member208963]

Dear People,

I am trying to search any information about BPC XMLA, and how to connect to SAP BPC 10 MS to retrieve an XML somehow to provide information to other systems, aparently I need this but is amost imposibble to find any documentation on this.

I've only found how to connect/install but no how to use this to query BPC??

Someone can point me to the correct document or Guide?

I was trying to build this xml using Xcelsius service but is my BPC MS 10 installations is not compatible and this is discontinued. (It was for SAP Business Planning andConsolidation 7.0 Version for Microsoft SP3)

Is there any other way? apart from creating a specific webservice to SQL?

Many thanks in advance

[former_member186498]

Hi Roberto,

se please this note 2192074 - XMLA: How to configure XMLA for BPC 10 MS

Regards

Roberto

[former_member208963]

Thanks Robert, I had already an installation of the XLMA running under BPC/APP Directory, but I did a manual one following the NOTE.

After doing this I have the same screen I had before, the point is how to use this?

Can I Run a Query in he browser? Type Xcelsius? no instructions in the previous notes 😞

Something like:

http://localhost/sap/bpc/app/XcelsiusService/QueryResults.asmx/Query=MyRange:TIMEID:2016.JAN|ENTITY:...

Thanks

[JohnL]

Hi Roberto,

See this blog:

https://planingandconsolidation.wordpress.com/2013/07/03/how-to-use-the-epm-connector-to-visualize-b...

The only difference is that you will need to use a local connection of the BPC MS ODBO provider in step 2 located at:

https://launchpad.support.sap.com/#/softwarecenter/template/products/_APP=00200682500000001943&_EVEN...

• SAP BPC FOR MICROSOFT/
• SBOP PC 10.0 FOR MICROSOFT/
• SAP CPM BPC ODBO 2.0

https://websmp106.sap-ag.de/~sapidb/012002523100015049512014D/BPC100MODBO15_0-20008265.EXE

HTH

[former_member208963]

Thanks for your answer John,

I am looking for a way to communicate data from BPC to other Systems,

Example: a webservice to Query BPC database with some parameters and retrieve the data in XML.

I saw and old document talking about this an how to run a query in the browser and received the XML.

Something like:

http://localhost/sap/bpc/app/XcelsiusService/QueryResults.asmx/Query=MyRange:TIMEID:2016.JAN|ENTITY:...

Is this related to this?

Regards

[former_member208963]

Dear Robert, thanks for your answer,

My company requested me to provide certain way to access BPC database information -real time- to other systems, (Backend) like for example list of the Accounts that met some properties etc... in a XML, I though we can achieve this with the Xcelsius aproach, but the service is not officially compatible with BPC 10.

I am afraid at the end I will need a REST/webservice to conenct to the sql database...What do you think?

https://archive.sap.com/discussions/thread/3146630

Regards

[Former Member]

Hi Roberto,

Please refer to SAP Note 1713232 - How to configure XMLA for BPC 10.

Also as per this document and note BPC XMLA is supported to BPC MS! https://wiki.scn.sap.com/wiki/display/CPM/Connectivity+options+between+various+SAP+BusinessObjects+B...

Check this too https://apps.support.sap.com/sap/support/knowledge/public/en/1731626

https://apps.support.sap.com/sap/support/knowledge/public/en/1835213

Regards,

JP

[Former Member]

Also check these thraeds....https://archive.sap.com/discussions/thread/3196295

https://archive.sap.com/discussions/thread/3535184

[former_member208963]

Thanks JP, but at the end is always pointing to the same PDF notes, installation, Matrix...but not on How to use this 😞

[Former Member]

Hey....the first note is an how to for XMLA...... Well I dont know why this was not documented by SAP, but atleast they have some notes for it....:) I could find lots of thraeds for this where people had posted their steps..not all but some. Atleast a headstart is better than nothing! We are Consultants.....we can manage...rite? 🙂

Offcourse you can always contact SAP Support for this! They will help you out.

JP

[former_member186498]

Hi Roberto,

I never seen docs about xmla but if you need to connect bpc with other systems you can use odbc or other connection types choosing "local" in "create connection" on epm add-in.

Regards

Roberto