Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

  1. Create a custom dataset using SQL. For more information, see Create a Custom SQL Dataset above.
  2. In the Create Dataset with SQL window, enter a SELECT* statement to retrieve data from the specified table. Click Validate SQL to verify that the query is properly specified. 
  3. Now, highlight the part of the query that you wish to parameterize. Click the Variable icon. 

    D caption
    Define Variable Parameter
  4. In the Variable dialog, enter the following details:

    Tip

    Tip: Type env. to see the environment parameters that can be applied. These parameters are available for use by each user in the environment. For more information, see Overview of Parameterization.

    1. Name: Enter a display name for the variable.

    2. Default value : Enter a default value for the parameter.
  5. Click Save  to save the parameter.

  6. To verify that your SQL is still valid, click  Validate SQL .

  7. If the SQL is valid, click Create Dataset.

...