Filters in PFTBI 5.6 Dashboards Are Not Restricting Data & Reference Old Alias Values (Doc ID 1541004.1)

Last updated on MARCH 29, 2013

Applies to:

Oracle Financial Services Profitability Analytics - Version 5.6 to 5.6 [Release 5]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In the Oracle Financial Services Profitability Management (PFTBI) 5.6 Dashboards, reports that use a filter are not filtering the data.  Instead of correctly showing only the subset of data returned by the filter, all data is displayed.  The filters do not work.

In the reports with this problem, the filters reference a column alias in the Presentation Layer.

Some examples are:

1. Base Currency

It has "- Base Currency".Amount_R/1000 which is listed under "-----------Measures-----------".

"Amount_R" is an Alias in the Presentation Layer.  The actual name is "Amount".

2. Currency

“Currency”.Currency is used in the report.

"Currency" is an alias. The actual name is "Base Currency".


The usage of the alias values appears to cause the filter to fail.

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