My Oracle Support Banner

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 NOVEMBER 19, 2018

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

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
Symptoms
Changes
Cause
Solution
References


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