Sentinel Web Dashboard concepts

Sentinel allows you to build dynamic management dashboards based on the data Sentinel collects.

Sentinel Web Dashboard is comprised four key components:

After you create your Web Dashboards they will provide real time business process visibility and flow analytics.

Worlds

A world is a collection of information you use to connect to a database. It consists of:

  • A driver
  • The URL that points to the database
  • Log in credentials

Once defined, it is only necessary to specify a world rather than each piece of database connection information.

Data dictionaries

A data dictionary represents a selection of data on which reports, metrics and alerts (and ultimately, Web Dashboards) are based. Typically, a data dictionary represents a subset of a database and includes a reference to a world, which is a collection of the information required to log in to a database.

Types of data dictionaries

There are three different types of data dictionaries:

Standard data dictionary

You can create a standard data dictionary based on the data returned from Sentinel. A standard data dictionary has what is commonly referred to as a star structure.

When you create a standard data dictionary, Web Dashboard automatically generates SQL code based on this model. Standard mode makes it possible to generate the most appropriate SQL query because the query is generated after the columns have been selected and any filters have been specified.

A standard data dictionary is implemented as a measurements table and related dimension tables. In this example:

  • PRODUCTS is the measurements table.
  • PRODUCTCATEGORY, SALES, AND GLCATEGORY are the dimension tables.

Data structure of product category, products, sales and component

SQL data dictionary

When you create a SQL data dictionary, you enter SQL directly into the data dictionary definition. The SQL you enter is used to extract data from worlds. SQL mode allows you to process DBMS-specific queries or queries that are as complex as you like. You can use the database explorer to help you write your SQL.

The list of possible report-level filters contains only filters defined for the data dictionary.

Note   SQL queries entered by the user must be compatible with the Sentinel database.

Multi-World data dictionary

Multiple data dictionaries can be combined to form a multi-world data dictionary.

This type of data dictionary is defined like a dictionary, except the world selection function is disabled. You create the data structure like you would a standard data dictionary without the constraint of the tables belonging to the same world. Instead, data dictionaries only need to belong to the same entity or one of its parents.

Similar to the standard data dictionary, Sentinel generates SQL code automatically based on the model you create.

Reports

A report is a representation of a set of data (typically, a data dictionary) in any of a variety of forms. The simplest report is a table based on a data dictionary consisting data from a single table. However, it is possible to build complex, graphical reports based on data from multiple tables.

You can run a report in either Interactive mode or Static mode. In Static mode, the database is queried each time the report is displayed, which is useful if you require a real-time view of your data.

Web Dashboards

A Web Dashboard is used to display the data you capture. Each dashboard consists of one or more pages called templates. There are several page layouts available for templates and each template can use a different page layout. Each template can contain one or more blocks. There are several different types of blocks available:

  • Report
  • Text session
  • External session
  • Control
  • Dashboard
  • Metric
  • Metric dashboard
  • Strategy map

Dashboard template with four  blocks

Related Links