Notes |
|
|
|
|
|
Having Foreign Keys in Fact tables is not necessary and it makes the insertion of the data slow.
Remove the foreign keys for the Fact tables to improve performance.
The tables affected are:
- From org.openbravo.client.analytics:
- obanaly_fact_discounts
- obanaly_fact_order
- obanaly_fact_salesordheader
- From org.openbravo.retail.analytics:
- obretan_fact_sessions |
|
|
|
From org.openbravo.financial.dimensionalpandlreport:
- OBDPL_FACT_ACCT_PL |
|
|
|
Note: Tested in client environment |
|
|
(0110224)
|
hgbot
|
2019-03-05 11:47
|
|
Repository: erp/devel/pi
Changeset: 46a06da3a17ae0b6b8105a4a6bccfe06718ebe16
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Fri Mar 01 13:37:14 2019 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/46a06da3a17ae0b6b8105a4a6bccfe06718ebe16 [^]
Related To Issue 39328:Analytics should not have referential
integrity with transactional data
** Add tables to white list to avoid fk checks to avoid warnings
during export database task obanaly_fact_discounts,
obanaly_fact_order, obanaly_fact_salesordheader, obretan_fact_sessions
and obdpl_fact_acct_pl
** Added existing ignored table ad_module_install in the white list
---
M src/org/openbravo/service/system/DatabaseValidator.java
---
|
|
|
(0110225)
|
hgbot
|
2019-03-05 11:47
|
|
Repository: erp/pmods/org.openbravo.client.analytics
Changeset: 34a0b0030a81698ddb2623ef16fe83b8e3284e0b
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Feb 27 16:40:54 2019 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/34a0b0030a81698ddb2623ef16fe83b8e3284e0b [^]
Fixes Issue 0039328: Analytics should not have referential integrity with
transactional data
**Remove Foriegn Keys from table
**OBANALY_FACT_DISCOUNTS.xml
**OBANALY_FACT_ORDER
**OBANALY_FACT_SALESORHEADER
---
M src-db/database/model/tables/OBANALY_FACT_DISCOUNTS.xml
M src-db/database/model/tables/OBANALY_FACT_ORDER.xml
M src-db/database/model/tables/OBANALY_FACT_SALESORDHEADER.xml
---
|
|
|
(0110226)
|
hgbot
|
2019-03-05 11:47
|
|
|
|
(0110227)
|
hgbot
|
2019-03-05 11:47
|
|
Repository: erp/pmods/org.openbravo.retail.analytics
Changeset: ddb90b1709774e7892aa11f7638f6fa886ebdea1
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Feb 27 16:44:54 2019 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.analytics/rev/ddb90b1709774e7892aa11f7638f6fa886ebdea1 [^]
Fixes Issue 0039328: Analytics should not have referential integrity
with transactional data
**Remove Foriegn Keys from table OBRETAN_FACT_SESSIONS
**Remove Foriegn Keys from client analytics module tables
---
M src-db/database/model/modifiedTables/OBANALY_FACT_DISCOUNTS.xml
M src-db/database/model/modifiedTables/OBANALY_FACT_ORDER.xml
M src-db/database/model/modifiedTables/OBANALY_FACT_SALESORDHEADER.xml
M src-db/database/model/tables/OBRETAN_FACT_SESSIONS.xml
---
|
|
|
|
|
|
|
|