Show TOC

 Data Provider ParametersLocate this document in the navigation structure

Definition

Data providers are objects that provide data for one or more Web items at runtime. There are two types of data providers:

  • Query view

    This type includes data providers with queries and query views. The result set consists of characteristics and key figures.

  • Filter

    This type is a data provider that describes a navigation state. The result set usually includes a characteristic or the combination of several characteristics without the key figures. For example, a filter can be used for Web items that are used for filtering, such as a dropdown box or radio button group.

Structure

The following information lists the parameters for the data provider parameters, arranged according to the various parameter groupings.

Data Binding

Parameter Description

Data Provider (DATA_PROVIDER)

Type of data binding:

  • Data providers for queries and query views

    (QUERY_VIEW_DATA_PROVIDER)

  • Data providers of type Filter

    (SELECTOR_DATA_PROVIDER)

Data providers for queries and query views

(QUERY_VIEW_DATA_PROVIDER)

These data providers offer the data for Web items that display the results of a query or query view.

  • System (SYSTEM)

    The system alias is defined as in the system landscape in the portal. This is an optional parameter that is only required for access to external systems using XMLA or ODBO. The connection is with BI Java connectors.

  • Start state of queries and query views

    More information about the start state of queries and query views is available below.

Data providers of type Filter

(SELECTOR_DATA_PROVIDER)

These data providers can be used for Web items that are used for filtering data, such as dropdown boxes.

  • System (SYSTEM)

    The system alias is defined as in the system landscape in the portal. This is an optional parameter that is only required for access to external systems using XMLA or ODBO. The connection is with BI Java connectors.

  • Start state of the filter or filter view

    More information about the start state of queries and query views is available below.

Data Providers for Queries and Query Views (QUERY_VIEW_DATA_PROVIDER)

Parameter Description

Start state of queries and query views

(INITIAL_STATE)

This parameter describes the start state of the data provider, that is, the source from which the data provider retrieves the data.

Possible values:

  • Query (QUERY)
  • Query View (VIEW)
  • InfoProvider (INFOPROVIDER)
  • Properties List (NAMED_PROPERTY_LIST)
  • Empty (EMPTY)

Query (QUERY)

With this parameter, a query is used as a data source.

Query View (VIEW)

With this parameter, a query view is used as a data source. A query view is a modified view of the data for a query or an external InfoProvider.

InfoProvider (INFOPROVIDER)

With this parameter, an InfoProvider is used as a data source.

Properties List (NAMED_PROPERTY_LIST)

With the property list you can describe the start state with several parameters.

Empty (EMPTY)

This parameter describes a data provider that is not initialized. The data provider can be set at runtime with a URL or a command.

Data Providers of Type Filter (SELECTOR_DATA_PROVIDER)

Parameter Description

Start state of the filter or filter view (SELECTOR_INITIAL_STATE)

With this parameter you can define the start state of the data provider.

Possible values:

  • Filter (SELECTION_OBJECT)
  • Filter View (SELECTOR_VIEW)
  • Query (QUERY)*
  • InfoProvider (INFOPROVIDER)*
  • Property List (NAMED_PROPERTY_LIST)*
  • Leer (EMPTY)*

*These values for data providers of type Filter are identical to the data providers for queries and query views. Details are available above.

Filter (SELECTION_OBJECT)

With this parameter, a filter is used as a data source. A filter specifies a multidimensional subset of data from a dataset.

Filter View (SELECTOR_VIEW)

With this parameter, a filter view is used as a data source. A filter view is the modified view on the data of a filter.

Example

Example for a data provider of type Query View with the query 0D_DX_M01_Q0002 from an external system BI_HR:

<bi:QUERY_VIEW_DATA_PROVIDER name="DP_1" >

<bi:SYSTEM value="BI_HR" />

<bi:INITIAL_STATE type="CHOICE" value="QUERY" >

<bi:QUERY value="0D_DX_M01_Q0002" />

</bi:INITIAL_STATE>

</bi:QUERY_VIEW_DATA_PROVIDER>

If the parameter System is not specified, the data is read from your own system.

More information:

Working with Data Providers 

Working with Queries 

Working with Query Views 

Working with Filters 

BI Java Connectors