Dear Focused Insights users,
1. Objectives
This article explains how to use the Generic BEX_QUERIES Data Provider.
2. Supported Renderers
The BEX_QUERIES data provider supports the following list of renderers:
- Line Chart
- Area Chart
- Column chart
- Bar Chart
- Stack Bar Chart
- Line Column
- Dual Line
- Dual Bar Chart
- Dual Line Column
- SLR Renderer
- Dynamic Table
Here is an example of a displayed data using the BEX_QUERIES data provider with the Column Chart renderer:
3. Attributes Description
The BEX_QUERIES has 3 tabs for attributes:
- Queries
- Filters
- Selection
To configure a gadget in the OCC Dashboard for the BEX_QUERIES data provider:
- Select the /STDF/DP_BEX_QUERIES option as a data provider
- Select a renderer
3.1 Queries Tab
- Select a query from the available list
3.2 Filters Tab
Ps: For the Filters tab, the displayed list of the attributes differs from a query to another.
Here is an example of attributes:
3.3 Selection Tab
The selection Tab displays 3 columns:
- Selection
- Fill_gaps
- X_axis
4. How to validate
The results returned by those queries displayed in the OCC dashboard will be compared with the Query Monitor application.
Here is an example of a supported query validation:
We have selected the following attributes as shown in the screenshots:
Query:
/STDF/DP_BEX_QUERIES:Queries=0CCMPDATA-/STDF/QM_AVAILABILITY|Filters=|Selection=1 |Fill_gaps=|X_axis=|0WEEKDAY1=|0SMD_TI5M=|0TIME=|0SMD_LTST=|0SMD_LSID=A4H|0SMD_GRTI=Auto|0SMD_GRDA=Auto|legend=A4H|visible=true|COLOR=#1f77b4|OCC_JUMP_IN=|display_value=false
The displayed chart is:
In order to access to the Query Monitor, execute the RSRT1 transaction.
Once the application is launched:
1. Enter the appropriate query "/STDF/QM_AVAILABILITY" in the query field
2. Click on ‘Execute’ button.
3. Enter the appropriate filters
PS:
In order to use the Stack Column chart renderer, we have to configure more than one query with different status in the same gadget:
In the following example, we have configured four queries:
Query 1: Selection = 1 means that we visualize the system availability in percentage
/STDF/DP_BEX_QUERIES:Queries=0CCMPDATA-/STDF/QD_AVAILABILITY_D|Filters=|Selection=1 |Fill_gaps=|X_axis=|0SMD_GRTI=Auto|0SMD_GRDA=Auto|0SMD_SINA=|0SMD_SITY=|0SMD_LSID=A4H|0WEEKDAY1=|legend=Available|visible=true|COLOR=#1f77b4|OCC_JUMP_IN=|display_value=false
Query 2 : Selection = 2 means that we visualize the system planned non-availability in percentage
/STDF/DP_BEX_QUERIES:Queries=0CCMPDATA-/STDF/QD_AVAILABILITY_D|Filters=|Selection=2 |Fill_gaps=|X_axis=|0SMD_GRTI=Auto|0SMD_GRDA=Auto|0SMD_SINA=|0SMD_SITY=|0SMD_LSID=A4H|0WEEKDAY1=|legend=Planned%20Non-Availability|visible=true|COLOR=#aec7e8|OCC_JUMP_IN=|display_value=false
Query 3 : Selection = 3 means that we visualize the No Measurements
/STDF/DP_BEX_QUERIES:Queries=0CCMPDATA-/STDF/QD_AVAILABILITY_D|Filters=|Selection=3 |Fill_gaps=|X_axis=|0SMD_GRTI=Auto|0SMD_GRDA=Auto|0SMD_SINA=|0SMD_SITY=|0SMD_LSID=A4H|0WEEKDAY1=|legend=No%20Measurements|visible=true|COLOR=#ff7f0e|OCC_JUMP_IN=|display_value=false
Query 4 : Selection = 4 means that we visualize the system unplanned non-availability in percentage
/STDF/DP_BEX_QUERIES:Queries=0CCMPDATA-/STDF/QD_AVAILABILITY_D|Filters=|Selection=4 |Fill_gaps=|X_axis=|0SMD_GRTI=Auto|0SMD_GRDA=Auto|0SMD_SINA=|0SMD_SITY=|0SMD_LSID=A4H|0WEEKDAY1=|legend=Unplanned%20Non-Availability|visible=true|COLOR=#ffbb78|OCC_JUMP_IN=|display_value=false