Introduction

CXO-Cockpit reads at the begin of a user session all the metadata (Dimension and Members) from the OLAP database of Free Models. Normally this does not cause any significant delay, but sometimes with very large models (dimensions with > 50.000 members) it can take too much time or consume too much memory.

This article describes a feature that allows you to leave out less relevant metadata so the total query time will be reduced. Please note that any members that are excluded cannot be used to build reports or cannot be included into POV selections.

In order to limit the dimension members, you have to specify a valid MDX Set Expression in the Dimension Mapping screen as shown below.

Examples

The examples below are based on the Hyperion Essbase Demo\Basic model. Without filtering the POV selection looks like this:

The default metadata filter for every dimension is empty (unfiltered) and would be the same as the the following MDX Set Expression:

[Market].Members

Exclude a specific branch

If there is one specific branch of a dimension you would like to exclude you can use the following MDX Set Expression:

Except([Market].Members,Descendants([East]))

This example excludes the East branch and the result would look like this:

Exclude leaf members

If you want to exclude all leaf members of a dimension you can use the following MDX Set Expression:

Except([Market].Members,Descendants ([Market], [Market].Levels(0)))

The result would look like this:

Exclude leaf members of a specific branch

If you want to exclude all leaf members of a specific branch (member) you can use the following MDX Set Expression:

Except([Market].Members,Descendants ([East], [Market].Levels(0))) The result would look like this: