Viewing performance measurements

Contents[Hide]

1. Overview

This article lists all available performance measurements in Dundas BI.

2. Viewing Performance Measurements

Here are the steps on how to view the performance measurements:

1. Open your dashboard, and click Edit

Edit Dashboard
Edit Dashboard

2. Select the data visualization that you want to view the performance measurements

Edit data visualization
Edit data visualization

3. Go to Data Preview, and select Performance Measurements

Data Preview with Performance Measurements
Data Preview with Performance Measurements

4. The performance measurements are shown in milliseconds and the time it was retrieved and prepared.

Performance Measurements View
Performance Measurements View

3. Viewing Overall Performance Measurements

(This feature is available in v.1.0.6 and later)

To view the overall performance measurements of the dashboard, click on the dashboard canvas, and go to Data Preview to see the overview of the performance measurements of all the data visualizations.

Overall Performance Measurements
Overall Performance Measurements

To know which data visualization is for each performance measurement, click on the chart or table name, and it will highlight on the dashboard canvas.

Highlight Chart Performance
Highlight Chart Performance

4. Available Performance Measurements

Measurement

Definition

Description

CachingData Data Caching The time used to cache data and clone the cached result.
CellsetPagination Cellset Pagination The time used to perform cellset pagination.
CellsetSimplification Cellset Simplification The time used to perform cellset simplification for specific data visualization controls.
CollapsingMembers Collapsing Members Merge The time used to collapse cells for the required collapsed members.
ColumnRowConversion Cellset Result Conversion The time used to convert a multi-dimension cellset to a standard column-row cellset result.
DrillDownAnalysis Drill-down Analysis The time used to perform drill down analysis.
ElementStatistics Element Statistics The time used to perform element statistics computations.
FormatMeasureValues Measure Values Formatting The time used to perform measure value formatting.
FormulaProcessing Formula Metric Set Computations The time used to perform formula metric set computations.
GenerateDataRequest Data Requests Definition The time used to generate data request.
GroupRequestAnalysis Client Requests Analysis The time used to analyze the client requests, perform parameter clean-up and request grouping optimizations.
HierarchySorting Hierarchy Sorting The time used to perform in-memory hierarchy sorting.
MeasureAnalysis Measure Analysis The time used to perform measure analysis for measure filtering and for script, missing data and state group computations.
MeasureComputations Measure Computations The time used to perform measure computations.
MeasureConversion Provider Result Conversion The time used to convert a provider column-row cellset to a multiple axis cellset. Dundas BI uses a bi-dimensional cellset that has column and row hierarchies only. However, a client cellset has measures attached to the column tuples (or row tuples if transposed). The conversion time is measured accordingly.
MeasureFiltering Measure Filtering The time used to perform measure filtering.
MeasureSorting Measure Sorting The time used to perform measure sorting.
MergeExpandedMembers Expanded Member Merge The time used to merge expanded members into the cellset result.
MergeParallelPeriod Period-over-Period Merge The time used to merge parallel period results with the main cellset result.
MergingAnnotations Annotations Merge The time used to merge annotations in the result.
MissingDataComputations Missing Data Computations The time used to perform missing data computations.
None No Measurement Category The measurements category has not been specified.
ParallelPeriodAnalysis Period-over-Period Analysis The time used to perform parallel period analysis.
ProviderAnalysis Provider Analysis The time used to perform provider query analysis and optimization.
QueryAnnotations Annotations Query The time used to query the data store for retrieving potential annotations for the current data result.
ResolveDataCache Data Cache Resolution The time used to resolve potential data caching results.
StateGroups State Group COmputations The time used to perform state groups computations.
TotalGroupRequestQuery Total Group Request The total time used to retrieve data for a group of compatible metric set requests (same metric set, same parameters, same overrides).
TotalQueryData ETL Provider Engine The total timing recorded between the end of provider analysis and the time the first record is successfully read from the ETL layer.
TotalQueryHypergraph Hypergraph Engine The total hypergraph query timing.
TotalQueryOlap OLAP Engine The total time used to query the OLAP engine. When OLAP is involved, Dundas BI has this measurement, and potentially other measurements as well if additional conversion/processing is required.
TotalsComputations Totals Computations The time used to compute totals and the corresponding states.
TransformConversion ETL Result Conversion The time used to convert the provider result to a multiple axis cellset.

 

 

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri