Skip to end of metadata
Go to start of metadata

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:


/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_AVAILABILITYin the query field 

2. Click on ‘Execute’ button. 

3. Enter the appropriate filters 


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

  • No labels