[
https://issues.apache.org/jira/browse/OFBIZ-10990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16829184#comment-16829184 ]
Swapnil Shah commented on OFBIZ-10990:
--------------------------------------
{quote}
{noformat}
Time Dimension - can help in getting financial/merchandising calendars with Years, Season, quarters, weeks , days etc. for different views. {noformat}
We already have a date dimension catering for year, week, days. This dimension can, of course, be extended with missing elements (like season, trimesters, etc.)
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....
I will add a new ticket for this.
{quote}
If we already have Date Dimension then i guess no need to add new Time Dimension (if needed this itself can be relablled as Time Dimension). Later, if required can add 'Hour' as next granular level below Date in it.
> Improve the SalesInvoiceItemStarSchema
> --------------------------------------
>
> Key: OFBIZ-10990
> URL:
https://issues.apache.org/jira/browse/OFBIZ-10990> Project: OFBiz
> Issue Type: Improvement
> Components: bi
> Affects Versions: Trunk, Release Branch 17.12, Release Branch 18.12
> Reporter: Pierre Smits
> Priority: Major
> Labels: birt, dwh
>
> The star schema should be improved to include elements from:
> * Customer dimension
> * Country dimension
> * Store dimension
> * Catalog dimension
> * Channel dimension
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
Locked
