LRM BI Reports ->Funding Concentration Reports Significant Currency Filter is fetching only two currencies (Doc ID 2609489.1)

Last updated on NOVEMBER 14, 2019

Applies to:

Goal

To provide resolution on data resulting only two currencies in Funding Concentration Reports in Significant Currency filter, using Outflow Amount Reporting Currency/Local Currency from Aggregate Cash Flow Facts table,

1. If OOB report can use the Inflow Amount Reporting Currency/Local currency to get the better significant currency filter values.

(case when ASCII('@{Currency}{Reporting Currency}') =ASCII('Reporting
Currency') then "Aggregate Cash Flow Facts"."Outflow Amount Reporting
Currency"/SUM("Aggregate Cash Flow Facts"."Outflow Amount Reporting
Currency") else "Aggregate Cash Flow Facts"."Outflow Amount Local
Currency"/SUM("Aggregate Cash Flow Facts"."Outflow Amount Local Currency")
end)>0.05

2. Remove the condition here 0.05(5%) from funding concentration reports.
 

Solution

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