TANDBERG ANALYTICS EXTENSION -, Administrator'S Manual

Page 1: ...TANDBERG Analytics Extension Administrator guide D14668 01 September 2010...

Page 2: ...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 Reco...

Page 3: ...tion mode 24 Setting msmdpump dll as the default document 24 Setting the target Analysis Services server 25 Creating a domain service account and giving it read access to the cube 25 Verifying that th...

Page 4: ...Introduction TANDBERG Analytics Extension Admin guide 4 Document Revision History Rev 02 August 2010 Release of version 1 1 Rev 01 May 2010 Release of the Analysis Extension 1 0...

Page 5: ...w 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 t...

Page 6: ...rs TANDBERG TMS TANDBERG Analytics Platform Analytics Extension makes the best use of Microsoft s powerful SQL Server Analysis Services to provide business knowledge and customized reporting on your T...

Page 7: ...ion Data Warehouse Server The Microsoft SQL Server that will be hosting the Analytics Databases and SQL Server Analysis Services This server can be the same SQL server as the TMS SQL Server but is rec...

Page 8: ...llation 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 acces...

Page 9: ...nalytics Extension web interface in TMS The CUBE refresh is performed daily after the data warehouse database has been updated by the ETL task To initiate this update the Analytics Extension Windows S...

Page 10: ...data warehouse CUBE hosted by the SQL Server Analysis Service SSAS An account with SSAS access does not necessarily have the right to read the data warehouse CUBE SSAS offers administrators a wide va...

Page 11: ...pages of TMS located at Administrative Tools User Administration Analysis services server administrators Access to the data warehouse CUBE and data exposed by the Analytics Extension is controlled via...

Page 12: ...ord dialog when accessing the Analytics Extension Figure 2 The Analytics Extension web interface Download excel sample files Sample Excel workbooks are included with Analytics Extension See the TANDBE...

Page 13: ...g the job has been running for or how long the job took to complete Batch Errors If a job fails diagnostic information is listed here Click on the entry to expand the box and see more information Run...

Page 14: ...ges If you need to change which servers host the TMS or data warehouse databases those changes must be made by the SQL Administrator manually and then use the reconfigure wizard to update your softwar...

Page 15: ...age asks you to look in the logs for further information The most common cause is SQL connectivity problems Look for an SQL Network Interfaces Error Locating Server Instance Specified message in log A...

Page 16: ...e original TMS database Figure 5 Multiple Error Internal error The operation terminated unsuccessfully messages from the same failed ETL job Client Connectivity Issues Microsoft Excel and Windows Auth...

Page 17: ...AsDb Data Source analytics reporting tms lab MDX Compatibility 1 Safety Options 2 MDX Missing Member Mode Error password ENGLAND66 Checking the Save password box will make the changes to the connectio...

Page 18: ...a SSAS project 1 Right click the connection in the Select Data Source window and select Open with Notepad Figure 7 to edit the connection file as described in the Microsoft Connect page 2 Locate the...

Page 19: ...Troubleshooting TANDBERG Analytics Extension Admin guide 19 Figure 8 Appending the connection string...

Page 20: ...are low level and intended for debugging purposes by TANDBERG personal Database Logs The data warehouse itself also keeps logs useful for troubleshooting these entries are stored in the database itse...

Page 21: ...entioned on the Roles Summary pane If IIS is not already installed click Add Roles and follow the installation wizard IIS needs the ISAPI Extensions role service installed as well as an Authentication...

Page 22: ...e Physical path field to the location of the pump binaries for example C inetpub wwwroot analytics pump see above 4 Click OK to close the Add Application dialog Figure 10 Setting up handler mappings 1...

Page 23: ...example Analytics pump 9 Click OK You are now asked if you want to allow this ISAPI extension Click Yes Figure 11 Name extension 1 Go to the Internet Information Services IIS Manager tree view and sel...

Page 24: ...e 2 Right click Basic Authentication and click Enable 3 Right click Basic Authentication and click Edit 4 An Edit Basic Authentication Settings window opens Figure 14 Enter the Windows domain of the d...

Page 25: ...Analytics Extension Installation guide for instructions on adding accounts to this role This account will be used by all clients that access the HTTP pump TANDBERG recommends setting up this account...

Page 26: ...TP access to the CUBE TANDBERG Analytics Extension Admin guide 26 When the connection has been created it can be used in pivot tables and pivot charts just like any other connection to Analysis Servic...

Page 27: ...nts and websites referenced in this document All TANDBERG documentation can be found on the TANDBERG website For advice from the technical support team on all TANDBERG products see the TANDBERG Knowle...

Page 28: ...Microsoft End User License Agreement Software released under the Microsoft End User License Agreement MICROSOFT SQL SERVER 2008 ADOMD NET MICROSOFT SOFTWARE LICENSE TERMS MICROSOFT SQL SERVER 2008 ADO...

Page 29: ...lter any copyright trademark or patent notice in the Distributable Code use Microsoft s trademarks in your programs names or in a way that suggests your programs come from or are endorsed by Microsoft...

Page 30: ...erpretation of this agreement and applies to claims for breach of it regardless of conflict of laws principles The laws of the state where you live govern all other claims including claims under state...

Page 31: ...also applies even if Microsoft knew or should have known about the possibility of the damages The above limitation or exclusion may not apply to you because your country may not allow the exclusion or...

Page 32: ...FOR A FULL REFUND LICENSE TANDBERG or its licensors owns all intellectual property rights including patent copyright trade secret trademark and other proprietary rights in and to the Software and Doc...

Page 33: ...the expiration of the term of this License Licensee s rights to use the Software and Documentation shall automatically terminate and Licensee shall return to TANDBERG or destroy all copies of the Soft...

Page 34: ...TICULAR SOFTWARE GIVING RISE TO THE CAUSE OF ACTION THE DISCLAIMERS AND LIMITATIONS OF LIABILITY ABOVE WILL NOT BE AFFECTED IF ANY REMEDY PROVIDED HEREIN FAILS OF ITS ESSENTIAL PURPOSE GENERAL PROVISI...

Page 35: ...ion are commercial items as defined in FAR 2 101 consisting of commercial computer software and commercial computer software documentation as used in FAR 12 212 and 48 C F R 227 7202 and the correspon...

Page 36: ...VE NAMED SUPPLIERS DISCLAIM ALL WARRANTIES EXPRESSED OR IMPLIED INCLUDING WITHOUT LIMITATION THOSE OF MERCHANTABILITY FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT OR ARISING FROM A COURSE OF D...