Parameters

1. Overview

This document provides an outline for configuring the Centrify 360 to cater for parameters in the target Power BI model.
Centrify 360 supports adding parameters in the target star schema model, allowing the user to define parameters in both types:

  • Fields Parameter: A list of fields to be used in a slicer for dynamics views

  • Numeric Range Parameter: A numeric range to be used in a slicer

Refer to https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if for more info about data model parameters.

2. Configuration Steps

  • Navigate to Centrify 360 Setup page and press on Setup Parameters button

Centrify 360 Setup

  • Check the screenshot below for an example of both types of parameters

Centrify 360 Setup Parameter

2.1. Fields Parameter

  • Configure the parameter name as desired

  • Add comma separated list of fields/measures or use the add from measures button as shown in the screenshot below to select from the predefined measures page.

Add From Measures

2.2. Numeric Range

  • Configure the parameter name as desired

  • Configure the range limits (Minimum, Maximum, Default Value, Increment) as desired.

2.3. Next Steps

A change in parameters doesn’t require a redeploy of the configuration, but it does require the Power BI semantic model to be updated.
If you publish manually, update the semantic model manually in Power BI Desktop as described in Basic Configuration.
If you use Integrated Publish & Update, run the Update Semantic Model action so the new parameters become available.