Create a Parameter with the SQL Expression Data Type

For a parameter that uses the SQL expression data type, you must type or paste a Logical SQL expression into the Value field to specify the column value that you want the parameter to use.

  1. On the Home page, select the workbook to add a parameter to, click the Actions menu, and then select Open.
  2. To find and copy the Logical SQL for the column that you want to specify as a parameter value, in the workbook drag and drop the column to a canvas.
  3. Click Menu on the workbook toolbar and select Developer.
  4. In the Developer pane, click Performance Tools and then click Logical SQL.
  5. Locate and copy the Logical SQL for the column that you want to use as a value in the parameter.
  6. In the Workbook editor, go to the Data Panel click Parameters.
  7. In the Parameters Pane, click Add.
  8. In the Name field, enter a unique name.
  9. Click Data Type and select SQL Expression.
  10. In the Possible Value Type field select Value.
  11. In the Initial Value field, select Value.
  12. In the Value text box, paste the column's logical expression.
  13. Click OK.
  14. Click Save.