Configuring the Data mart explorer template

You can use the Data mart explorer template to view the charts for detailed data that is extracted from a data mart. For example, you can use this template for generating detailed view in the charts by the aggregation of the data in the data mart for the selected systems.

Before you begin

Create a data mart that provides the time series details about the entities and contains numeric values. For more information, see  Creating a SQL-based data mart for a custom view in the TrueSight console .

To configure the template

The following video (9:01) illustrates the process of creating a custom view by using the Data mart explorer template.

  1. Open the view page with the Data mart explorer template:

  2. In the view page, specify the following information:
    1. Title: Type the required title for the page.
    2. Configure the charts. By default, the display of only one chart is enabled. If you do not want to display this chart, click on the chart and in the window that opens, click Enabled to disable it and click Apply

      Click in the individual chart and configure the following properties:

      1. Title: Type a title for the chart.

      2. Template: Select a template from the list, based on which to render the chart. The following templates are available.

        • Area Chart
        • Bar Chart
        • Line Chart
        • Pie Chart
        • Stacked Area Chart
        • Stacked Bar Chart
        • <custom analysis templates that you have created in the TrueSight Capacity Optimization console>

          Only custom templates created using the Enterprise Reporting analysis type are displayed in this list. For information about creating the Enterprise Reporting analysis, see Manually creating an analysis.

          For information about the types of charts, see Analysis chart types supported in the TrueSight console.

        The following functions from the analysis chart types are not supported in the charts in TrueSight console:

        • Trendlines
        • Right axis on line charts
        • Calendar charts
        • Other minor customization options (Format of ticks, Format of dates, Label rotation, Format of chart grid, Logarithmic axes, Palette, Dashed lines)

      3. Data mart: Select the data mart from the list that contains the required data to be displayed in the charts. The options in the Column for time axis and Column to identify the series fields are displayed according to the data mart selected.
      4. Column for time axis: Select the column that contains the time stamp data in the selected data mart. The selected column is used for identifying the time axis in the chart. For example, if the TS column in the selected data mart contains date or time stamp data for the entities, you can select the TS column for this field.
      5. Column to identify the series: Select the column that can be used for identifying the data in a row in the selected data mart.
        For example, consider an e-commerce company uses data mart as follows to store details of orders and transactions performed using either online stores or web portals:

        2017-02-27 00:00:00Online store13021189
        2017-02-27 00:00:00Web portal15061190
        2017-02-28 00:00:00Online store1003940
        2017-02-28 00:00:00Web portal9301096

        In this case, select Entname for this field as it identifies the medium used for orders and transactions, and can be used to plot series in the chart.

      6. Select the required metric from the Metric value 1 list. To add a metric, click + Add metric
        You can add multiple metrics. 

    3. Click Apply to go back to the previous edit screen.

    4. To configure the first table, click in the table section. In the edit box at the bottom, first enable the table by clicking . The following properties are available to edit: .

      1. Datamart: Select a datamart from the list. You must select a datamart to be able to show data in the page.
      2. Title: Type the required title for the page.
      3. Columns: Add columns to the table and select the corresponding metric for each column. By default, four columns are displayed.
        To add more columns, click + Add column. To delete a column click X at the top-right of that column.
      4. Select a value for each column, from the list. 
      5. To modify the default column header label, renderer, and column visibility option, select a column, and click the corresponding Edit parameters link to configure it further:

        In the Edit <columnName> parameters screen that opens, specify the following options:

        1. If you do not want the column name as appears in the data mart to be displayed as the column header, type a new label in the Column header label field.

        2. Select the Renderer and configure it. 

          The default renderer is automatically selected based on the data mart column that you select in the previous step. For example, if you select data center (dc_name) as one of the columns, the corresponding default renderer for that column is Text

          Depending on the selected renderer, the parameters to configure differ. For more information about the available renderers, see Renderer options in custom views

        3. In the Column visibility section, specify whether the column must be shown or hidden on the view page:

          • Column is always shown: The column is permanently shown. User of the view cannot hide the column.

          • Column is displayed and user can hide it: The column is shown by default. The user can hide or show it from the Show/Hide columns window.

          • Column is hidden and the user can show it: The column is hidden by default. The user can choose to show or hide it from the Show/Hide columns window.

             Consider the following example

            As per the following column configuration, the CPU column is displayed by default and the view page users can hide it.

            When the users open the view page, the CPU column is displayed.

            If a user wants to hide the column, from the table action menu, select Show/Hide Columns.

            In the Show/Hide Columns window, the CPU column is displayed, by default. To hide the metric, clear the check box and click Save.

            The column is not displayed in the table.

        4. After you complete editing parameters for one column, click Done to return to the previous edit screen. 

          You can continue to edit parameters for other columns.

      6. To reorder the columns, click Reorder columns. Type the required order or position number in the Order field for the required column. The columns rearrange automatically.


        You can only enter a number between 1 and the total number of columns in the Order field. For example, if four columns are displayed, then you cannot add an order number greater than 4.

      7. After you complete editing parameters for that column, click Done to return to the previous edit screen.

        You can continue to edit parameters for other columns.

    5. Click Apply. The changes are updated dynamically in the view, and you continue to be in the edit mode.

      To configure multiple tables, clickin the next table section. You can configure a maximum of 9 tables in the view.

    6. In the filter area, click select the required data mart from the list. Options displayed in the list are based on the data marts selected for charts and table.
    7. Add filter: You can add the filter using one of the following configurations:

      • Basic configuration: Select a column from the drop-down list. The list displays the columns from the data mart that you selected in the previous step (primary data mart).

      • Advanced configuration: Click the Advanced link. You can configure one of the following settings:

        • Data mart: Select this option to add a filter with a column from a different data mart than the primary data mart. By default, the primary data mart is displayed. You can also mark this filter as required to restrict the data to be displayed automatically in the view.
          In the custom view, the required filter is denoted by an asterisk. If you have configured multiple filters and at least one of them is the required filter, the data is not displayed unless you select the values for all required filters.

        • Free text name: Select this option to add a filter with a free text and provide the following values:

       Consider the following example that shows the use of filters on the view page

      Consider that you have configured three filters and filter 2 (Entid) is a required filter.

      The output of the custom view page is as follows. No data is displayed because no value is selected in the Entid filter. 

      Select a value in the Entid filter. You custom view page displays data. You can also select a value for the Host ID filter.

      Because every filter is dependent on the previous filter, when you select a value for the Entname filter, the values in the Entid and Host ID filters get cleared. 

      Create quick filter for Filter 1: Select the check box to display Filter 1 as a quick filter on the custom view page. All distinct values of Filter 1 are available as clickable buttons. The following figure shows an example of how the quick filter appears on the custom view page:

      Hierarchical filters: When selected, the filters follow the hierarchy on the custom view page. Every filter acts as a parent filter for the filter next to it. The data in the view is filtered based on the value selected in filter 1, then by filter 2, filter 3, and so on. When you clear the values in any filter, the values in the dependent filters get cleared.


      You can configure a maximum of 20 filters on a page.

  3. Click Save.

    The custom view page is created with the defined configuration. You can filter the charts in the view page by applying the appropriate filter. 

Examples of a view page with the Data mart explorer template

Example 1: Generated by plotting the aggregated data for each series (by using Line chart)

Example 2: Generated by plotting each value of series in the data mart (by using Bar chart)

Was this page helpful? Yes No Submitting... Thank you