Use Filter Variables

Author: Joyce Zhou

Introduction

Filter Variables are useful for when you want to change the definition on a row or column axis dynamically based on the user selected filter. In this article, let's look at how to configure one.

Example

In this example, we can see that the Brand filter selection (i.e., Adair, Harper, and Zofia) are dynamically injected onto the row axis.

A Filter Variable is composed of two parts: the filter and the definition. The filter part is exposed as a regular filter on the Form from which the user can choose, and the definition part defines what to inject along the row or column axis.

In this example, the Brand List hierarchy in the Product dimension is set as Filter Variable and the definition is set to Row.

Now let's take a look at the configuration setup in the ROW tab. Select the Brand List hierarchy, and click Variable.

Filter Variables are marked by the   icon, with their value taking the following form:

${[dimension].[hierarchy]}

Here, let’s select [Product].[Brand List] and click Add.

Then with some formatting, we'll have the Form you see below.