Pre-requisite Microsoft components For IT Analytics and Pivot reports

Article:TECH133424  |  Created: 2010-07-07  |  Updated: 2010-07-07  |  Article URL
Article Type
Technical Solution


You are unable to view IT Analytics or pivot reports in Altiris.


All versions of IT Analytics, including

  • IT Analytics 6.x
  • IT Analytics 7.x


The required Microsoft omponents needed to work with SQL Cubes have not been installed on the Server and/or the Client.


The following was copied from page 42 of the ITA v7 SP2 User Guide : Please refer to this document if additional information is needed.

"... You must install the Microsoft OfficeWebComponents to work with an interactive pivot table in your browser. If the freely available components are installed and you don't have Microsoft Office already installed, you can view the components with reduced functionalities.

For instructions on how to download and install the Office Web Components, see

You must also install Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB
Provider for the OfficeWebComponents. TheDBProvider is a standard component that is bundled with Microsoft products such as Office 2007 and SQL Server 2005 Management Studio. It is also available from the Microsoft Web site.

For instructions on how to download and install the OLE DB Provider, see:


Legacy ID


Article URL

Terms of use for this information are found in Legal Notices