Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0029989
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Modules] Analyticsmajoralways2015-05-22 17:012016-02-11 09:18
ReporterngarciaView Statuspublic 
Assigned Tomtaal 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision9609fcb9bcb0
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned Toalostale
Regression introduced in release
Summary

0029989: It would be fine if Analytics supported more entities with tree structure

DescriptionIt would be fine if Analytics supported more entities with tree structure. Currently the following ones are supported:

- Account
- Organization
- Business Partner Category
- Product Category
- Project

The tables defined as a tree could be supported: Cost center, Campaign ...
Steps To Reproduce*
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0029988 closedngarcia Tree structure is not shown in OB Analytics window although Ignore Tree Hierarchy is not selected 
causes defect 0032195 closedplatform Business Partner/Product dimensions show no data 

-  Notes
(0080170)
mtaal (manager)
2015-09-07 09:48

 For documentation see here:
http://wiki.openbravo.com/wiki/Modules:Analytics_ParentChild#Parent-Child_Relations:_Closure_or_more_efficient_Parent_Column [^]
(0080190)
mtaal (manager)
2015-09-07 13:19

 The subsequent push includes the following:
- it is now possible to use any tree enabled entity in Mondrian as a tree structure
- but it is adviced to always use explicit parentid/ordinal columns, see the docs

The push will add the parentid/ordinal columns to the cost center table and also add the cost center dimensions to the sales header and details fact table and cube definition.

For other dimensions which don't have an explicit parent/ordinal column, it is adviced to do that in a custom module or enter a new feature request.
(0080191)
hgbot (developer)
2015-09-07 13:22

 Repository: erp/pmods/org.openbravo.client.analytics
Changeset: 9609fcb9bcb0f4a4e67c6e6a7b2f3f0e7e95e8de
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Mon Sep 07 13:21:20 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/9609fcb9bcb0f4a4e67c6e6a7b2f3f0e7e95e8de [^]

Fixes issue 29989: It would be fine if Analytics supported more entities with tree structure
Allow all tree enabled entities as a mondrian tree, add parent/ordinal column to cost center
add cost center to sales header cube

---
M src-db/database/model/tables/OBANALY_FACT_SALESORDHEADER.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/OBANALY_CUBE_DIMENSION.xml
M src/org/openbravo/client/analytics/MondrianSchemaGenerator.java
M src/org/openbravo/client/analytics/OBAnalyticsFactSalesOrderHeaderUpdater.java
---
(0080297)
hgbot (developer)
2015-09-09 21:36

 Repository: erp/pmods/org.openbravo.client.analytics
Changeset: d3f5cef9a32957039062c94a12bdbd43bdd61bcc
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Wed Sep 09 21:36:36 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/d3f5cef9a32957039062c94a12bdbd43bdd61bcc [^]

Related to issue 29989: It would be fine if Analytics supported more entities with tree structure
Removed duplicate index, renamed index to be below 30 characters

---
M src-db/database/model/tables/OBANALY_FACT_ORDER.xml
M src-db/database/model/tables/OBANALY_FACT_SALESORDHEADER.xml
---
(0080301)
hgbot (developer)
2015-09-09 23:34

 Repository: erp/pmods/org.openbravo.client.analytics
Changeset: f80196223d9bad9349f46ce3692d80050a8e86e8
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Wed Sep 09 23:33:58 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/f80196223d9bad9349f46ce3692d80050a8e86e8 [^]

Related to issue 29989: It would be fine if Analytics supported more entities with tree structure
Add treeordinal/parentid to c_costcenter

---
A src-db/database/model/modifiedTables/C_COSTCENTER.xml
---
(0080573)
alostale (manager)
2015-09-23 11:53

 Code reviewed + tested

Published new version 1.2.300 including this new feature

- Issue History
Date Modified Username Field Change
2015-05-22 17:01 ngarcia New Issue
2015-05-22 17:01 ngarcia Assigned To => platform
2015-05-22 17:01 ngarcia Relationship added related to 0029988
2015-05-22 17:06 ngarcia Issue Monitored: networkb
2015-05-25 12:42 jonalegriaesarte Resolution time => 1435183200
2015-05-25 12:44 jonalegriaesarte Resolution time 1435183200 =>
2015-05-25 12:44 jonalegriaesarte Type defect => feature request
2015-09-07 09:48 mtaal Note Added: 0080170
2015-09-07 13:19 mtaal Note Added: 0080190
2015-09-07 13:22 mtaal Review Assigned To => alostale
2015-09-07 13:22 hgbot Checkin
2015-09-07 13:22 hgbot Note Added: 0080191
2015-09-07 13:22 hgbot Status new => resolved
2015-09-07 13:22 hgbot Resolution open => fixed
2015-09-07 13:22 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/9609fcb9bcb0f4a4e67c6e6a7b2f3f0e7e95e8de [^]
2015-09-09 21:36 hgbot Checkin
2015-09-09 21:36 hgbot Note Added: 0080297
2015-09-09 23:34 hgbot Checkin
2015-09-09 23:34 hgbot Note Added: 0080301
2015-09-23 11:53 alostale Note Added: 0080573
2015-09-23 11:53 alostale Status resolved => closed
2016-02-11 08:24 alostale Relationship added causes 0032195
2016-02-11 09:18 alostale Assigned To platform => mtaal

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker