OBIEE 11g Double Column (Descriptor Id) Unable To Be Used In Filters Or Prompts But The Column Is Visible In Analtyics (Doc ID 1998252.1)

Last updated on AUGUST 09, 2016

Applies to:

Business Intelligence Interactive Dashboard - Version 11.1.1.7.141014 and later
Information in this document applies to any platform.

Symptoms

After assigning ID column for descriptive column,
1) unable to use double column feature in filters to
- display both code values and the display values ('Select by Code Column' option)
- specify if the column is to be filtered by code values or display values ('Filter by Code Column')
2) unable to use 'Select by Code Column' option in prompts



Changes

Included Code Column and Enable user to 'select by Code Column' feature is not available in analytics while creating dashboard prompt.
However they are able to use descriptor column which suggest everything is fine from rpd side.
Need to check why those check boxes are not there and why a double column is behaving as a regular column.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms