Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032970ModulesMulti-Dimensional Profit And Losspublic2016-05-17 11:192016-05-20 08:48
Reporterngarcia 
Assigned Tocaristu 
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 customerOBPS
Regression introduced in release
Summary0032970: Cannot launch Multi-Dimensional Profit And Loss if the Account is included as Member and Children
DescriptionCannot launch Multi-Dimensional Profit And Loss if the Account is included as Member and Children
Steps To ReproduceAs system admin role:
   Install the Multi-Dimensional Profit And Loss module
   Create the cubes from the templates
   Launch the Update Time Reference... background process
As group admin role:
   Configure the 'PYG - Pérdidas y ganancias' account in the Cube Definition window for 'DPL - P&L - F&B España, S.A. US_A_Euro' cube and 'PL - Profit & Loss' for 'DPL - P&L - F&B International Group US_A_US Dollar' cube
   Set both as Show = Member and Children (Cube Report Dimension Element tab)
   Launch the Generate Profit And Loss Fact Acct background process
   Go to Multi-dimensional Profit and Loss window and launch the report
   A pop-up appears with Error loading query message
   The log shows:
ERROR org.saiku.web.rest.resources.Query2Resource - Error creating new query
org.saiku.olap.util.exception.SaikuIncompatibleException: Cannot convert member selection using operator: CHILDREN
      
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0037100 acknowledged Triage Platform Base Multi-Dimensional Profit and Loss shows information collapsed 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-05-17 11:19ngarciaNew Issue
2016-05-17 11:19ngarciaAssigned To => Triage Finance
2016-05-17 11:19ngarciaResolution time => 1466719200
2016-05-17 11:19ngarciaOBNetwork customer => Yes
2016-05-17 11:19ngarciaAssigned ToTriage Finance => caristu
2016-05-17 11:19ngarciaIssue Monitored: networkb
2016-05-17 15:55caristuStatusnew => scheduled
2016-05-17 15:59caristuNote Added: 0086502
2016-05-17 19:38hgbotCheckin
2016-05-17 19:38hgbotNote Added: 0086508
2016-05-17 19:38hgbotStatusscheduled => resolved
2016-05-17 19:38hgbotResolutionopen => fixed
2016-05-17 19:38hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalreports/rev/b3c7a6bd32cccb849466e698e044518ba5284320 [^]
2016-05-17 19:38caristuReview Assigned To => alostale
2016-05-20 08:48alostaleNote Added: 0086590
2016-05-20 08:48alostaleStatusresolved => closed
2017-10-18 11:23maiteRelationship addedrelated to 0037100

Notes
(0086502)
caristu   
2016-05-17 15:59   
The problem seems to be on Saiku's QueryConverter class. It can not convert query models with Selections having type = "member" and an operator different from MEMBER (like CHILDREN in this case).
(0086508)
hgbot   
2016-05-17 19:38   
Repository: erp/pmods/org.openbravo.financial.dimensionalreports
Changeset: b3c7a6bd32cccb849466e698e044518ba5284320
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Tue May 17 19:37:06 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalreports/rev/b3c7a6bd32cccb849466e698e044518ba5284320 [^]

fixes issue 32970: Error if the Account is included as Member and Children
Saiku's QueryConverter does not allow to have Selections defined with type='member' and operator='CHILDREN'. To avoid this problem, when using the 'CHILDREN' operator the member type is set as 'level'.

---
M src/org/openbravo/financial/dimensionalreports/DimensionalReportsUtils.java
---
(0086590)
alostale   
2016-05-20 08:48   
code reviewed + tested