We can’t retrieve the data from data set Flexera Data Models

[#1]

Symptoms:

This KB article describes the error “We can’t retrieve the data from data set Flexera Data Models” when a user tries to access Cognos Analytics. The Cognos Analytics dashboards display the above message and do not load.

Solution:

The error message is displayed due to an incorrect configuration of data source connections details on Cognos. One needs to follow the steps below as the Analytics Administrator (with Business Reporting Portal Admin account) to check the configuration issue:

- Access the FNMS webui using the account that has the Business Reporting Portal Admin role.

-Navigate to Reports>Analytics to access Analytics UI.

- Click on the Manage icon 'click mark icon' around the bottom left side of the navigation bar.

-Then navigate to Administration Console>Configuration>Data Source Connections.

-Notice the three FNMP groups named below:

FNMP-Dashboard

FNMP-DW-DS

FNMP-DW-DS-DQM

-Click on each one of the above three groups and then click on the ‘More’ link under Actions on the right side of the page.

-Then navigate to Set Properties>Connection.

-Next to the ‘Connection String’ field, click on the pencil icon ‘Edit the connection string’.

- Check both the ‘Native’ and ‘JDBC’ tabs. Ensure connection information, such as Server name, database name and port number, are correct.  Also ensure the port number is specified correctly in the ‘Port number’ field.

-Also for both Native and JDBC connections, one can do test connection by clicking ‘Test the connection’ link.

-The FNMP-Dashboard-Group connection string should point to the Compliance database and the rest of the other two should point to the DataWarehouse database.