Detailing Detailing

Measures in Cube visualizer are generated by aggregation of corresponding fields of records. Detailing enables to find out from which records the given measure is generated. To display the detailed information by the selected cell, it is possible to use the following visualizers:

  • Table Table: the data will be displayed by the Table visualizer but without filtering option and detailing panel.
  • Form Form: the data will be displayed by view of a separate row starting from the first one in the list.
  • Statistics Statistics: the data will be displayed by the Statistics visualizer.

Note: It is possible to change the columns sequence order in Table Table and Form Form.

Table Representation Interface

  • Row number Row number: show/hide continuous row number.
  • Record number Record number: switch representation of the column with order record number in this report.
  • Data types Data types: switch data type icon representation.
  • Show null value Show null value: switch <null> representation in the cells with null values.
  • Format Format: open format configuration window of data view.
  • Sort Sort: open data sorting configuration window by columns.
  • Search: search for the next occurrence of the value specified in the search string. It is possible to configure search by pressing Open button.
  • Export Export to file (XLS):
    • XLS: save the current view in the Excel format.
    • HTML: save the current view in the HTML format.

To perform quick sorting by column, it is required to press its caption. The following options will be applied after repeated pressing: in ascending order, in descending order, without sorting. Sorting is possible by several columns. In this case, a figure in the caption will be used to specify the order.

Mouse and navigation panel in the lower part of the visualizer are used for navigation through the table:

  • To previous: go to the previous page.
  • To next: go to the next page.
  • To first: go to the first page.
  • To last: go to the last page.

To go to the given page, it is required to enter its number in the entry field located between the navigation buttons. 50,000 records are displayed on one page.

Form Representation Interface

  • Row number Row number: show/hide continuous row number.
  • Record number Record number: switch representation of the column with order record number in this report.
  • Data types Data types: switch data type icon representation.
  • Show null value Show null value: switch <null> representation in the cells with null values.
  • To previous: go to the previous record.
  • To next: go to the next record.
  • На первую: go to the first record.
  • To last: go to the last record.
  • Export Export to file (XLS):
    • XLS: save the current view in the Excel format.
    • HTML: save the current view in the HTML format.

Statistics Representation Interface

  • Transpose Transpose: turn of the table when the fields names are displayed in columns, and the statistical indicators are displayed in rows.
  • Configure fields Configure fields… : selection of the data set fields for which the statistical indicators will be calculated.
  • Configure indicators Configure indicators…: selection of the statistical indicators.
  • Unique values Unique values: the count of unique values is calculated.
  • Order statistics Order statistics: the order statistics are calculated.
  • Histogram Histogram: the operation that enables to open the detailed window with advanced histogram settings.

Note: It is possible to define the number of records of the data set to which this visualizer is applied in Row count of data column located in the right toolbar part, to the left from the Histogram Histogram button.

results matching ""

    No results matching ""