[jira] [Commented] (OFBIZ-10990) Improve the SalesInvoiceItemStarSchema

[Nicolas Malin (Jira)]

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

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

 
{code:java}
I think we usually model and identify the styles and assortment through virtual/variant pairing via ProductAssoc https://demo-trunk.ofbiz.apache.org/webtools/control/FindGeneric?entityName=ProductAssoc (where productAssocTypeId='PRODUCT_VARIANT'). Here the virtual product could contain the styles and all the variants (based on their standard features i.e. Size/Color/Taste/Material etc.) as assortment. e.g, 
https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductAssoc?productId=SAUCE
https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductAssoc?productId=GZ-1006
{code}
Variants of a virtual is already catered for in the ProductDimension entity, as they have their own natural key (productId). The steps to reproduce in demo-trunk:
 # initialise the DWH in the bi component;
 # see the result in [https://demo-trunk.ofbiz.apache.org/webtools/control/FindGeneric?entityName=ProductDimension]

As for adding feature fields (and equivalents) to the ProductDimension entity: I suggest to read up on [1] and the various differentiators (GITN, UPC, EAN, etc.). This would require a complete redesign of the entity. It is then better to have a SkuDimension to cater for this.

[1] [https://en.wikipedia.org/wiki/Stock_keeping_unit]

 

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