Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034158ModulesAnalyticspublic2016-10-03 13:192016-10-14 09:08
Reporterngarcia 
Assigned Tocaristu 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date2016-03-31
Regression introduced by commithttps://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/6cd0a6359890 [^]
Regression levelProduction - QA Approved
Review Assigned Toalostale
Support ticket
OBNetwork customer
Regression introduced in release
Summary0034158: Keep Only and Keep and Include Level options do not work for trees in OB Analytics window
DescriptionKeep Only and Keep and Include Level options do not work for trees in OB Analytics window
Steps To ReproduceAs group admin role:
   Open OB Analytics window
   Select the Sample Purchase/Sales Order Line Cube
   Add Line Net Amount as a measure
   Add Organization as dimension
   Click on one organization, select Keep Only option and check the output is not modified

The same happens for the Keep and Include Level feature
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
caused by feature request 0032215 closed caristu upgrade analytics stack 
has duplicate defect 0034159 closed caristu Keep and Include Level is not working for 'Period - Year' dimension 
related to design defect 0034167 new Triage Platform Base Show Children option is not available in OB Analytics window 
related to defect 0035394 closed inigosanchez Keep Only and Keep and Include Level options do not work for trees in Dimensional Reports and widgets 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-10-03 13:19ngarciaNew Issue
2016-10-03 13:19ngarciaAssigned To => platform
2016-10-03 13:19ngarciaResolution time => 1477260000
2016-10-03 13:28ngarciaIssue Monitored: networkb
2016-10-03 13:38ngarciaRelationship addedrelated to 0034159
2016-10-03 16:41jfrancesIssue Monitored: jfrances
2016-10-03 19:32caristuStatusnew => scheduled
2016-10-03 19:32caristuAssigned Toplatform => caristu
2016-10-04 08:58hgbotCheckin
2016-10-04 08:58hgbotNote Added: 0090467
2016-10-04 08:58hgbotStatusscheduled => resolved
2016-10-04 08:58hgbotResolutionopen => fixed
2016-10-04 08:58hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/ea82267324ca08dbb03522bdf61a964be740a2e7 [^]
2016-10-04 09:02hgbotCheckin
2016-10-04 09:02hgbotNote Added: 0090468
2016-10-04 09:07caristuReview Assigned To => alostale
2016-10-04 09:12caristuNote Added: 0090470
2016-10-04 09:28caristuSummaryShow Children option is not available and Keep Only option does not work for trees in OB Analytics window => Keep Only and Keep and Include Level options do not work for trees in OB Analytics window
2016-10-04 09:28caristuDescription Updatedbug_revision_view_page.php?rev_id=13315#r13315
2016-10-04 09:28caristuNote Deleted: 0090470
2016-10-04 09:29caristuRelationship replacedhas duplicate 0034159
2016-10-04 09:31caristuRelationship addedrelated to 0034167
2016-10-04 09:33caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=13321#r13321
2016-10-04 09:38caristuRegression introduced by commit => https://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/6cd0a6359890 [^]
2016-10-04 09:38caristuRegression level => Production - QA Approved
2016-10-04 09:38caristuResolution time1477260000 => 1461708000
2016-10-04 09:38caristuRelationship addedcaused by 0032215
2016-10-10 10:20caristuRegression date => 2016-03-31
2016-10-10 10:22caristuIssue Monitored: alostale
2016-10-14 08:24alostaleResolution time1461708000 => 1477260000
2016-10-14 08:44alostaleNote Added: 0090564
2016-10-14 08:44alostaleStatusresolved => closed
2016-10-14 09:08alostaleNote Added: 0090571
2017-03-01 12:38ngarciaRelationship addedduplicate of 0035394
2017-03-15 10:26inigosanchezRelationship replacedrelated to 0035394

Notes
(0090467)
hgbot   
2016-10-04 08:58   
Repository: erp/pmods/org.openbravo.client.analytics
Changeset: ea82267324ca08dbb03522bdf61a964be740a2e7
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Tue Oct 04 08:54:28 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/ea82267324ca08dbb03522bdf61a964be740a2e7 [^]

fixes issue 34158: Keep Only and Keep and Include Level options are not working

By default Saiku is checking the caption to retrieve the level of a hierarchy for the Keep Only and Keep and Include Level features. In Openbravo Analytics the hierarchies are named in a special way to ensure backwards compatibility with the MDX queries.

For this reason, we are adding an extra check in order to look for the property name also. This way we are able to retrieve the level from the workspace query.

---
M web/org.openbravo.client.analytics/saiku/js/saiku/views/Table.js
---
(0090468)
hgbot   
2016-10-04 09:02   
Repository: erp/pmods/org.openbravo.client.analytics
Changeset: 840cd9246240de0a0ac11723a669b7976bb89a57
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Tue Oct 04 09:01:27 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/840cd9246240de0a0ac11723a669b7976bb89a57 [^]

related to issue 34158: Safer check if hierarchy is not found

---
M web/org.openbravo.client.analytics/saiku/js/saiku/views/Table.js
---
(0090564)
alostale   
2016-10-14 08:44   
code reviewed + tested
(0090571)
alostale   
2016-10-14 09:08   
Published version 1.4.300
http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/sso/ForgeModuleVersionDetail?moduleVersionId=115816D1606545BEB9EF33CC12908BED [^]