[ https://issues.apache.org/jira/browse/OFBIZ-10990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16829210#comment-16829210 ]
Swapnil Shah commented on OFBIZ-10990: -------------------------------------- {quote} My point being: why not bring it back in the olap db to one single entity that is commonly understood, because most elements are hierarchical to the country? {quote} I would not be very particular about naming convention at this point of time as long as we are able to capture the market segmentation based on the different geographies. For a typical global business, the sales hierarchy based on the geographic market segmentation might even start from above the country level like APAC,EMEA,AMER etc. and goes down till City or zip code level. > 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)