[
https://issues.apache.org/jira/browse/OFBIZ-10990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16828951#comment-16828951 ]
Pierre Smits commented on OFBIZ-10990:
--------------------------------------
Hi Swapnil,
For sure, adding appropriate sub level fields (per type from the Geo table) to the table should not considered be a complex issue.
As for the renaming the dimension to something more generic this might be favourable for (some) OFBiz contributors. But when you factor in the intended users within the adopter's organisation and others, you'll find that the average person is more comfortable with commonalities (de-facto standards and understandings).
Even the ISO organisation does not talk about geos (see [1]).
When you search for the entities comprised in the org.apache.ofbiz.common.geo package you'll find that there are:
# CountryAddressFormat
# CountryCapital
# CountryCode
# CountryTeleCode
# CountryTeleCodeAndName
# Geo
# GeoAssoc
# GeoAssocAndFrom
# GeoAssocAndTo
# GeoAssocAndToWithState
# GeoAssocType
# GeoPoint
# GeoType
And by association in org.apache.ofbiz.party.contact:
# PostalAddress
# PostalAddressBoundary
The project has catered - with respect to country vs geo - to providing more commonly understood entity names (starting with Country) than more abstract ones (Geo) in the ofbiz db.
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?
1]
https://en.wikipedia.org/wiki/ISO_3166-1> 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
