Pre-requisite Microsoft components For IT Analytics and Pivot reports

Article:TECH133424  |  Created: 2010-07-07  |  Updated: 2010-07-07  |  Article URL http://www.symantec.com/docs/TECH133424
Article Type
Technical Solution


Issue



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


Environment



All versions of IT Analytics, including

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

Cause



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


Solution



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

http://www.microsoft.com/downloads/details.aspx?FamilyId=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en

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:

http://www.microsoft.com/downloads/details.aspx?familyid=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en

..."


Legacy ID



53673


Article URL http://www.symantec.com/docs/TECH133424


Terms of use for this information are found in Legal Notices