BI Publisher 12c - Interactive View - Adding a Local Time (current timezone) — 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

BI Publisher 12c - Interactive View - Adding a Local Time (current timezone)

Received Response
51
Views
2
Comments
Maraprik
Maraprik Rank 4 - Community Specialist
edited Aug 13, 2024 7:25PM in Oracle Analytics Cloud and Server

Hey Gurus,

Can anyone tell me a way to add the local time with the timestamp on the page header any other place.

I am using interactive view and am not able to add any function ?

If i add it in the query, how should i add it to the interactive view. it requres a data table ?

Please let me know

BIP - 12.2.1.1.0 , Oracle DB 11g.

Regards

Answers

  • ts001
    ts001 Rank 2 - Community Beginner

    Hi,

    You don't need it in SQL, BIP gave us options to add them directly.

    Here are the steps:

    1. Insert Text Item

    2. Double click inside the text item

    3. On top you will have Date & Time option. Add both of them and save it

    Next time when you run the report you should see you report run time.

  • Maraprik
    Maraprik Rank 4 - Community Specialist

    thanks, i am new to BIP. just learnng