ofbiz-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pierre Smits (Jira)" <j...@apache.org>
Subject [jira] [Commented] (OFBIZ-10998) Have a Time dimension
Date Wed, 18 Mar 2020 09:44:00 GMT

    [ https://issues.apache.org/jira/browse/OFBIZ-10998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17061554#comment-17061554

Pierre Smits commented on OFBIZ-10998:

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

> 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

View raw message