Goliath Advanced Reporting and Analytics - Installation

This article was updated to support v 8.x of Goliath Performance Module 

Please note, Goliath Advanced Reporting and Analytics Module is integrated into Goliath Performance Monitor.

Are You Ready to Install?

Before proceeding, please ensure you have the following items available and prepared:

1. Confirm that all applicable Prerequisites have been completed
2. Goliath Advanced Reporting and Analytics  Installation file has been download

What is in the Installation file

• SQL Server Database Script to create/update views (.sql file)
• Microsoft Power BI templates (.pbix files) that Goliath has built for your use.  You can create your own reports, change the reports we supply or request professional services for custom views and reports.
• Goliath Advanced Reporting and Analytics Views (reference guide).  This guide describes the database views that are available. These can be used to create your own custom reports.

Goliath Installation Steps

Step 1: Prepare your Goliath DB

We support SQL Server 2012 or later.
For SQL 2012 you need to set the appropriate compatibility settings. Here's what would need to be done:
• The compatibility level needs to be 110 (SQL 2012) or 120 (SQL 2014).
• Check current compatibility level: EXEC sp_dbcmptlevel 'databasename'
• Update your compatibility level: ALTER DATABASE databasename SET COMPATIBILITY_LEVEL = [required level based on SQL Server version];

Step 2: Next, run the latest Goliath ARAMView##.#.#.!.sql script

The ARAMView script must be run against your production Goliath database not the master when in SQL Server.  If run against master you will get a error "Invalid object name" message: 

Step 3: Using Microsoft Power BI Desktop, update to point to your Goliath Performance Monitoring production database

For details see Advanced Reporting and Analytics Module - Connecting the Database to Power BI 

Connect Goliath standard Power BI templates to Goliath SQL Server and change the data source
To change the data source:
1. Open up a PowerBI template
2. Go to Transform data in the Queries section of the ribbon
3. Select "Data source settings"
4. Select the "Change Source" button
5. Enter the server and database where the view(s) is/are located
6. Enter credentials when prompted
7. Apply changes and/or Refresh

Custom reports or views? 

Goliath will create custom reports and views through professional services.  To inquire please enter a support ticket with your request.