Analytics Extension components and roles
TANDBERG Analytics Extension Admin guide
8
tmsng_dwh
CUBE
tmsng
TMS Web Server
TMS SQL Server
Data Warehouse
Server
TM
S S
QL
Log
in
Analytics User
VCS
OLE
DB
Feedback
Figure 1 Illustration of Roles and Components
Data warehouse server
Analytics Extension comprises two major elements - the data warehouse database, and the data
warehouse CUBE.
Data warehouse database
The data warehouse database is used for analysis and data mining, and contains information from the
TMS database combined with data computations and analysis.
Using credentials specified by the installing user, the data warehouse database is created in a SQL
server instance of the data warehouse server. The default database name is
tmsng_dwh
. The DWH
(data warehouse) service user is defined as the owner of the database, and this service account is
used by the Analytics Extension to log into the database for ongoing operations. Ordinary users of the
Analytics Extension API do not connect to this database.
The data warehouse database accesses the TMS database through a linked server, created on the
data warehouse server during installation. The linked server is created automatically using the TMS
database location and DWH TMS service user credentials supplied during installation. The DWH TMS
service user is an SQL login for the TMS SQL server. This account only needs
db_datareader
role to
access the TMS database, and can reuse any existing login with sufficient SQL access permissions.
Data warehouse CUBE
The data warehouse CUBE is a specialized type of database used in analysis and data mining. Its
main advantage is its ability to hold pre-computed aggregates of data across many different
dimensions, allowing fast manipulation of queries. The data warehouse CUBE holds different data
defined as
„facts‟, each of which has different defined „dimensions‟, which can be used to manipulate
the information stored in the different fact tables. Analytics Extension provides sets of facts and
dimensions that can be used by programmers and analytics users.
The data warehouse CUBE is created during installation in the Analysis Services instance on the data
warehouse server. The default name for the database is
tmsng_dwhAsDb
(its name format must
always be <database>AsDb). The DWH service user is configured as the owner of the CUBE and the
DWH service user credentials are used by Analytics Extension to connect to the cube for ongoing
operations. Ordinary users of the Analytics Extension API connect to this CUBE using an OLAP client
and their Windows Domain accounts (with
reader role
permissions).
Add http pump ref
The data warehouse CUBE connects to the data warehouse database using a data source defined
configured to use the DWH service user credentials.
