Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029989ModulesAnalyticspublic2015-05-22 17:012016-02-11 09:18
Reporterngarcia 
Assigned Tomtaal 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toalostale
Support ticket
OBNetwork customer
Regression introduced in release
Summary0029989: 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*
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0029988 closed ngarcia Tree structure is not shown in OB Analytics window although Ignore Tree Hierarchy is not selected 
causes defect 0032195 closed platform Business Partner/Product dimensions show no data 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-05-22 17:01ngarciaNew Issue
2015-05-22 17:01ngarciaAssigned To => platform
2015-05-22 17:01ngarciaRelationship addedrelated to 0029988
2015-05-22 17:06ngarciaIssue Monitored: networkb
2015-05-25 12:42jonalegriaesarteResolution time => 1435183200
2015-05-25 12:44jonalegriaesarteResolution time1435183200 =>
2015-05-25 12:44jonalegriaesarteTypedefect => feature request
2015-09-07 09:48mtaalNote Added: 0080170
2015-09-07 13:19mtaalNote Added: 0080190
2015-09-07 13:22mtaalReview Assigned To => alostale
2015-09-07 13:22hgbotCheckin
2015-09-07 13:22hgbotNote Added: 0080191
2015-09-07 13:22hgbotStatusnew => resolved
2015-09-07 13:22hgbotResolutionopen => fixed
2015-09-07 13:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/9609fcb9bcb0f4a4e67c6e6a7b2f3f0e7e95e8de [^]
2015-09-09 21:36hgbotCheckin
2015-09-09 21:36hgbotNote Added: 0080297
2015-09-09 23:34hgbotCheckin
2015-09-09 23:34hgbotNote Added: 0080301
2015-09-23 11:53alostaleNote Added: 0080573
2015-09-23 11:53alostaleStatusresolved => closed
2016-02-11 08:24alostaleRelationship addedcauses 0032195
2016-02-11 09:18alostaleAssigned Toplatform => mtaal

Notes
(0080170)
mtaal   
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   
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   
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   
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   
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   
2015-09-23 11:53   
Code reviewed + tested

Published new version 1.2.300 including this new feature