Introduction

The Analysis Services Tabular OLAP connector creates a direct connection to Microsoft Azure Analysis Services by creating a model. The following architecture picture shows the system components:

Image RemovedTabular models are Analysis Services databases that run in-memory or DirectQuery mode, allowing us to:

• Leverage Microsoft Cloud stack of products
• Connect to any data source directly from back-end relational data sources (ex. Excel tables)
• Create data models quickly online through the Azure portal and mapping to CXO dimensions automated.
• Quickly deploy multiple relational data sources and give it Financial structure leveraging CXO.

Image Added

Connectivity

The connection to Azure SSAS is managed in the CXO Source System Manager. Specify the following fields:

• Microsoft Azure Analysis Server: the name or IP address of the Analysis Services server
• Database: The name of the Azure database
• Cube: The name of the Azure SSAS model
• Username & Password: The account which has access to the Analysis Services resource on the Azure Portal.

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

Configure CXO to run on Azure Analysis Services Model

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

• Dimension Mapping: all of the CXO-Core Dimensions need to be mapped
• Set the Period Frequencies table

Installation Prerequisites

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

See Also

Limit Metadata with MDX Filters