[
https://issues.apache.org/jira/browse/OFBIZ-10990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16829196#comment-16829196
]
Swapnil Shah edited comment on OFBIZ-10990 at 4/29/19 12:19 PM:
----------------------------------------------------------------
{quote}..But where should the style and assortment come from? Can you reference
entities from [https://demo-trunk.ofbiz.apache.org/webtools/control/entityref]
? That will give a clue regarding determining what is achievable.
{quote}
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]
was (Author: swash78):
{quote}
..But where should the style and assortment come from? Can you reference
entities from [https://demo-trunk.ofbiz.apache.org/webtools/control/entityref]
? That will give a clue regarding determining what is achievable.
{quote}
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]
> 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)
