Package com.sap.ip.bi.sdk.dac.olap.query

Contains the OLAP Command Processor and all the sub-packages of the OLAP Query API, generated from the OLAP Query Model, which provides the building blocks for creating OLAP queries.

See:
          Description

Interface Summary
IBIAllFactory Factory which encompasses all factory methods available for an OLAP query.
IBICommandProcessor The OLAP Command Processor, which provides a simplified command API to dynamically change the status of an OLAP query.
IBIInputFactory Factory for elements of the com.sap.ip.bi.sdk.dac.olap.query.input package.
IBIMainFactory Factory for the main elements of a query.
IBIMemberFactory Factory for the elements of the com.sap.ip.bi.sdk.dac.olap.query.member package.
IBIMemberSetFactory Factory for all elements which are member set expressions.
IBIMetadataFactory Factory for some of the CWM objects of the CWM Core (org.omg.cwm.objectmodel.core) package.
IBIQueryFactory Factory for various elements of the OLAP Query Model.
IBISetFactory Factory for all elements which are member set expressions as well as tuple set expressions.
IBITupleSetFactory Factory for all elements which are tuple set expressions.
IBIVarFactory Factory for the variable values of a query.
 

Package com.sap.ip.bi.sdk.dac.olap.query Description

Contains the OLAP Command Processor and all the sub-packages of the OLAP Query API, generated from the OLAP Query Model, which provides the building blocks for creating OLAP queries. This package documentation contains the following sections:

Overview

The OLAP Query Model is an abstract and source system-independent way to describe a multidimensional (OLAP) query and therefore specify a multidimensional result set. This allows you to formulate OLAP queries based on the CWM-compliant metadata provided by OLAP Metadata Model (based on the the CWM Analysis package), independently of data source-specific APIs.

The OLAP Query Model is the basis for the OLAP Query API, which provides methods to create and execute complex OLAP queries based on the metadata in the SDK's CWM-based OLAP Metadata Model. The API is generated via JMI from the query model.

Packages of the OLAP Query API

This package contains query factories and the OLAP Command Processor, and also collects the following supporting sub-packages of the OLAP Query API:

Component Associated SDK Package
OLAP Command Processor
Query factories
this package

Main model
AxisDimension

com.sap.ip.bi.sdk.dac.olap.query.main
Contains all associations between objects of the model com.sap.ip.bi.sdk.dac.olap.query.assoc
InputReference
Adapter classes
NumericValueFunction
Operation
com.sap.ip.bi.sdk.dac.olap.query.input
Member
MemberExpressions
com.sap.ip.bi.sdk.dac.olap.query.member
MemberSetExpressions com.sap.ip.bi.sdk.dac.olap.query.msx
TupleSetExpressions com.sap.ip.bi.sdk.dac.olap.query.tsx
Types com.sap.ip.bi.sdk.dac.olap.query.types
Variables (SAP variables support) com.sap.ip.bi.sdk.dac.olap.query.var
Component Associated CWM Package
OLAP Metadata Model org.omg.cwm.analysis.olap
Foundation for CWM metamodel development org.omg.cwm.objectmodel.core
Provides the Member Object org.omg.cwm.resource.multidimensional
Provides Object, from which Member is derived org.omg.cwm.objectmodel.instance

Note:

If you are viewing this guide with a color-capable display, the coloring used in the diagrams helps you determine the origin of the object. Light yellow represents objects or classes inherited from CWM. Light blue represents SDK-native objects or classes. A clear color represents an SDK-native object or class as well, but designates that it is abstract.

OLAP Command Processor

The OLAP Command Processor supports the definition of often complex queries in a methodical, step-by-step process, providing support for undoing or redoing individual steps, and dynamic modification and refinement of queries without having to rebuild the entire query.

Most of the time, the Command Processor will be all you need to query data sources. However, to leverage the full functionality of the OLAP Query API, you will want to understand the underlying OLAP Query Model described in this package's sub-packages. The model consists of various components, many of which are expressed with UML diagrams.

Basics of OLAP Queries

An OLAP query can be illustrated by the following representation of its result set:

OLAP result set

A multidimensional result set is composed of a set of axes -- rows, columns, and a slicer, in the above example. There can be as many axes as desired, but it's easiest on paper to represent rows and columns, with the slicer on the additional "third dimension." Each axis is populated with tuples. In the case above, two dimensions -- Country and Product -- have been assigned to the rows axis, and the rows axis is populated with tuples belonging to both these dimensions:

Both the columns and the slicer axes have exactly one member selected (Sales Volume and 2001), and are populated with the tuples those members describe.

The intersection of each of the tuples from all axes forms a cell value. These cell values can be regarded as the numbers the query returns, which in the above case are:

In other words, $100 of Speedy Laptops were sold in the USA in 2001, $200 of CN2 Laptops were sold in the USA in 2001, and so on.

This is a simplified representation, but you can see that when you add additional axes and populate your axes with additional dimensions, you can construct highly complex queries.

The OLAP Query Model helps you design queries like these with the SDK.

For Additional Information

Since:
3.50


Copyright © 2004-2006 by SAP AG. All Rights Reserved.
SAP, R/3, mySAP, mySAP.com, xApps, xApp, SAP NetWeaver, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary.
These materials are subject to change without notice. These materials are provided by SAP AG and its affiliated companies (SAP Group) for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.