Dataset Last Refreshed date as "Parameter" in workbook. — Oracle Analytics

Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

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

Dataset Last Refreshed date as "Parameter" in workbook.

Needs Votes
44
Views
1
Comments
Rajakumar Burra
Rajakumar Burra Rank 6 - Analytics Lead
in Oracle Analytics Cloud and Server Idea Lab

There is no good way to display the last refresh date in workbook.

We need to create a Column in Dataset and display.

Instead can we have standard "Parameter" like Current Time, Current Date .

8
Up
8 votes

Needs Votes · Last Updated

Comments

  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    @Rajakumar Burra

    Unlike Current Date/Time, a Refresh timestamp is specific to each dataset entity and only applies to cached entities. The best approach is to have a column based on the relevant data that is being refreshed. The column can be queried from a parameter and displayed (which is what I assume you are already doing).

    We will look into adding the last refresh date into the catalog API, but it might be slower to retrieve than a simple column.