Skip to Content
0

BPC XMLA Documentation or How to use?

Oct 20, 2016 at 09:24 AM

187

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Roberto Vidotti Oct 20, 2016 at 10:22 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Priyanka Jagtap Oct 20, 2016 at 10:34 AM
0

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+BI+tools+and+BPC

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded
0

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

0

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

0
Roberto De la Torre Oct 20, 2016 at 10:36 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Roberto Vidotti Oct 21, 2016 at 08:52 AM
0

Hi Roberto,

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

Regards

Roberto

Show 3 Share
10 |10000 characters needed characters left characters exceeded

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:WORLD&AppSet=Planning&App=PlanApp&showRowHeaders=true&showColumnHeaders=true

Thanks

image-292.png (5.5 kB)
0
1

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:WORLD&AppSet=Planning&App=PlanApp&showRowHeaders=true&showColumnHeaders=true

Is this related to this?

Regards

0