Reports

Overview Video

Introduction

Reports are data structures similar to the views in relational database systems. They allow you to have an aggregated view of the data stored in cubes, based on measures, dimensions, and buckets.

Report Attributes

When you build reports on top of the cubes, the columns of the cube are transformed into attributes that are the data sources for all visualization widgets available in the application.

Attributes are of two types:

  • Dimension: the columns of type string and date are in this category. The dimension attributes work as categories for your data, allowing you to create representations of operator-per-category. The operator applies to the measure attributes.
  • Measure: the columns of numeric type or the vectors of numbers are in this category.

Measure attributes are assigned with an aggregation method, called an operator. By default, it is the sum of the values. You can change it from the properties page of the attribute.

You can create new attributes, such as buckets or new derived attributes, based on the computations with the existing attributes.