The Analyzer returns either no results or data from a different ICA environment

Products

• Information Centric Analytics

Issue/Introduction

The RiskFabric Processing job is enabled and running successfully but data in the Information Centric Analytics (ICA) Analyzer are missing or return values referencing a different environment (e.g., linked servers used in a UAT environment but not in production).

Environment

Release : 6.5.x

Component : Microsoft SQL Server Analysis Services

Cause

The data source properties for the RiskFabric cube do not point to the correct SQL Server hosting the RiskFabric database. This can be caused by a change to the settings Analysis Services Server and Analysis Services Database in the ICA console under Admin > Settings > General > Advanced Settings, or directly changed on the Analysis Services server.

Resolution

To correct the data source used by the RiskFabric cube when the Analysis Services Server and Analysis Services Database settings are properly configured in ICA, follow this procedure:

1. Using SQL Server Management Studio (SSMS), connect to the Analysis Services server hosting the RiskFabric cube
2. In Object Explorer, navigate to Databases > RiskFabric > Data Sources
3. Right-click RiskFabric and select Properties
4. In the Data Source Properties window, edit the Connection String
5. In the Connection Manager, edit the Server name to point to the correct SQL Server and instance hosting the RiskFabric database
6. Under Connect to a database in the drop-down selection labelled Select or enter a database name, select RiskFabric
7. Click the OK button to close the Connection Manager window
8. Click the OK button to close the Data Source Properties window