Use Filter Variables

Author: Joyce Zhou

Introduction

Filter Variables are useful 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 a Filter Variable.

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 definition. The Filter is exposed as a regular filter on the Form, and the definition defines what to inject along the row or column axis.

In this example, the Brands hierarchy is set as a 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]}

Select [Product].[Brands] and click Add.

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