Skip to main content
Mitratech Success Center
Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.

 

TeamConnect Business Intelligence (Linux) Enhanced Statistics in Data Preview for ElastiCubes

  1. Last updated
  2. Save as PDF
This document provides an overview of how to access and use the Enhanced Statistics in Data Preview feature in the ElastiCube (eCube).

Overview

The Enhanced Statistics in Data Preview feature is now available in the ElastiCube (eCube) environment. This feature allows users to quickly analyze, summarize, and understand data without building dashboards or writing queries. In the current TeamConnect integration, only Administrators have access to the eCube. TeamConnect users can use the data exposed by the eCube but cannot view or navigate the eCube model. With appropriate permissions, users can explore eCube tables, preview data, and view column-level statistics.

Access Requirements

To use Enhanced Statistics in Data Preview:

  1. You must have direct access to the ElastiCube.
  2. In the current TeamConnect configuration:
  • Administrators have access to the eCube.
  • TeamConnect end users do not have access to the eCube model.

Navigating the ElastiCube Model

Once you have access, you can browse the eCube structure tables, fields, and joins.

  1. Open the ElastiCube Manager.
  2. Navigate the model to locate the table you want to analyze.

elasticcube manager.png

  1. Click on a table that needs to be analyzed, it will give an option to Analyze. Select the magnifying glass with the plus sign or "Preview" icon, the user will have two options:
    • Preview
    • Statistics

Invoice.png

Preview helps displaying the data in a table format, similar to "select * from table" in sql developer:

Tables preview.png

 

Statistics option displays detailed profile information for each column in the selected table.

Statics.png

The statistics supports all datatypes that we use in the eCube:

  • Number
  • String
  • Date

It gives the Nulls count, Distinct Values and Standard Deviation when applicable (Number and Date datatype are supported). The bar chart is also interactive. When a user highlights a bar, it will automatically apply a filter for that highlighted data. Here is an example of filter applied to PRIORITYDI=Normal:

Statics 2.png

This feature provides users with the ability to swiftly analyze, summarize, and describe data, discover patterns, and make predictions without needing to construct a full dashboard.

For instance, the statistics from the "Dispute Details" table immediately reveal the distribution of dispute priorities (Normal, Low, High). Furthermore, when a user filters the priority to "Low," the system automatically provides information on the corresponding distribution of the Jurisdiction.

Statics 3.png

Each column displays a maximum of seven values. If a column contains more than seven distinct values:

  • The top seven values appear individually.
  • All remaining values are grouped into an Other category.

Jurisdiction.png

While these capabilities are especially valuable for end users, access to the ElastiCube is currently restricted to Administrators and Hosting teams, limiting the feature's utility for its intended audience.