What are BW Queries

[Former Member]

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

Regards

Chandrashekar

[Former Member]

Hi,

Hope the following links will shed some light to your query.

http://help.sap.com/javadocs/NW04/current/bi/docs/examples.html

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/biw/g-i/how%20to%2...

Regards

Ayyapparaj

[Former Member]

Hi Ayyapparaj,

Are these links related to BW..

,

[Former Member]

Hi Chandrashekar,

If you have gone through the links the question might have never arised.

Links provide the way to use the BI XMLA Connector to connect to and SAP BW system.

Regards

Ayyapparaj

[Former Member]

Hi Ayyapparaj ,

Can u please give me a brief description about SAP BW system.

Is it that same as extracting data from SAP backend system and showing the result in a table

Regards

Chandrashekar

[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)

Introduction

Components of the SDK

2

• SAP Query

• XML for Analysis (XMLA)

Regards

Ayyapparaj