|
SAP BI Java SDK | |||||||
PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES |
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. |
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:
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.
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 |
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.
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.
An OLAP query can be illustrated by the following representation of its 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.
See OLAP code samples on the Examples page
|
SAP BI Java SDK | |||||||
PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES |