This page provides detailed instructions on how to install and configure Altiris IT Analytics™ Solution 6.1.

Topics Include:

• Prerequisites
• Installation
• Licensing
• Configuration

Prerequisites

IT Analytics Solution requires that the following software is installed and configured prior to installation.

Software Platforms

• Altiris Notification Server 6.0 SP3
• Microsoft SQL 2000 or SQL 2005 SP2 Database Engine (for Altiris databases)
• Microsoft SQL Server 2005 SP2 Analysis Services (for IT Analytics Cube database)
  • For more information about proper configuration, see the Microsoft MSDN Web site.
• Microsoft SQL Server 2005 SP2 Reporting Services (for IT Analytics Reports)
  • For more information about proper configuration, see the Microsoft MSDN Web site.
  • We recommend that Internet Explorer Enhanced Security be disabled on the computer hosting Microsoft SQL Server 2005 Reporting Services.
• ADOMD.NET
  • Installed on: Notification Server
  • Filename: ADOMD.NET.msi (installed with default configuration)
  • Version: 8.0
  • Download
• Microsoft Office Web Components 11 (2003)
  • Installed on: All computers that will access the console
  • Filename: owc11.exe (installed with default configuration)
  • Version: 11.0
  • Download

Hardware

The following hardware is recommended in addition to hardware required for Notification Server.

• Single 2.0 GHz CPU
• 1GB RAM

Installation

To install IT Analytics Solution

1. In the Altiris Console, click the Configuration tab.
2. In the left pane, click Upgrade/Install Additional Software.
3. In the right pane, click the Altiris IT Analytics Solution link.
4. Follow the installation wizard instructions.

Licensing

IT Analytics Solution is installed with a 7-day trial license. For an extended trial or to purchase IT Analytics Solution, contact Altiris sales. For more information on registering your solution, see the Altiris Getting Started Guide.

To install licenses

1. From the Altiris Console, click the Configuration tab.
2. In the left pane, click Licensing.
3. In the right pane, click the Install License tab.
4. Install the license.

   If you have license files:

   1. Click the Path to license folder option.
   2. Browse to the folder where the license files are located and click OK.
   3. Click Install License

   If you have license codes in an e-mail:

   1. Click the Paste Content of Licenses below option.
   2. Copy the license codes from the e-mail you received and paste it into the associated field.
   3. Click Install License.

   The licenses are installed. If there is an error, a message will appear at the bottom of the page.

5. Confirm that the licenses installed successfully.
   
   1. Click the License Status tab.
   2. Review the license information for the solutions. The status should display OK.

Configuration

To configure IT Analytics Solution

1. Launch the Altiris 6.0 Console.

2. Navigate to the Configuration tab.

3. Configure Connections Settings.

1. In the left pane, expand Configuration > Solutions Settings > IT Analytics > Configuration and select Connection Settings.
2. In the right pane, select the General tab.
3. In the Analysis Server section, enter the hostname of the SQL2005 Analysis Services server
   
   Note: If you did not install SQL Server as the default "instance," then when specifying the server you need to use the following format: servername\instancename

   ImportantWe recommend using the server name where Analysis Services resides. Using "localhost" will restrict access from the Altiris Console to the computer where Analysis Services resides.

4. Click Verify Connection and confirm that the Analysis Server name has been verified and saved.
5. In the Analysis Server Database section, choose an Analysis Server Database.
   
   NoteFor a new standard configuration, in the Create New Database text field, accept the default to create a new Analysis Server Database named "IT Analytics". If you select an existing database, note that existing data sources will be overwritten with the current Notification Server Database settings.
6. Click Save Database Settings and confirm that Analysis Server Database has been verified and saved.
7. In the Reporting Server section, set the Reporting Server Virtual Directory URL to the full URL of the SQL2005 Reporting Services ReportServer virtual directory.
   
   Note If you did not install SQL Server as the default "instance," then when specifying the virtual directory, it may follow the following format: http://servername/ReportServer$InstanceName/

   Important We recommend using the server name where Reporting Services resides. Using "localhost" will restrict access from the Altiris Console to the computer where Reporting Services resides.

8. Click Verify Connection and confirm that the Reporting Server name has been verified and saved.
9. In the Create New Report Folder text field, accept the default to create a new Report Folder named "IT Analytics". If you select an existing folder, note that existing data sources will be overwritten with the current Analysis Server Database settings.
10. Click Save Folder Settings and confirm that the Report Folder name has been verified and saved.
11. (Optional) Click the Optional Settings tab and verify that the Report Integration URLs contain the correct Altiris server name. If necessary, changes can be made by clicking Edit URLs.

4. Configure the cubes.

1. In the left pane, expand Configuration > Solutions Settings > IT Analytics > Configuration and select Cube Setup.
2. In the Cube Setup window, click the Available Cubes tab.
3. Select the check box for each cube to be installed.>
4. Click Apply.
5. Click OK at the prompt to proceed with cube installation.
6. Verify that the cubes were successfully created by clicking the Installed Cubes tab and viewing the installed cubes.

5. Configure the reports.

1. In the left pane, expand Configuration > Solutions Settings > IT Analytics > Configuration and select Report Setup.
2. In the Report Setup window, click the Available Reports tab.
3. Select the check box for each report to be installed.
4. Click Apply.
5. Click OK at the prompt to proceed with report installation.
6. Verify that the reports were successfully installed by clicking the Installed Reports tab and reviewing the listed reports.

6. Configure the Cube Processing tasks.

1. In the left pane, expand Configuration > Solutions Settings > IT Analytics > Processing and select Processing Settings
   
   NoteThis page lets you create and assign processing schedules for all installed cubes. Business needs will dictate how often the cubes should be processed. For the purposes of a typical configuration, all cubes should be processed daily.

   If multiple processing tasks are utilized for more granular control of cube processing, note that when a dimension shared by more than one cube is processed, the last processed date of all cubes that utilize that dimension will be updated to the last processed date of the shared dimensions. However, the actual fact data in the cubes will not be processed until a processing task is run that is configured to process that specific cube.

2. Select the desired schedule for the default processing task and select theEnable Schedule check box.
3. Select the check box for each available cube you want to be processed on this schedule. For a typical configuration, choose all cubes.
4. Click Save and confirm that the Default Processing Task is saved.
5. After the Default Processing Task has been saved, click Run Now.

   This starts the selected Processing Task asynchronously, meaning that the task will not have finished by the time the page refreshes. This task can take several minutes to execute, depending upon the number of cubes selected and the size of data within the Altiris database, but can be monitored by viewing the events in the popup window while the manual processing task executes. This task is essential for the solution to function. The cubes will not have any data until processing has completed.

7. (Optional) Set the Report Header color.

1. Open Windows Explorer on the server where SQL2005 Reporting Services is installed.
2. Navigate to the Report Server directory for SQL2005 Reporting Services. Example: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
3. Open the file named rsreportserver.config with a text editor (Example: Notepad). Add the following code string at the end of the file before the closing tag ("</ Configuration>").
   

   <HTMLViewerStyleSheet>HtmlViewer</HTMLViewerStyleSheet>
   
   

4. Save and close the rsreportserver.config file.
5. In Windows Explorer, browse to the Styles folder of SQL2005 Reporting Services. Example: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\Styles\
6. Open the file named HtmlViewer.css with a text editor (Example: Notepad).
7. Find the following section of code:
   

   MenuBarBkGnd
   {
   Background-color: #ECE9D8
   }
   
   

8. Change the background color from "#ECE9D8" to "EEEEEE".
   
   Note"EEEEEE" is the background color used by default in the Altiris Console.
9. Save and close the HtmlViewer.css file.

8.Verify Installation.

1. Navigate to the IT Analytics tab in the Altiris 6.0 Console.
2. The left pane should include the following items:
   • Dashboards
   • Pivot Tables
3. Reports

IT Analytics Solution, Part 1: Introduction

IT Analytics Solution, Part 3: Working with Pivot Tables