TANDBERG ANALYTICS EXTENSION - Administrator's Manual - Introduction
Introduction
TANDBERG Analytics Extension Admin guide
5
Introduction
This document describes the TANDBERG Analytics Extension.
The TANDBERG Analytics Extension is an online analytical processing (OLAP) system for the
TANDBERG Management Suite (TMS) and provides advanced reporting functionality on your video
network. It integrates with Business Intelligence (BI) applications, custom built applications, and other
applications capable connecting to an OLAP cube such as Microsoft Excel.
The TANDBERG Analytics Extension API is described in a separate document,
TANDBERG Analytics
Extension API Documentation
.
This document, along with the installation guide, release notes, and other documentation can be found
at the Support > Documentation section of
http://www.tandberg.com
.
New feature overview
Analytics Extension version 1.1 is a maintenance release, with additional Analytics Extension cube
features, installer enhancements, and improved logging.
The main improvement to the cube is a new fact table; Fact MCU Utilization. This supersedes the old
Fact MCU Load, which is no longer available. As a result, existing reports that use Fact MCU Load
must be updated to use the new measures. Fact MCU Utilization basically the end user access to the
same data as before, but with improved data quality. In addition, the new fact table contains
aggregated data about MCU usage across the entire installation, and can filter results on arbitrary
MCUs.
Two bracket dimensions have been introduced: Actual Duration Brackets and Actual System Count
Brackets. Both apply to Fact Conference. Actual Duration Brackets shows the mode average (most
common conference durations). Actual System Count breaks down conferences by the number of
participants.
A new Persistent System dimension has been introduced. This dimension is a variant of the System
dimension. Persistent System will always associate historical call data with the current system
information. The Persistent System dimension has the exact same attributes and hierarchies as the
System dimension. This means systems can be renamed without losing associated historical data.
The installer now creates logs automatically, and will expose the version number in the log files. Also,
the installer will catch some common TMS and DWH SQL server configuration mistakes and warn the
user accordingly.
The Microsoft Excel example reports have been updated and use more intuitive descriptions. The ETL
job has been made more robust, and handles TMS database data mismatches that could make the
1.0 ETL job fail.