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.
