You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BIP report Pivot filter not functioning as expected

Summary:

Running an online layout for a pivot date from a data model doesn't properly filter null dates

Content (please ensure you mask any confidential information):

For the below you can see that the BCSTARTDATE field is filtered for 'IS NOT NULL' - but when I run the report it is not filtering out when this field does not have a date.

The field BCSTARTDATE is a date field in the data model. I have tried even modifying my data model such that nvl(BCSTARTDATE, null) to force a null value if there is some space or something, but the pivot still does not recognize the null for filtering.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!