Introduction
TANDBERG Analytics Extension Admin guide 2
Contents
Contents............................................................................................................................... 2
Document Revision History ................................................................................................ 4
Introduction ......................................................................................................................... 5
New feature overview .............................................................................................................................. 5
Technical overview ............................................................................................................. 6
Analytics Extension components and roles ...................................................................... 7
Data warehouse server ........................................................................................................................... 8
Data warehouse database ............................................................................................................... 8
Data warehouse CUBE .................................................................................................................... 8
Data warehouse updates ................................................................................................................. 9
Service account permissions and uses ................................................................................................... 9
Data warehouse service user ........................................................................................................... 9
DWH TMS service user .................................................................................................................... 9
Adding and managing users .............................................................................................10
Analytics users ...................................................................................................................................... 10
Administrator roles ................................................................................................................................. 11
Analytics extension administrators ................................................................................................. 11
Analysis services server administrators ......................................................................................... 11
Web interface ......................................................................................................................12
Download excel sample files .......................................................................................................... 12
Log ETL jobs .................................................................................................................................. 12
Reconfiguring Analytics Extension ..................................................................................14
Troubleshooting .................................................................................................................15
Web site issues ..................................................................................................................................... 15
ETL job failures .............................................................................................................................. 15
Client Connectivity Issues ..................................................................................................................... 16
Microsoft Excel and Windows Authentication ................................................................................ 16
The LocaleIdentifier property.......................................................................................................... 17
Logs ....................................................................................................................................20
Application Logs ............................................................................................................................. 20
Database Logs ............................................................................................................................... 20
Setting up HTTP access to the CUBE ...............................................................................21
Installing IIS .................................................................................................................................... 21
Copying the pump binaries ............................................................................................................. 21
Creating an IIS application pool ..................................................................................................... 21
Setting up handler mappings.......................................................................................................... 22
Name extension ............................................................................................................................. 23