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

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[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=16828881#comment-16828881 ]

Swapnil Shah commented on OFBIZ-10990:
--------------------------------------

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)