[
https://issues.apache.org/jira/browse/OFBIZ-10998?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pierre Smits updated OFBIZ-10998:
---------------------------------
Attachment: (was: OFBIZ-10998.patch)
> Have a Time dimension
> ---------------------
>
> Key: OFBIZ-10998
> URL: https://issues.apache.org/jira/browse/OFBIZ-10998
> Project: OFBiz
> Issue Type: Sub-task
> Components: bi
> Affects Versions: Release Branch 18.12, Release Branch 17.12, Trunk
> Reporter: Pierre Smits
> Assignee: Pierre Smits
> Priority: Major
> Labels: TimeDimension, birt, dimension, dwh, time
>
> The component would benefit from a time dimension for future fact tables and
> star schema view entities.
> Per comments in OFBIZ-10990:
> As for time. yes we can add a static time dimension having are all time
> increments between 00:00:00 and 23:59:59. If only using the minute
> discriminator this would be a table consisting of 1440 records.
> Businesses are not that much interested in sales/purchases/etc. per second,
> whereas IT more often is (transactions per second), but at least the time
> dimension will allow doing that in fact tables and star schemas. Businesses
> are interested in stuff like: how do our sales in the morning compare to
> sales in the afternoon, and how do our morning sales trend over time....
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
