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)
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
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!