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.
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 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.