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-10990) Improve the SalesInvoiceItemStarSchema
Date Mon, 29 Apr 2019 07:05:00 GMT

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

Pierre Smits commented on OFBIZ-10990:
--------------------------------------

Regarding the other points:
{noformat}
Product Dimesion - Can help in getting the Brand, Style, Assortments, Component level info
for different views.{noformat}
For sure we can add more dimensions (like the ones suggested). The thing to keep in mind
here is whether a product can be sold under different brands, styles, etc) or not. I don't
think we can dictate one approach here, but we have to start somewhere. And - as always -
our adopters can (and will) extend entity-packages and individual entities as they see fit. 


{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.
{noformat}
Supplier Dimension - can help in getting Supplier, Vendors or any other product sourcing agency
info for different views.{noformat}
Yes, I will add a new ticket for this.

Please keep in mind that the term 'vendor' is ambiguous as it can be used in both the purchase
and the sales domain. I tend to not use that discriminator.

> 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)

Mime
View raw message