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