Add timestamp to all date related dimensions in analytics
Some areas in analytics only have date stamps instead of date+time stamps, so reporting on for example, Events from analytics will only ever bring back the date the event occurred and not the date+time required for auditing.
We'd like all dimension datestamps to have a version of the timestamp which includes the date+time so that they are useful in working out when a transaction occurred and not just the date it happened. This is good for consistency across analytics data as well.
This idea may now closed.
This idea was originally entered in 2015.
Since 2015 we have made clear distinctions between the “date” which includes the date and time and the “date” which is only the date.
The “date” which is only the date ends with suffix “(Calendar)”.
For example, in the E-Inventory subject area the folder “Portfolio PO Line” includes both a field “Claiming Date” and a field “Claiming Date (Calendar)”
Additionally, in the new “System Events” subject area “Event Date” folder includes two fields: “Event Date” and “Event Date and Time”.
Thank you.
-
Chris Jones commented
The benefits of this extend beyond internal audit - certainly there are important date fields, e.g. for Requests where the time is not currently available through analytics but where it would be potentially valuable to analyse user behaviour to tailor staff resource to the periods of greatest demand for example. Could this also be achieved just by adding <operation> time as an additional field to the <operation> ID table concerned? e.g. somewhat like Fulfillment/Loan and Return times?