Page Comparison

...

• If any parameter is present in the registered dataset but is not sent through REST/JAVA APIs, the default value is used from the file definition.

• In case a semantic model is designed over multiple registered files with each file having the same parameter name, then parameters will get replaced in each registered dataset.

• For the date type columns, provide the parameters in the mm/dd/yyyy format.

• You can see the parameter values with which the process job is executed in the Job Summary.

• You can write the parameter in SQL query syntax.

To create file parameters, perform the following steps.

1. On the Dataset Datasets page, click the three-dots menu, and select the Parameters option. Multiple parameters in the same file cannot have the same name.

2. On the Parameters dialog box, provide information as;

   1. Name: Unique parameter name that will be used while creating the registered datasets. 

   2. Description: Description of the parameter.

   3. Value: Default value of the parameter which will be used if the value for the given parameter is not provided in the semantic model process REST API. This value will be used in other file operations like preview, validation, save, and so on.

      Image Added

      To write the parameter in SQL query syntax.
      For Database name

      Image Added

      For WhereClause

      Image Added

3. Once done, click Apply.

...