Dimension Mapping

Owned by Migration
Last updated: Nov 21, 2014 by Andy Heller (Deactivated)
2 min read

Introduction

For Source Systems that use a direct (no adapter) connection it is required to setup the Dimension Mapping. The Dimension Mapping maps the Standard CXO-Cockpit Dimensions to the OLAP Dimensions of the Source System.

The Dimension Mappings can be opened through the System Settings in the Design Studio. Every source system tab has its own Dimension Mapping button.

CONTENT

Attributes

The Maintain OLAP Dimension Mappings /wiki/spaces/CXO53/pages/19727119 has the following attributes:

Attribute

Description

Dimension Code

The dimension codes represented by a three character acronym representing all supported dimensions by CXO-Cockpit. For a full overview of their meaning read the Dimension article.

Dimension Name in OLAP

This attribute contains the real dimension (and hierarchy) in the OLAP system. If you do not want to map a CXO-Dimension then leave this field empty.

Dimension Alias

The Dimension Alias field allows you to specify a friendly name for every dimension. Especially in case of a dimension + hierarchy, this field allows you to specify business related names instead of technical names.

Alias Location

Alias Location specifies what field or table needs to be used for the Alias/Description in the CXO-Cockpit.

For Microsoft SQL Server Analysis Services (SSAS): Specify which dimension attribute contains the alias.

For Hyperion Essbase: Specify which alias table contains the right alias.

Exclude Top Member From QueriesBy checking this field, the member will not be included in a query when it is the top member. This query optimization is especially useful for attribute dimensions.
Custom Set expresion to retrieve meta dataIf you want to limit the members retrieved from the database, specify an MDX Set Expression to filter out parts of the dimension. Read more about this functionality in Limit Metadata with MDX Filters.