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:


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

  • No labels