Pierre Smits commented on OFBIZ-10998:

Patch available via https://github.com/apache/ofbiz-plugins/pull/11 See 

> 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

Reply via email to