OBIEE 12c: Issue In Hidden Prompt Values Passed To NQQuery (Doc ID 2256239.1)

Last updated on MAY 25, 2017

Applies to:

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

Symptoms

The hidden prompt values are not get assigned,  when you change report prompts values accordingly. Instead default value always used.

This happens to cascading dependent prompt, if it's immediate dependent prompt, it will be ok

For example, Hidden prompt B depend on prompt A, then B will be OK, but if there is another hidden prompt C depend on B, then C will always use default value.

Below is the issue example created from Sample Sales:

a)
Prompt Name:  Prompt 
includes: Fiscal Month

SELECT "A - Sample Sales"."Alternate Calendars"."T42 Fscl Month" as MONTH

when user selects a value (for example: Fscl - 12) for Fiscal Month on dashboard it populates presentation variable: g_Fscl_Month_PV

So after this step: 

 
After this step Prior1_Month should be 507

But instead of 507, Prior1_Month is returning 464 .. which is the default value of g_Julian_Num always

 

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