[
https://issues.apache.org/jira/browse/OFBIZ-10990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16829207#comment-16829207 ]
Pierre Smits commented on OFBIZ-10990:
--------------------------------------
{noformat}
Later, if required can add 'Hour' as next granular level below Date in it{noformat}
That is not advisable, because it would mean having (at first) to inject the 24 records per date into the table, and later on (when we tend to cater to adopters requirements of having minutes in as well) 1.440 records per date.
The DateDimension, now, would contain 365/366 records per annum, with the addition of the hour that would balloon to 8.760/8.784 records per year. And for the addition of minutes in that table this would even be more staggering: 525.600/527.040 records per annum. Please consider page 83 of The Data Warehouse Toolkit.
> 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
