Skip to Content

BPC XMLA Documentation or How to use?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Oct 20, 2016 at 10:22 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2016 at 10:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Roberto De la Torre

      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

  • Oct 20, 2016 at 10:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 21, 2016 at 08:52 AM

    Hi Roberto,

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

    Regards

    Roberto

    Add comment
    10|10000 characters needed characters exceeded

    • 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