[
https://issues.apache.org/jira/browse/OFBIZ-5297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13755972#comment-13755972
]
Parimal Gain edited comment on OFBIZ-5297 at 9/2/13 9:14 AM:
-------------------------------------------------------------
Hi Jacques,
These patches are working fine at my localhost. I'm currently in following
revision in my localhost
1) OFBiz-11.04 : 1512887
2) OFBiz-Trunk : 1519364
Following are the checkpoint -
1) Order should be Approved
2) All Dimension table(CurrencyDimension, DateDimension,
ProductDimension)should have record.
3) After approval of order, order record should be created in
'SalesOrderItemFact' table. These is the OLAP table used to display data in
reports.
Description -
1) If dimension table doesn't have records then following services should
execute from service engine -
a) loadAllProductsInProductDimension
b) loadCurrencyDimension
c) loadDateDimension
2) Calling service to create record in 'SalesOrderItemFact' is updated into
patch. On commit operation of service 'changeOrderItemStatus' if order item is
approved then 'loadSalesOrderFact' service called through SECS.
Please LMK the revision and the branch you are testing if report doesn't
display any value even after applying these changes.
For reference I have attached the screenshot of Last3Month sales report from my
localhost that shows sales order detail of July, Aug and Sep(current) month.
was (Author: parimal):
Hi Jacques,
These patches are working fine at my localhost. I'm currently in following
revision in my localhost
1) OFBiz-11.04 : 1512887
2) OFBiz-Trunk : 1519364
Following are the checkpoint -
1) Order should be Approved
2) All Dimension table(CurrencyDimension, DateDimension,
ProductDimension)should have record.
3) After approval of order, order record should be created in
'SalesOrderItemFact' table. These is the OLAP table used to display date in
reports.
Description -
1) If dimension table doesn't have records then following services should
execute from service engine -
a) loadAllProductsInProductDimension
b) loadCurrencyDimension
c) loadDateDimension
2) Calling service to create record in 'SalesOrderItemFact' is updated into
patch. On commit operation of service 'changeOrderItemStatus' if order item is
approved then 'loadSalesOrderFact' service called through SECS.
Please LMK the revision and the branch you are testing if report doesn't
display any value even after applying these changes.
For reference I have attached the screenshot of Last3Month sales report from my
localhost that shows sales order detail of July, Aug and Sep(current) month.
> Order Report Issue
> ------------------
>
> Key: OFBIZ-5297
> URL: https://issues.apache.org/jira/browse/OFBIZ-5297
> Project: OFBiz
> Issue Type: Sub-task
> Components: order
> Affects Versions: Release Branch 11.04, SVN trunk
> Reporter: Parimal Gain
> Labels: Birt
> Fix For: SVN trunk
>
> Attachments: Last3MonthSalesReport.PNG, OFBIZ-5297-11.04.patch,
> OFBIZ-5297-Trunk.patch
>
>
> Reports under Order component has following issues -
> 1. Following reports are not showing any records due some issue
> a. Last three month sales report.
> b. Sales report.
> c. Sales Order discount code report.
> d. Product demand report.
> 2. Inconsistency in opening the pdf report - some reports are opening in new
> tab window but some are in the same window.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
