My Oracle Support Banner

OBIEE 12c: How To Enable Select By Code Column By Default For A Dashboard Prompt On A Double Column (Doc ID 2523411.1)

Last updated on JANUARY 15, 2021

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Information in this document applies to any platform.


On OBIEE 12c

In the RPD, a Descriptor ID column is specified for a logical column to enable double column support.  For reference, see:

    Enabling Double Column Support by Assigning a Descriptor ID Column

    Understanding the Double Column Feature

When the Display column is included in a Dashboard Prompt, options are available to allow the user to search and select by the Code column.  In the Column Prompt properties > More tab, see options:-

[x] Filter by Code Column
[x] Show Code
[x] Enable user to select by Code Column
If the user wishes to search and select the column prompt values by the Code column, he has to first manually check on the Select by <Code Column> checkbox.

This document gives two options for allowing this same functionality without requiring the user to first manually check on the Select by <Code Column> checkbox.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.