You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Michael Brohl <mi...@ecomify.de> on 2020/01/30 15:51:39 UTC
Re: [ofbiz-plugins] branch trunk updated: Implemented: Have a Country
Dimension (OFBIZ-10954)
Hi Pawan, all,
I really don't see any reason to introduce tables into the codebase
which are not used anywhere in the current functionality.
I would recommend to wait until there is substantial functioanality
which use these table. As Piere stated in some of the *Dimension Jiras:
"The component would benefit from a ... dimension for future fact tables
and star schema view entities".
What do others think?
Thanks,
Michael Brohl
ecomify GmbH - www.ecomify.de
Am 30.01.20 um 10:15 schrieb pawan@apache.org:
> This is an automated email from the ASF dual-hosted git repository.
>
> pawan pushed a commit to branch trunk
> in repository https://gitbox.apache.org/repos/asf/ofbiz-plugins.git
>
>
> The following commit(s) were added to refs/heads/trunk by this push:
> new ccb6219 Implemented: Have a Country Dimension (OFBIZ-10954)
> ccb6219 is described below
>
> commit ccb6219954a0b523b8ff854da5954af2feaab8d0
> Author: Pawan Verma <pa...@hotwaxsystems.com>
> AuthorDate: Thu Jan 30 14:45:25 2020 +0530
>
> Implemented: Have a Country Dimension
> (OFBIZ-10954)
>
> Added new CountryDimension entity in olap.
>
> Thanks: Pierre Smits for your contribution.
> ---
> bi/entitydef/entitygroup.xml | 1 +
> bi/entitydef/entitymodel.xml | 25 +++++++++++++++++++++++++
> 2 files changed, 26 insertions(+)
>
> diff --git a/bi/entitydef/entitygroup.xml b/bi/entitydef/entitygroup.xml
> index 2d34fe7..670405c 100644
> --- a/bi/entitydef/entitygroup.xml
> +++ b/bi/entitydef/entitygroup.xml
> @@ -24,6 +24,7 @@ under the License.
> <!-- ========================================================= -->
> <!-- Dimensions -->
> <!-- ========================================================= -->
> + <entity-group group="org.apache.ofbiz.olap" entity="CountryDimension"/>
> <entity-group group="org.apache.ofbiz.olap" entity="CurrencyDimension"/>
> <entity-group group="org.apache.ofbiz.olap" entity="DateDimension"/>
> <entity-group group="org.apache.ofbiz.olap" entity="ProductDimension"/>
> diff --git a/bi/entitydef/entitymodel.xml b/bi/entitydef/entitymodel.xml
> index 57c0868..7bdfe25 100644
> --- a/bi/entitydef/entitymodel.xml
> +++ b/bi/entitydef/entitymodel.xml
> @@ -29,6 +29,31 @@ under the License.
> <!-- ========================================================= -->
> <!-- Dimensions -->
> <!-- ========================================================= -->
> + <entity entity-name="CountryDimension" package-name="org.apache.ofbiz.bi.dimension" title="Country Dimension">
> + <description>Country dimension. Based on ISO 3166-1. The natural key is [geoId]</description>
> + <field name="dimensionId" type="id">
> + <description>Unique identifier of the Date dimension record</description>
> + </field>
> + <field name="geoId" type="id">
> + <description>The natural key, based on ISO 3166-1 alpha-3</description>
> + </field>
> + <field name="geoName" type="name">
> + <description>The name of the country, based on ISO 3166</description>
> + </field>
> + <field name="geoCode" type="short-varchar">
> + <description>The ISO 3166-1 alpha-2 code of the country</description>
> + </field>
> + <field name="abbreviation" type="short-varchar">
> + <description>Based on the ISO 3166-1 alpha-3 code of the country</description>
> + </field>
> + <field name="telCountryCode" type="short-varchar">
> + <description>The telephone country code. Based on ITU.E123 and ITU.164</description>
> + </field>
> + <field name="ccTld" type="short-varchar">
> + <description>The country code top-level domain for the country. Base on IANA rfc1591</description>
> + </field>
> + <prim-key field="dimensionId"/>
> + </entity>
> <entity entity-name="DateDimension" package-name="org.apache.ofbiz.bi.dimension" title="Date Dimension">
> <description>Date (days) dimension. The natural key is [dateValue]</description>
> <field name="dimensionId" type="id">
>
Re: [ofbiz-plugins] branch trunk updated: Implemented: Have a Country
Dimension (OFBIZ-10954)
Posted by Pierre Smits <pi...@apache.org>.
Nicolas,
A ticket regarding the service to populate the dimension is available in
JIRA. See OFBIZ-10954. In that ticket I suggested a solution approach for
the assignee (or anyone else) to evaluate before I submit a pull request.
Best regards,
Pierre Smits
*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer
On Wed, Feb 5, 2020 at 7:00 PM Nicolas Malin <ni...@nereide.fr>
wrote:
> Hi,
>
> On 30/01/2020 16:51, Michael Brohl wrote:
> > Hi Pawan, all,
> >
> > I really don't see any reason to introduce tables into the codebase
> > which are not used anywhere in the current functionality.
> >
> > I would recommend to wait until there is substantial functioanality
> > which use these table. As Piere stated in some of the *Dimension
> > Jiras: "The component would benefit from a ... dimension for future
> > fact tables and star schema view entities".
> >
> > What do others think?
>
> I'm not opposed to introduce some new dimension, if we have service to
> populate them, as bi api.
>
> Otherwise the added valuable would be small because not really easy to use.
>
> After use a dimension with fact element are, for me, just an example how
> we can use this dimension
>
> Nicolas
>
> >
> > Thanks,
> >
> > Michael Brohl
> >
> > ecomify GmbH - www.ecomify.de
> >
> >
> > Am 30.01.20 um 10:15 schrieb pawan@apache.org:
> >> This is an automated email from the ASF dual-hosted git repository.
> >>
> >> pawan pushed a commit to branch trunk
> >> in repository https://gitbox.apache.org/repos/asf/ofbiz-plugins.git
> >>
> >>
> >> The following commit(s) were added to refs/heads/trunk by this push:
> >> new ccb6219 Implemented: Have a Country Dimension (OFBIZ-10954)
> >> ccb6219 is described below
> >>
> >> commit ccb6219954a0b523b8ff854da5954af2feaab8d0
> >> Author: Pawan Verma <pa...@hotwaxsystems.com>
> >> AuthorDate: Thu Jan 30 14:45:25 2020 +0530
> >>
> >> Implemented: Have a Country Dimension
> >> (OFBIZ-10954)
> >> Added new CountryDimension entity in olap.
> >> Thanks: Pierre Smits for your contribution.
> >> ---
> >> bi/entitydef/entitygroup.xml | 1 +
> >> bi/entitydef/entitymodel.xml | 25 +++++++++++++++++++++++++
> >> 2 files changed, 26 insertions(+)
> >>
> >> diff --git a/bi/entitydef/entitygroup.xml b/bi/entitydef/entitygroup.xml
> >> index 2d34fe7..670405c 100644
> >> --- a/bi/entitydef/entitygroup.xml
> >> +++ b/bi/entitydef/entitygroup.xml
> >> @@ -24,6 +24,7 @@ under the License.
> >> <!-- ========================================================= -->
> >> <!--
> >> Dimensions -->
> >> <!-- ========================================================= -->
> >> + <entity-group group="org.apache.ofbiz.olap"
> >> entity="CountryDimension"/>
> >> <entity-group group="org.apache.ofbiz.olap"
> >> entity="CurrencyDimension"/>
> >> <entity-group group="org.apache.ofbiz.olap"
> >> entity="DateDimension"/>
> >> <entity-group group="org.apache.ofbiz.olap"
> >> entity="ProductDimension"/>
> >> diff --git a/bi/entitydef/entitymodel.xml b/bi/entitydef/entitymodel.xml
> >> index 57c0868..7bdfe25 100644
> >> --- a/bi/entitydef/entitymodel.xml
> >> +++ b/bi/entitydef/entitymodel.xml
> >> @@ -29,6 +29,31 @@ under the License.
> >> <!-- ========================================================= -->
> >> <!-- Dimensions -->
> >> <!-- ========================================================= -->
> >> + <entity entity-name="CountryDimension"
> >> package-name="org.apache.ofbiz.bi.dimension" title="Country Dimension">
> >> + <description>Country dimension. Based on ISO 3166-1. The
> >> natural key is [geoId]</description>
> >> + <field name="dimensionId" type="id">
> >> + <description>Unique identifier of the Date dimension
> >> record</description>
> >> + </field>
> >> + <field name="geoId" type="id">
> >> + <description>The natural key, based on ISO 3166-1
> >> alpha-3</description>
> >> + </field>
> >> + <field name="geoName" type="name">
> >> + <description>The name of the country, based on ISO
> >> 3166</description>
> >> + </field>
> >> + <field name="geoCode" type="short-varchar">
> >> + <description>The ISO 3166-1 alpha-2 code of the
> >> country</description>
> >> + </field>
> >> + <field name="abbreviation" type="short-varchar">
> >> + <description>Based on the ISO 3166-1 alpha-3 code of the
> >> country</description>
> >> + </field>
> >> + <field name="telCountryCode" type="short-varchar">
> >> + <description>The telephone country code. Based on
> >> ITU.E123 and ITU.164</description>
> >> + </field>
> >> + <field name="ccTld" type="short-varchar">
> >> + <description>The country code top-level domain for the
> >> country. Base on IANA rfc1591</description>
> >> + </field>
> >> + <prim-key field="dimensionId"/>
> >> + </entity>
> >> <entity entity-name="DateDimension"
> >> package-name="org.apache.ofbiz.bi.dimension" title="Date Dimension">
> >> <description>Date (days) dimension. The natural key is
> >> [dateValue]</description>
> >> <field name="dimensionId" type="id">
> >>
> >
>
Re: [ofbiz-plugins] branch trunk updated: Implemented: Have a Country
Dimension (OFBIZ-10954)
Posted by Nicolas Malin <ni...@nereide.fr>.
Hi,
On 30/01/2020 16:51, Michael Brohl wrote:
> Hi Pawan, all,
>
> I really don't see any reason to introduce tables into the codebase
> which are not used anywhere in the current functionality.
>
> I would recommend to wait until there is substantial functioanality
> which use these table. As Piere stated in some of the *Dimension
> Jiras: "The component would benefit from a ... dimension for future
> fact tables and star schema view entities".
>
> What do others think?
I'm not opposed to introduce some new dimension, if we have service to
populate them, as bi api.
Otherwise the added valuable would be small because not really easy to use.
After use a dimension with fact element are, for me, just an example how
we can use this dimension
Nicolas
>
> Thanks,
>
> Michael Brohl
>
> ecomify GmbH - www.ecomify.de
>
>
> Am 30.01.20 um 10:15 schrieb pawan@apache.org:
>> This is an automated email from the ASF dual-hosted git repository.
>>
>> pawan pushed a commit to branch trunk
>> in repository https://gitbox.apache.org/repos/asf/ofbiz-plugins.git
>>
>>
>> The following commit(s) were added to refs/heads/trunk by this push:
>> new ccb6219 Implemented: Have a Country Dimension (OFBIZ-10954)
>> ccb6219 is described below
>>
>> commit ccb6219954a0b523b8ff854da5954af2feaab8d0
>> Author: Pawan Verma <pa...@hotwaxsystems.com>
>> AuthorDate: Thu Jan 30 14:45:25 2020 +0530
>>
>> Implemented: Have a Country Dimension
>> (OFBIZ-10954)
>> Added new CountryDimension entity in olap.
>> Thanks: Pierre Smits for your contribution.
>> ---
>> bi/entitydef/entitygroup.xml | 1 +
>> bi/entitydef/entitymodel.xml | 25 +++++++++++++++++++++++++
>> 2 files changed, 26 insertions(+)
>>
>> diff --git a/bi/entitydef/entitygroup.xml b/bi/entitydef/entitygroup.xml
>> index 2d34fe7..670405c 100644
>> --- a/bi/entitydef/entitygroup.xml
>> +++ b/bi/entitydef/entitygroup.xml
>> @@ -24,6 +24,7 @@ under the License.
>> <!-- ========================================================= -->
>> <!--
>> Dimensions -->
>> <!-- ========================================================= -->
>> + <entity-group group="org.apache.ofbiz.olap"
>> entity="CountryDimension"/>
>> <entity-group group="org.apache.ofbiz.olap"
>> entity="CurrencyDimension"/>
>> <entity-group group="org.apache.ofbiz.olap"
>> entity="DateDimension"/>
>> <entity-group group="org.apache.ofbiz.olap"
>> entity="ProductDimension"/>
>> diff --git a/bi/entitydef/entitymodel.xml b/bi/entitydef/entitymodel.xml
>> index 57c0868..7bdfe25 100644
>> --- a/bi/entitydef/entitymodel.xml
>> +++ b/bi/entitydef/entitymodel.xml
>> @@ -29,6 +29,31 @@ under the License.
>> <!-- ========================================================= -->
>> <!-- Dimensions -->
>> <!-- ========================================================= -->
>> + <entity entity-name="CountryDimension"
>> package-name="org.apache.ofbiz.bi.dimension" title="Country Dimension">
>> + <description>Country dimension. Based on ISO 3166-1. The
>> natural key is [geoId]</description>
>> + <field name="dimensionId" type="id">
>> + <description>Unique identifier of the Date dimension
>> record</description>
>> + </field>
>> + <field name="geoId" type="id">
>> + <description>The natural key, based on ISO 3166-1
>> alpha-3</description>
>> + </field>
>> + <field name="geoName" type="name">
>> + <description>The name of the country, based on ISO
>> 3166</description>
>> + </field>
>> + <field name="geoCode" type="short-varchar">
>> + <description>The ISO 3166-1 alpha-2 code of the
>> country</description>
>> + </field>
>> + <field name="abbreviation" type="short-varchar">
>> + <description>Based on the ISO 3166-1 alpha-3 code of the
>> country</description>
>> + </field>
>> + <field name="telCountryCode" type="short-varchar">
>> + <description>The telephone country code. Based on
>> ITU.E123 and ITU.164</description>
>> + </field>
>> + <field name="ccTld" type="short-varchar">
>> + <description>The country code top-level domain for the
>> country. Base on IANA rfc1591</description>
>> + </field>
>> + <prim-key field="dimensionId"/>
>> + </entity>
>> <entity entity-name="DateDimension"
>> package-name="org.apache.ofbiz.bi.dimension" title="Date Dimension">
>> <description>Date (days) dimension. The natural key is
>> [dateValue]</description>
>> <field name="dimensionId" type="id">
>>
>