filtering date in layout editor of bi publisher — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

filtering date in layout editor of bi publisher

Received Response
113
Views
8
Comments
875299
875299 Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

Summary

filtering date in layout editor of bi publisher

Content

Hi All,

I am trying to filter date in a table in layout editor of BI publisher and my filter format for date doesnot work.

please let me know if there is any other way to filter table on a date column.

below is the format i see,i am able to format the date column but not able to filter on date

image

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    One approach:  Convert the column to text in your query first ...

  • 875299
    875299 Rank 4 - Community Specialist

    thanks for the reply.i am building publisher reports using rpd subject area.is there any other way to filter

  • 875299
    875299 Rank 4 - Community Specialist

    i did that but it is not working

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Try filtering after you apply a format ... seems like that isn't done given the picture:

    with the column selected:

    2017-08-16 15_51_18-Oracle BI Publisher.png

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Did you try using a parameter instead of the filter functionality in the table object?

  • 875299
    875299 Rank 4 - Community Specialist

    i have a table and a graph in the report.i just want to filter the table not the graph.

    can i do that using a parameter.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    You have to filter on the full date + timestamp ... played with it a bit ...

    2017-08-22 07_51_53-Oracle BI Publisher.png

    2017-08-22 07_53_44-Oracle BI Publisher.png

  • 875299
    875299 Rank 4 - Community Specialist

    thank you ,it was helpful