Documentation for CXO-Cockpit Reporting Suite 5.0, click for CXO-Cockpit Reporting Suite 4.3 Documentation or check the CXO-Cockpit Website.

Microsoft SQL Server Analysis Services (SSAS)

From CXO Cockpit Reporting Suite Documentation
Jump to: navigation, search

Introduction

SSAS can be used for different purposes, it can be used as a free OLAP source, or it can be used as element in of an Integration Adapter

In case of a free OLAP source the SSAS OLAP connector creates a direct connection to SSAS.The following architecture picture shows the system components:

Architectureimage001.png


MDX

This connector generates internally MDX queries to retrieve the data from Essbase. Read more on MDX trouble shooting here: Turn on MDX Logging to investigate data or performance issues

Connectivity

The connection to SSAS is managed in the System Settings specify the following fields:

OLAP Conenction - SSAS.png 

  • Microsoft Analysis Server: the name or IP address of the SSAS server
  • Database: The name of the SSAS database
  • Cube: The name of the SSAS cube
  • Username & Password: SSAS can only be accessed using windows authentication. For the design studio the windows account of the current logged on user will be used. The website will use the account as specified in the application pool. The services will use the service account.

Use the check button to check if the connection can be made.

Configure CXO-Cockpit to run on SSAS as a free model

In order to successfully run CXO-Cockpit on an SSAS application the following additional configuration is required.

Installation Prerequisites

You can find the Installation Prerequisites file for CXO-Cockpit on SSAS in this article.

See Also

Limit Metadata with MDX Filters