Page tree
Skip to end of metadata
Go to start of metadata

Use parameters to create dynamic dimensions and measures. Parameters allow you to quickly change among chosen dimensions or measures using the filter pane.

You can use parameters with a worksheet or dashboard. When you share a worksheet or dashboard, the recipient can choose from the parameters you provide to easily visualize the data differently. 

When you use a parameter, a filter is automatically created. Then you can use the filter to dynamically visualize your data.

Each group of parameters is of the same type. If you want both dynamic dimensions and measures, create two different parameter groups.

To create a list of parameters of the same type

  1. From the Toolbox, select Workbooks, then select a workbook.
  2. Click ... to the upper right of the pane and choose Parameters.
  3. Enter a name and optional description for the parameter.
  4. Choose whether it's a dimension or measure.
  5. Click Add from Cube fields and specify the cube if needed.
  6. Navigate to and select a level or attribute value or use Search to quickly find it.
  7. By default, it displays with the same name but you can edit it.
    For example, you can choose the value CustomerName and set the Display as value to Customer Name.
  8. Click the Is Default checkbox to choose the default value.
    This is the value first shown in the workbook or dashboard.
  9. Click Add from Cube fields again to add additional values of the same type.
  10. You can rearrange the order of the values by dragging a value name in the list to a new position using the control next to the checkboxes. 
  11. Click the + button to add more values and the - button to remove a value. 
  12. Click Apply

To add another group of parameters

  1. From the Toolbox, select Workbooks, then select a workbook.
  2. Click ... to the upper right of the pane and choose Parameters.
  3. Click the Plus button at the top of the Parameters list
  4. Enter a name and optional description for the parameter.
  5. Choose whether it's a dimension or measure.
  6. Click Add from Cube fields and add values.
  7. Click Apply.

To edit a list of parameters

  1. From the Toolbox, select Workbooks, then select a workbook.
  2. Click ... to the upper right of the pane and choose Parameters.
  3. Select the parameter group to edit. 
  4. Make changes.
  5. Click Apply.

To add and use parameters in the worksheet

  1. The parameters display in the Dimension and the Measures panels in the design view.
    Drag them to the X or Y axis as you create worksheets.
  2. In the Filter pane, you'll see the parameter name.
  3. Select from the values you created earlier to quickly see different data.

To use parameters in the dashboard

  1. Add a filter card to the dashboard.
  2. Select a parameter list name in the field column.
  3. Select values from the values in the parameter list you created.



  • No labels