Skip to Content
author's profile photo Former Member
Former Member

What are BW Queries

Hi ,

I would like to extract data from BW query and its output of should populate into the selection screen which is developed in Web Dynpro.

Can anyone please calrify my dout



Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 09, 2007 at 05:52 AM
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Chandrashekar,

      For SAP its

      The SAP Business Information Warehouse (BW) front-end tools and their business content fulfill many business

      intelligence needs. Now, with the addition of the BI Java SDK, you can develop highly customized business analytics

      to complement your existing business intelligence solution, using the BI Java SDK as SAP's main interface for

      accessing any OLAP or relational data your applications or client components need.

      BW’s existing Open Analysis Interfaces — XML for Analysis, the OLAP BAPI, and OLE DB for OLAP — allow you to

      access BW or external OLAP data for your custom application needs. The BI Java SDK provides additional

      capabilities and simplifies the task of implementing client applications based on these interfaces. The SDK

      encapsulates underlying low-level communication protocols such as HTTP, and simplifies the generation of complex

      MDX or SQL query statements.

      Although the primary intention of the SDK is to simplify programming against the BW OLAP engine within a Java

      environment, the application programming interfaces (APIs) can also be used to access non-BW and even non-OLAP

      data sources, such as relational JDBC data sources. This allows programmers to work with a single uniform approach

      throughout development of an application.

      The BI Java SDK provides an object-oriented framework in which to:

      • Connect to a variety of data sources

      • Access master- and metadata

      • Create and execute complex queries

      • Render and access query result sets

      A driver-based architecture supports access to different data formats using a variety of protocols:

      • Java Database Connectivity (JDBC)

      • OLE DB for OLAP (ODBO)


      Components of the SDK


      • SAP Query

      • XML for Analysis (XMLA)