Datetime / Timestamp type cube

Nicolas CHIGROS
Nicolas CHIGROS Active Partner
Fourth Anniversary 250 Up Votes 25 Likes 10 Comments
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.
18
Up
18 votes

Accepted · Last Updated

Comments

  • Monisha Jain
    Monisha Jain Employee
    10 Comments Level 100: Foundations of Building in Board 5 Likes Name Dropper

    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