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.

...

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:

...

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:

...

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  The result would look like this:

...