Project:
| View Revisions: Issue #38624 | [ Back to Issue ] | ||
| Summary | 0038624: Records in OBANALY_FACT_ORDER previous to forward start date are removed if they are updated | ||
| Revision | 2018-05-25 10:21 by ngarcia | ||
| Steps To Reproduce | As System Admin role: In Process Request window schedule 'Update Time Dimension Refs + Tree Closure Table' to be run immediately As group admin role: In Process Request window schedule 'Clear Analytics Fact Table' to be run immediately Create a record in Analytics Process Configuration window: Forward Start Date: yesterday Create two Sales Order with yesterday's date and POS Order document type, add a product with stock and book them Create a Sales Order with today's date and POS Order document type, add a product with stock and book it In Process Request window schedule 'Forward Update Analytics Fact Tables' to be run immediately Go to Analytics Sales Detail View and check the three sales orders are shown Pay only one of the invoices related with a yesterday's order (the invoice will be updated) Modify the record in Analytics Process Configuration window: Forward Start Date: today In Process Request window schedule 'Forward Update Analytics Fact Tables' to be run immediately Go to Analytics Sales Detail View and check the paid order is not shown |
||
| Revision | 2018-05-25 10:20 by ngarcia | ||
| Steps To Reproduce | As System Admin role: In Process Request window schedule 'Update Time Dimension Refs + Tree Closure Table' to be run immediately As group admin role: In Process Request window schedule 'Clear Analytics Fact Table' to be run immediately Create a record in Analytics Process Configuration window: Forward Start Date: yesterday Create two Sales Order with yesterday's date and POS Order document type, add a product with stock and book them Create a Sales Order with today's date and POS Order document type, add a product with stock and book it Modify the record in Analytics Process Configuration window: Forward Start Date: today In Process Request window schedule 'Forward Update Analytics Fact Tables' to be run immediately Go to Analytics Sales Detail View and check the three sales orders are shown Pay only one of the invoices related with a yesterday's order (the invoice will be updated) In Process Request window schedule 'Forward Update Analytics Fact Tables' to be run immediately Go to Analytics Sales Detail View and check the paid order is not shown |
||
| Revision | 2018-05-25 10:19 by ngarcia | ||
| Steps To Reproduce | As System Admin role: In Process Request window schedule 'Update Time Dimension Refs + Tree Closure Table' to be run immediately As group admin role: In Process Request window schedule 'Clear Analytics Fact Table' to be run immediately Create a record in Analytics Process Configuration window: Forward Start Date: yesterday Create two Sales Order with yesterday's date and POS Order document type, add a product with stock and book them Create a Sales Order with today's date and POS Order document type, add a product with stock and book it Create a record in Analytics Process Configuration window: Forward Start Date: today In Process Request window schedule 'Forward Update Analytics Fact Tables' to be run immediately Go to Analytics Sales Detail View and check the three sales orders are shown Pay only one of the invoices related with a yesterday's order (the invoice will be updated) In Process Request window schedule 'Forward Update Analytics Fact Tables' to be run immediately Go to Analytics Sales Detail View and check the paid order is not shown |
||
| Revision | 2018-05-24 19:22 by ngarcia | ||
| Steps To Reproduce | As System Admin role: In Process Request window schedule 'Update Time Dimension Refs + Tree Closure Table' to be run immediately As group admin role: In Process Request window schedule 'Clear Analytics Fact Table' to be run immediately Create a record in Analytics Process Configuration window: Forward Start Date: yesterday Create two Sales Order with yesterday's date and POS Order document type, add a product with stock and book them Create a Sales Order with today's date and POS Order document type, add a product with stock and book it In Process Request window schedule 'Forward Update Analytics Fact Tables' to be run immediately Go to Analytics Sales Detail View and check the three sales orders are shown Pay only one of the invoices related with a yesterday's order (the invoice will be updated) In Process Request window schedule 'Forward Update Analytics Fact Tables' to be run immediately Go to Analytics Sales Detail View and check the paid order is not shown |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |