Skip to Content
avatar image
Former Member

BW Connection Level for Reporting Tools

Does anyone know of a list somewhere that shows all the reporting tools in BusinessObjects (and maybe even other tools, such as Microsoft PowerBI), along with which level in BW they can connect to (Cube vs. BEx query, etc.)? For example, Analysis for OLAP can connect to cubes or BEx queries, but WebI can only connect to BEx queries (unless going through a universe).

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 23, 2017 at 07:56 PM

    PAM, supported platforms guide in its semantic layer attachment has this information for all BI tools.

    https://apps.support.sap.com/sap(bD1lbiZjPTAwMQ==)/support/pam/pam.html?smpsrv=https%3a%2f%2fwebsmp109.sap-ag.de#ts=1&pvnr=73555000100900000046&pt=g%7Cd

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 28, 2017 at 07:17 PM

    Hi Nick,

    Some context may be useful. BW queries use two different protocols: BICS and MDX

    MDX:

    The MDX protocol is used by almost all BI Vendors. By clicking on the "Make externally available" flag in the query, the MDX protocol makes data available to MicroStrategy, Birst, Tableau and well as BusinessObjects. Processing is "heavy" in the application layer of BW. (FYI: last time I checked, Tableau's "seamless integration" to BW was superior to all others, including BusinessObjects.Direct connections to BW InfoProviders remains problematic.

    BICS:

    BICS is the protocol that that BW uses in its native queries to communicate directly with the databases, The latest version of BusinessObjects (4.2) also can use the BICS protocal to force processing to the database layer. This is a key differentiator from using BusinessObjects vs. other vendors on HANA. The ability to use BICS enables the HANA database to force more processing down to the HANA database layer and leverage HANA's advantages most effectively. To my knowledge, other vendors do not yet use the BICS protocol. BusinessObjects still needs the "Make externally available" flag in the BW query checked, but the back end is smart enough to use the BICS protocol instead of the BICS protocol. Direct connections to BW InfoProviders remains problematic.

    Summary:

    Selecting a BI Vendor requires a trade off between ease of use, ease of set up, and performance. For example, MicroStrategy has "raving fans" for ease of use and functionally, requires more set up of its semantic layer, but has reasonable performance on HANA using the MDX protocol.

    Let me know if this helped!

    John Hawk

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 28, 2017 at 09:16 PM

    Thanks for all the information provided by Denis and John. However, since I was not able to find a list anywhere, I just opened each tool that is available to me, and tested each one to see what layers within BW I could connect to. So for now, I have the information I need.

    Add comment
    10|10000 characters needed characters exceeded