My Oracle Support Banner

OBIEE 11g: Column Prompt that has Descriptor ID returns Unexpected Value (Doc ID 2178506.1)

Last updated on APRIL 09, 2018

Applies to:

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


Column Prompt that has Descriptor ID returns Unexpected Value.  You can reproduce the issue with the following steps:

1. Open the repository and navigate to the Business Models and Mapping.

2. Click the logical column (ex. Department Name) properties and set "Descriptor ID Column"(ex. Department Code).
    This logical column is related to the Logical Dimension (Hierarchy).
    "Descriptor ID Column" is set on the same level of logical Dimension as logical column. 

  Example of Logical Dimension Hierarchy:

    Logical Dimension Level 1
     - Organization Name
     - Organization Code

      Logical Dimension Level 2
      - Department Name
      - Department Code 

3. Go to the Analytics and create a dashboard prompt for the above: Organization Name and Department Name.

   Create a "Organization Name" dashboard prompt, and add column prompt for "Department Name" and limited values by "Organization Name".

4. Paste the dashboard prompt on the dashboard page and select Organization Name.  
Next go to the Department Name.  The list of value is limited by Organization Name, which is correct.

5. Press "Apply."  The value for Department Name has changed to another value that is not belong to the Organization Name.



Set the "Descriptor ID column" for the logical column. 


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.