Re: svn commit: r902719 [1/6] - in /ofbiz/trunk/applications/order: ./ data/ data/helpdata/ entitydef/ script/org/ofbiz/order/olap/ script/org/ofbiz/order/reports/ webapp/ordermgr/WEB-INF/ webapp/ordermgr/WEB-INF/actions/report/ webapp/ordermgr/WEB-INF/act...

[Scott Gray-2]

Hi Hans,

Why the need for an additional ProductStore?

Thanks
Scott

HotWax Media
http://www.hotwaxmedia.com

On 25/01/2010, at 12:23 AM, [hidden email] wrote:

> Author: hansbak
> Date: Mon Jan 25 07:23:57 2010
> New Revision: 902719
>
> URL: http://svn.apache.org/viewvc?rev=902719&view=rev
> Log:
> New Order reports: (run 'init warehouse' in the BI component first and select B2C productstore to see the demo data)
>
> - Net Before Overhead Report
> Net Before Overhead Report is the profit calculation of paid-shipped orders and all the occurred fee excluding the overhead cost. They are grouped by Product Store Id.(Demo data for Net Before Overhead Report have in Product Store Id 'B2CStore')
>
> - Product Demand Report
> Product Demand Report is the report to show us which product sells good and which product doesn’t sell good or not selling at all in one account as well as for all accounts in last 4 weeks. They are grouped by Product Store Id.(Demo data for Product Demand Report have in Product Store Id 'B2CStore')

[hans_bakker]

Hi Scott,

if you look at the reports they are pretty complicated. We got test data
from the customer and converted it to ofbiz demo data. Adding this data
to an existing productStore would have changed the test data so we
decided to create a separated productstore for this.

Regards,
Hans

On Mon, 2010-01-25 at 07:18 -0700, Scott Gray wrote:

> Hi Hans,
>
> Why the need for an additional ProductStore?
>
> Thanks
> Scott
>
> HotWax Media
> http://www.hotwaxmedia.com
>
> On 25/01/2010, at 12:23 AM, [hidden email] wrote:
>
> > Author: hansbak
> > Date: Mon Jan 25 07:23:57 2010
> > New Revision: 902719
> >
> > URL: http://svn.apache.org/viewvc?rev=902719&view=rev
> > Log:
> > New Order reports: (run 'init warehouse' in the BI component first and select B2C productstore to see the demo data)
> >
> > - Net Before Overhead Report
> > Net Before Overhead Report is the profit calculation of paid-shipped orders and all the occurred fee excluding the overhead cost. They are grouped by Product Store Id.(Demo data for Net Before Overhead Report have in Product Store Id 'B2CStore')
> >
> > - Product Demand Report
> > Product Demand Report is the report to show us which product sells good and which product doesn’t sell good or not selling at all in one account as well as for all accounts in last 4 weeks. They are grouped by Product Store Id.(Demo data for Product Demand Report have in Product Store Id 'B2CStore')
>

--
Antwebsystems.com: Quality OFBiz services for competitive rates

[Scott Gray-2]

Hi Hans,

Thanks for the explanation, but are saying that you didn't use the existing ProductStore because it would have been difficult for you and your client?  Demo data is for demonstration purposes and IMO if the additional ProductStores are not demonstrating some different/new functionality other than reports then we shouldn't be creating a whole new set of demo data for the community to maintain unnecessarily.

Regards
Scott

On 25/01/2010, at 4:25 PM, Hans Bakker wrote:

> Hi Scott,
>
> if you look at the reports they are pretty complicated. We got test data
> from the customer and converted it to ofbiz demo data. Adding this data
> to an existing productStore would have changed the test data so we
> decided to create a separated productstore for this.
>
> Regards,
> Hans
>
> On Mon, 2010-01-25 at 07:18 -0700, Scott Gray wrote:
>> Hi Hans,
>>
>> Why the need for an additional ProductStore?
>>
>> Thanks
>> Scott
>>
>> HotWax Media
>> http://www.hotwaxmedia.com
>>
>> On 25/01/2010, at 12:23 AM, [hidden email] wrote:
>>
>>> Author: hansbak
>>> Date: Mon Jan 25 07:23:57 2010
>>> New Revision: 902719
>>>
>>> URL: http://svn.apache.org/viewvc?rev=902719&view=rev
>>> Log:
>>> New Order reports: (run 'init warehouse' in the BI component first and select B2C productstore to see the demo data)
>>>
>>> - Net Before Overhead Report
>>> Net Before Overhead Report is the profit calculation of paid-shipped orders and all the occurred fee excluding the overhead cost. They are grouped by Product Store Id.(Demo data for Net Before Overhead Report have in Product Store Id 'B2CStore')
>>>
>>> - Product Demand Report
>>> Product Demand Report is the report to show us which product sells good and which product doesn’t sell good or not selling at all in one account as well as for all accounts in last 4 weeks. They are grouped by Product Store Id.(Demo data for Product Demand Report have in Product Store Id 'B2CStore')
>>
> --
> Antwebsystems.com: Quality OFBiz services for competitive rates
>

[Jacopo Cappellato-4]

Hi Hans,

the goal of the existing product store (and demo data in general) is to provide a basis for demonstrating available features. Demo data are also used as a basis for automated tests.
This is why we should consider demo data a very important part of the project, at the same level of code: we should take care of it and spend time to keep it clear, in a similar way we do with services.
But this takes time and so we should keep demo data as small as possible by avoiding duplicated information.
If there are specific settings in the product store that are mandatory for the reports to work properly, then we should discuss this and see if we can modify the settings of the official product store. If this is not possible (but I would be surprised of this) we should probably add a new product store with minimal data setup just to demonstrate the reports.
If you simply don't have time to do this now, my preference would be to keep the demo data for the reports into a separate file attached to a Jira issue.

Kind regards,

Jacopo


On Jan 26, 2010, at 12:25 AM, Hans Bakker wrote:

> Hi Scott,
>
> if you look at the reports they are pretty complicated. We got test data
> from the customer and converted it to ofbiz demo data. Adding this data
> to an existing productStore would have changed the test data so we
> decided to create a separated productstore for this.
>
> Regards,
> Hans
>
> On Mon, 2010-01-25 at 07:18 -0700, Scott Gray wrote:
>> Hi Hans,
>>
>> Why the need for an additional ProductStore?
>>
>> Thanks
>> Scott
>>
>> HotWax Media
>> http://www.hotwaxmedia.com
>>
>> On 25/01/2010, at 12:23 AM, [hidden email] wrote:
>>
>>> Author: hansbak
>>> Date: Mon Jan 25 07:23:57 2010
>>> New Revision: 902719
>>>
>>> URL: http://svn.apache.org/viewvc?rev=902719&view=rev
>>> Log:
>>> New Order reports: (run 'init warehouse' in the BI component first and select B2C productstore to see the demo data)
>>>
>>> - Net Before Overhead Report
>>> Net Before Overhead Report is the profit calculation of paid-shipped orders and all the occurred fee excluding the overhead cost. They are grouped by Product Store Id.(Demo data for Net Before Overhead Report have in Product Store Id 'B2CStore')
>>>
>>> - Product Demand Report
>>> Product Demand Report is the report to show us which product sells good and which product doesn’t sell good or not selling at all in one account as well as for all accounts in last 4 weeks. They are grouped by Product Store Id.(Demo data for Product Demand Report have in Product Store Id 'B2CStore')
>>
> --
> Antwebsystems.com: Quality OFBiz services for competitive rates
>

[Scott Gray-2]

This conversation seems to have died without coming to a conclusion, did you have any thoughts to share Hans?

Thanks
Scott

On 26/01/2010, at 10:07 AM, Jacopo Cappellato wrote:

> Hi Hans,
>
> the goal of the existing product store (and demo data in general) is to provide a basis for demonstrating available features. Demo data are also used as a basis for automated tests.
> This is why we should consider demo data a very important part of the project, at the same level of code: we should take care of it and spend time to keep it clear, in a similar way we do with services.
> But this takes time and so we should keep demo data as small as possible by avoiding duplicated information.
> If there are specific settings in the product store that are mandatory for the reports to work properly, then we should discuss this and see if we can modify the settings of the official product store. If this is not possible (but I would be surprised of this) we should probably add a new product store with minimal data setup just to demonstrate the reports.
> If you simply don't have time to do this now, my preference would be to keep the demo data for the reports into a separate file attached to a Jira issue.
>
> Kind regards,
>
> Jacopo
>
>
> On Jan 26, 2010, at 12:25 AM, Hans Bakker wrote:
>
>> Hi Scott,
>>
>> if you look at the reports they are pretty complicated. We got test data
>> from the customer and converted it to ofbiz demo data. Adding this data
>> to an existing productStore would have changed the test data so we
>> decided to create a separated productstore for this.
>>
>> Regards,
>> Hans
>>
>> On Mon, 2010-01-25 at 07:18 -0700, Scott Gray wrote:
>>> Hi Hans,
>>>
>>> Why the need for an additional ProductStore?
>>>
>>> Thanks
>>> Scott
>>>
>>> HotWax Media
>>> http://www.hotwaxmedia.com
>>>
>>> On 25/01/2010, at 12:23 AM, [hidden email] wrote:
>>>
>>>> Author: hansbak
>>>> Date: Mon Jan 25 07:23:57 2010
>>>> New Revision: 902719
>>>>
>>>> URL: http://svn.apache.org/viewvc?rev=902719&view=rev
>>>> Log:
>>>> New Order reports: (run 'init warehouse' in the BI component first and select B2C productstore to see the demo data)
>>>>
>>>> - Net Before Overhead Report
>>>> Net Before Overhead Report is the profit calculation of paid-shipped orders and all the occurred fee excluding the overhead cost. They are grouped by Product Store Id.(Demo data for Net Before Overhead Report have in Product Store Id 'B2CStore')
>>>>
>>>> - Product Demand Report
>>>> Product Demand Report is the report to show us which product sells good and which product doesn’t sell good or not selling at all in one account as well as for all accounts in last 4 weeks. They are grouped by Product Store Id.(Demo data for Product Demand Report have in Product Store Id 'B2CStore')
>>>
>> --
>> Antwebsystems.com: Quality OFBiz services for competitive rates
>>
>

[hans_bakker]

Scott,

Because i do not really have an answer on this. Simply add them to a
jira issue is not much help. They are an essential part of the reports
for demonstration.

These reports are only interesting for the larger customer sites we
support. Without demo data they are pretty useless. Looking at he
existing orderdemo data there is actually not much there, i count
4 orders. We could add the saleschannels and orders of the new to the
existing productstores. I only wonder what would get better than?

Now it also shows that the orderlist in order manager has no paging?

Regards,
Hans

On Fri, 2010-01-29 at 11:18 -0700, Scott Gray wrote:

> This conversation seems to have died without coming to a conclusion, did you have any thoughts to share Hans?
>
> Thanks
> Scott
>
> On 26/01/2010, at 10:07 AM, Jacopo Cappellato wrote:
>
> > Hi Hans,
> >
> > the goal of the existing product store (and demo data in general) is to provide a basis for demonstrating available features. Demo data are also used as a basis for automated tests.
> > This is why we should consider demo data a very important part of the project, at the same level of code: we should take care of it and spend time to keep it clear, in a similar way we do with services.
> > But this takes time and so we should keep demo data as small as possible by avoiding duplicated information.
> > If there are specific settings in the product store that are mandatory for the reports to work properly, then we should discuss this and see if we can modify the settings of the official product store. If this is not possible (but I would be surprised of this) we should probably add a new product store with minimal data setup just to demonstrate the reports.
> > If you simply don't have time to do this now, my preference would be to keep the demo data for the reports into a separate file attached to a Jira issue.
> >
> > Kind regards,
> >
> > Jacopo
> >
> >
> > On Jan 26, 2010, at 12:25 AM, Hans Bakker wrote:
> >
> >> Hi Scott,
> >>
> >> if you look at the reports they are pretty complicated. We got test data
> >> from the customer and converted it to ofbiz demo data. Adding this data
> >> to an existing productStore would have changed the test data so we
> >> decided to create a separated productstore for this.
> >>
> >> Regards,
> >> Hans
> >>
> >> On Mon, 2010-01-25 at 07:18 -0700, Scott Gray wrote:
> >>> Hi Hans,
> >>>
> >>> Why the need for an additional ProductStore?
> >>>
> >>> Thanks
> >>> Scott
> >>>
> >>> HotWax Media
> >>> http://www.hotwaxmedia.com
> >>>
> >>> On 25/01/2010, at 12:23 AM, [hidden email] wrote:
> >>>
> >>>> Author: hansbak
> >>>> Date: Mon Jan 25 07:23:57 2010
> >>>> New Revision: 902719
> >>>>
> >>>> URL: http://svn.apache.org/viewvc?rev=902719&view=rev
> >>>> Log:
> >>>> New Order reports: (run 'init warehouse' in the BI component first and select B2C productstore to see the demo data)
> >>>>
> >>>> - Net Before Overhead Report
> >>>> Net Before Overhead Report is the profit calculation of paid-shipped orders and all the occurred fee excluding the overhead cost. They are grouped by Product Store Id.(Demo data for Net Before Overhead Report have in Product Store Id 'B2CStore')
> >>>>
> >>>> - Product Demand Report
> >>>> Product Demand Report is the report to show us which product sells good and which product doesn’t sell good or not selling at all in one account as well as for all accounts in last 4 weeks. They are grouped by Product Store Id.(Demo data for Product Demand Report have in Product Store Id 'B2CStore')
> >>>
> >> --
> >> Antwebsystems.com: Quality OFBiz services for competitive rates
> >>
> >
>

--
Antwebsystems.com: Quality OFBiz services for competitive rates

[Scott Gray-2]

Well Hans, the problem as I see it is that you've added a whole stack of new demo data and I'm yet to understand what new features we're able to demonstrate.  Half of the Order Manager reports based on BIRT display no information whatsoever when the reports are run.  The additional demo data hides features from new users because they aren't able to discern the good stuff from the junk.

The reason there are so few order is because we aren't really able to demonstrate additional features using order data.  I have no problem with additional order data being added to the existing product store or even adding an additional product store but what I don't like is additional redundant data such as the B2C store which is already adequately represented by the eCommerce product store.

Regards
Scott

On 30/01/2010, at 8:30 PM, Hans Bakker wrote:

> Scott,
>
> Because i do not really have an answer on this. Simply add them to a
> jira issue is not much help. They are an essential part of the reports
> for demonstration.
>
> These reports are only interesting for the larger customer sites we
> support. Without demo data they are pretty useless. Looking at he
> existing orderdemo data there is actually not much there, i count
> 4 orders. We could add the saleschannels and orders of the new to the
> existing productstores. I only wonder what would get better than?
>
> Now it also shows that the orderlist in order manager has no paging?
>
> Regards,
> Hans
>
> On Fri, 2010-01-29 at 11:18 -0700, Scott Gray wrote:
>> This conversation seems to have died without coming to a conclusion, did you have any thoughts to share Hans?
>>
>> Thanks
>> Scott
>>
>> On 26/01/2010, at 10:07 AM, Jacopo Cappellato wrote:
>>
>>> Hi Hans,
>>>
>>> the goal of the existing product store (and demo data in general) is to provide a basis for demonstrating available features. Demo data are also used as a basis for automated tests.
>>> This is why we should consider demo data a very important part of the project, at the same level of code: we should take care of it and spend time to keep it clear, in a similar way we do with services.
>>> But this takes time and so we should keep demo data as small as possible by avoiding duplicated information.
>>> If there are specific settings in the product store that are mandatory for the reports to work properly, then we should discuss this and see if we can modify the settings of the official product store. If this is not possible (but I would be surprised of this) we should probably add a new product store with minimal data setup just to demonstrate the reports.
>>> If you simply don't have time to do this now, my preference would be to keep the demo data for the reports into a separate file attached to a Jira issue.
>>>
>>> Kind regards,
>>>
>>> Jacopo
>>>
>>>
>>> On Jan 26, 2010, at 12:25 AM, Hans Bakker wrote:
>>>
>>>> Hi Scott,
>>>>
>>>> if you look at the reports they are pretty complicated. We got test data
>>>> from the customer and converted it to ofbiz demo data. Adding this data
>>>> to an existing productStore would have changed the test data so we
>>>> decided to create a separated productstore for this.
>>>>
>>>> Regards,
>>>> Hans
>>>>
>>>> On Mon, 2010-01-25 at 07:18 -0700, Scott Gray wrote:
>>>>> Hi Hans,
>>>>>
>>>>> Why the need for an additional ProductStore?
>>>>>
>>>>> Thanks
>>>>> Scott
>>>>>
>>>>> HotWax Media
>>>>> http://www.hotwaxmedia.com
>>>>>
>>>>> On 25/01/2010, at 12:23 AM, [hidden email] wrote:
>>>>>
>>>>>> Author: hansbak
>>>>>> Date: Mon Jan 25 07:23:57 2010
>>>>>> New Revision: 902719
>>>>>>
>>>>>> URL: http://svn.apache.org/viewvc?rev=902719&view=rev
>>>>>> Log:
>>>>>> New Order reports: (run 'init warehouse' in the BI component first and select B2C productstore to see the demo data)
>>>>>>
>>>>>> - Net Before Overhead Report
>>>>>> Net Before Overhead Report is the profit calculation of paid-shipped orders and all the occurred fee excluding the overhead cost. They are grouped by Product Store Id.(Demo data for Net Before Overhead Report have in Product Store Id 'B2CStore')
>>>>>>
>>>>>> - Product Demand Report
>>>>>> Product Demand Report is the report to show us which product sells good and which product doesn’t sell good or not selling at all in one account as well as for all accounts in last 4 weeks. They are grouped by Product Store Id.(Demo data for Product Demand Report have in Product Store Id 'B2CStore')
>>>>>
>>>> --
>>>> Antwebsystems.com: Quality OFBiz services for competitive rates
>>>>
>>>
>>
> --
> Antwebsystems.com: Quality OFBiz services for competitive rates
>