Datetime / Timestamp type cube

Options
Nicolas CHIGROS
Nicolas CHIGROS Active Partner
April Badge of the Month First Anniversary Level 200: Leveraging Board for Business Insights Level 100: Foundations of Building in Board
edited February 2023 in Idea Exchange

My idea

Add a new type of cube : Datetime that store date and the time!

Basically, it's the same as type date but support n decimal places to handle times like in Excel.


Use case (exemple) :

In my current project, users need to view the exact time when a task in the workflow has been completed and/or when a coworker has performed an operation for the last time :

Workaround(s) :

To do so we created an entity with all the task & process and based a text cube on it. The goal is to fill the right cell of this cube with a dataflow when the "completed task" procedure is run. We had 2 options :
  • Set the value to the @datetime variable in the dataflow. But it's culture-sensitive, so it doesn't display natively to everyone if language isn't the same for everybody.

  • Use a ROLAP cube on a view like "SELECT sysdate from dual" to get current datetime relaiably and overwrite the value in a text cube.
the result easily.
16
Up
16 votes

Accepted · Last Updated

Comments

  • Monisha Jain
    Monisha Jain Employee
    Level 100: Foundations of Building in Board 5 Likes Name Dropper First Comment
    Options

    Hi Nicolas, thank you for sharing your idea! We have accepted this Idea to be part of our backlog and we are evaluating the feasibility of adding it to the development roadmap. 
     
    We are committed to delivering the best possible experience to our customers, and we must prioritize the features and enhancements that will have the most significant impact on your daily use of our software. 

Categories