Datetime / Timestamp type cube
Nicolas CHIGROS
Active Partner
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.
17
Comments
-
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.1
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 159 Academy
- 325 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 192 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 337 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP