[jira] [Comment Edited] (OFBIZ-10990) Improve the SalesInvoiceItemStarSchema
[ https://issues.apache.org/jira/browse/OFBIZ-10990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16829983#comment-16829983 ] Jacques Le Roux edited comment on OFBIZ-10990 at 5/17/19 6:25 AM: -- No worries, Swapnil, I value each and every input. Could you share your thoughts on [\[DISCUSSION\] bi/birt component integration|https://lists.apache.org/thread.html/7f7db5645bba8b9de3a0189356300afd0d7651646671ad782b0a557f@%3Cdev.ofbiz.apache.org%3E] ? was (Author: pfm.smits): No worries, Swapnil, I value each and every input. Could you share your thoughts on [[DISCUSSION] bi/birt component integration|https://lists.apache.org/thread.html/7f7db5645bba8b9de3a0189356300afd0d7651646671ad782b0a557f@%3Cdev.ofbiz.apache.org%3E] ? > 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: SalesInvoiceItemStarSchema, birt, dwh, star, starschema > > 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)
[jira] [Comment Edited] (OFBIZ-10990) Improve the SalesInvoiceItemStarSchema
[
https://issues.apache.org/jira/browse/OFBIZ-10990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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)
[jira] [Comment Edited] (OFBIZ-10990) Improve the SalesInvoiceItemStarSchema
[ https://issues.apache.org/jira/browse/OFBIZ-10990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16828881#comment-16828881 ] Swapnil Shah edited comment on OFBIZ-10990 at 4/29/19 3:40 AM: --- Can we try to add followng more dimensions as well (if not done already): : * *Product Dimesion* - Can help in getting the Brand, Style, Assortments, Component level info for different views. * *Time Dimension* - can help in getting financial/merchandising calendars with Years, Season, quarters, weeks , days etc. for different views. * *Supplier Dimension* - can help in getting Supplier, Vendors or any other product sourcing agency info for different views. was (Author: swash78): Can we also try to add followng more dimensions as well (if not done already): : * *Product Dimesion* - Can help in getting the Brand, Style, Assortments, Component level info for different views. * *Time Dimension* - can help in getting financial/merchandising calendars with Years, Season, quarters, weeks , days etc. for different views. * *Supplier Dimension* - can help in getting Supplier, Vendors or any other product sourcing agency info for different views. > 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)
