A Filter on a Timestamp Column is not Visible in the Criteria Tab in Answers (Doc ID 2808706.1)

Last updated on SEPTEMBER 23, 2021

Applies to:

Symptoms

After migrating from OBIEE 11g to OBIEE 12c, it was observed that if an Analysis had a filter on a DATETIME column then that filter and any other filters on other column types were not visible in the Filters pane in the Criteria tab when the Analysis was edited in Answers. For example:

1. Edit an affected Analysis and go to the Advanced tab > Analysis XML, and see the Filters are present in the code as below; but go to the Criteria tab, and see the Filters pane will be "empty".

<saw:filter>
<sawx:expr xsi:type="sawx:logical" op="and">
<sawx:expr xsi:type="sawx:comparison" op="between">
<sawx:expr xsi:type="sawx:sqlExpression">"Billing"."Invoice Acctg Date"</sawx:expr>
<sawx:expr xsi:type="xsd:dateTime">2021-01-01T00:00:00</sawx:expr>
<sawx:expr xsi:type="xsd:dateTime">2021-01-30T00:00:00</sawx:expr>
</sawx:expr>
...
</saw:filter>

Or, 2. Create a new Analysis > Add a column with type of DATETIME > Add a Filter on the column with equal, greater, less or between operations > Click OK. See the Filter is not visible in the Filters pane but go to Advanced tab > Analysis XML and see the filter is present in the code.

When the issue is encountered, errors like the following are observed in the web browser's Developer Tools > Console page:

Uncaught TypeError: Cannot read property getUTCOffsetByMinutes of null at SAWDateTime.getResultOffset (datetime.js:1)

Uncaught TypeError: c is null ... getResultOffset .../b_mozilla/common/datetime.js:1

The filters become visible with the following workarounds:

1. Edit the DATETIME column formula to include the CAST function. For example: CAST( <column> AS DATE )

2. Select the "Convert this filter to SQL" option

Cause

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