My Oracle Support Banner

ALM BI Report 'Process' Drop Down Does Not Show All Expected Values (Doc ID 2423826.1)

Last updated on AUGUST 16, 2018

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Business Intelligence Enterprise Edition (OBIEE)
Oracle Financial Services Asset Liability Management Analytics (ALMBI)
ALM BI
Reporting

Symptoms

On ALMBI 8.0.5 for ALM HOME process prompt fact table FCT_AGG_BASE_CCY_LR_GAP is being used and joined with DIM_FCST_RATES_SCENARIO on N_PROC_SCEN_SKEY = N_PROC_SCEN_SKEY

Prompt Query :

select distinct T96.V_PROCESS_NAME as c1
from
  DIM_FCST_RATES_SCENARIO T96 /* Dim Scenario */ ,
  FCT_AGG_BASE_CCY_LR_GAP T470 /* Fact Liqudity Risk Base */
where ( T96.N_PROC_SCEN_SKEY = T470.N_PROC_SCEN_SKEY )

 

This query is not fetching the expected results here fact table FCT_AGG_BASE_CCY_LR_GAP is joined.

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!


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