1. User’s Guide for Oracle Analytics Desktop
  2. Create and Use Parameters
  3. Create a Parameter that Uses a Logical SQL Query for a Double Column

Create a Parameter that Uses a Logical SQL Query for a Double Column

If your workbook contains a double column, you can create a parameter and provide a Logical SQL to select the display column and the descriptor ID column.

Double columns are available only in datasets created from local subject areas. In a double column, one column represents the data descriptor value and is displayed to the consumer. The second column represents an identifier of the data descriptor and isn't displayed to the consumer.
If you want to use a parameter in a double column type filter, you can create a parameter from and bind it to a filter from the filter's properties. See Create and Bind a Parameter to a Double Column Type Filter.
  1. On the Home page, select the workbook to add a parameter to, click Actions, and then select Open.
  2. In the Data Panel click Parameters.
    Parameters button

  3. In the Parameters Pane, click Add.
    Add parameter button

  4. In the Name field, enter a unique name.
  5. In the Available Values field, select Logical SQL Query.
  6. In the text box, write the Logical SQL, making sure to include the display column and the descriptor ID column. For example,
    SELECT "A - Sample Sales"."Double Column Products"."P10 Product (Dble Column)", DESCRIPTOR_IDOF("A - Sample Sales"."Double Column Products"."P10 Product (Dble Column)") FROM "A - Sample Sales"
  7. Go to the Initial Value field and confirm that either Value or First Available Value is selected.
  8. Click Save.