background image

EULA 

TANDBERG Analytics Extension Admin guide 

33 

 

Licensee may not:  

 

modify, adapt, decompile, disassemble, or reverse engineer the Software, except to 
the extent that the foregoing restriction is expressly prohibited by applicable law; 

 

make unauthorized copies of the Software or the Documentation; or 

 

without the prior written consent of TANDBERG, transfer or assign Licensee’s rights 
under this Agreement, including an assignment by operation of law. 

  

Licensee acknowledges and agrees that: 

 

Licensee will include on permitted copies of the Software and Documentation all 
copyright, trademark and other proprietary rights notices included on the originals; 

 

the Software and Documentation may contain valuable proprietary information and 
trade secrets of TANDBERG and its licensors and the Licensee shall protect the 
secrecy of, and avoid disclosure and unauthorized use of, the Software and 
Documentation, using at least those measures that Licensee takes to protect its own 
confidential information, (provided, however, that confidential information does not 
include the Software in object code form or Documentation that TANDBERG 
provides to others without an obligation of confidentiality); 

 

Licensee shall comply with all applicable export control laws and regulations with 
respect to the Software and Documentation; 

 

any violation or threatened violation of this Agreement may cause irreparable injury to 
TANDBERG for which equitable relief may be appropriate, in addition to all legal 
remedies; and 

 

upon violation of any of the provisions of this Agreement or 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 Software and Documentation.  

  

LIMITED WARRANTY.

 Except as may be required by law in the particular country where 

the Product is being used, TANDBERG warrants that, for a period of three (3) months from 
the date of shipment by TANDBERG ("Warranty Period"), the Software will operate 
substantially in accordance with the Documentation. TANDBERG does not warrant that the 
functions of the Software will meet Licensee’s requirements or that operation of the Software 
will be uninterrupted or error free. Licensee must inform TANDBERG in writing during the 
Warranty Period if the Software does not operate as warranted and provide to TANDBERG 
such information and materials as TANDBERG may reasonably request to document and 
reproduce such problem and to verify whether any proposed solution corrects such problem. 
Following the receipt of such information and materials, if TANDBERG determines that the 
Software does not operate as warranted, then TANDBERG will at its election, either: (a) 
modify the Software so that it does operate as warranted; (b) replace the Software with other 
software offering substantially similar functionality; or, (c) if neither (a) nor (b) is 
commercially feasible, refund the amounts paid to TANDBERG for the Software.  

  

EXCLUSIONS.

 TANDBERG will have no responsibility, warranty or other obligations 

whatsoever if Licensee: (a) uses the Software in a manner inconsistent with its intended 
purpose or the Documentation; (b) modifies the Software without TANDBERG’s 
authorization; or (c) causes a failure of the Software through accident, abuse or 
misapplication. 

  

Summary of Contents for ANALYTICS EXTENSION -

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...

Reviews: