Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034197ModulesMulti-Dimensional Profit And Losspublic2016-10-13 12:462016-11-04 15:30
Reporterngarcia 
Assigned Tomarkmm82 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toaferraz
Support ticket
OBNetwork customer
Regression introduced in release
Summary0034197: Cannot launch the multi-dimensional profit and loss report if the fiscal calendar does not match the natural calendar
DescriptionCannot launch the multi-dimensional profit and loss report if the fiscal calendar does not match the natural calendar
Steps To ReproduceAs group admin role:
   Create a new Fiscal Calendar
   Set April-16 as its first period and March-17 as its last period
   Create a new legal with accounting organization as child of F&B International Group
   Open the periods
   Create a Simple G/L Journal using subaccounts that belong to P&L
   Complete and post it
As system admin role:
   Create the DPL cubes from template
   Schedule the Update Time Dimension Refs + Tree Closure Table to run immediately
As group admin role:
   Schedule the Generate Profit And Loss Fact Acct process to run immediately
   Go to Multi-Dimensional Profit and Loss window
   Select the previously created organization and year
   Leave the Period From and Period To empty
   Check the Use Fiscal Calendar option
   Click on Done and check a pop-up is Shown with: Error Loading Query
   The log shows:

3838966 [http-7080-1] ERROR org.saiku.web.rest.resources.Query2Resource - Error creating new query
org.saiku.olap.util.exception.QueryParseException: Unable to find a member with name [[period-year-dimension], [37135913149F4FE7BE7F3F06BD371391.0]]
    at org.saiku.olap.query.QueryDeserializer.createQmQuery(QueryDeserializer.java:170)
    at org.saiku.olap.query.QueryDeserializer.unparse(QueryDeserializer.java:85)
    at org.saiku.service.olap.ThinQueryService.convertQuery(ThinQueryService.java:715)
    at org.openbravo.client.analytics.saiku.OBSaikuQueryService.convertQuery(OBSaikuQueryService.java:163)
...
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0032802 closed caristu Multi-Dimensional Profit And Loss should be compatible with new Analytics stack 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-10-13 12:46ngarciaNew Issue
2016-10-13 12:46ngarciaAssigned To => Triage Finance
2016-10-13 12:46ngarciaResolution time => 1478127600
2016-10-13 12:46ngarciaIssue Monitored: networkb
2016-10-13 16:57vmromanosAssigned ToTriage Finance => markmm82
2016-10-13 17:00markmm82Statusnew => scheduled
2016-10-16 22:46eugeniIssue Monitored: eugeni
2016-10-20 18:33markmm82Note Added: 0090736
2016-11-04 14:50aferrazRelationship addedrelated to 0032802
2016-11-04 15:20hgbotCheckin
2016-11-04 15:20hgbotNote Added: 0091181
2016-11-04 15:20hgbotStatusscheduled => resolved
2016-11-04 15:20hgbotResolutionopen => fixed
2016-11-04 15:20hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalpandlreport/rev/eacd26a8320dc937f46d52969efa9aa6e05c5954 [^]
2016-11-04 15:20hgbotCheckin
2016-11-04 15:20hgbotNote Added: 0091182
2016-11-04 15:28hgbotCheckin
2016-11-04 15:28hgbotNote Added: 0091183
2016-11-04 15:30aferrazReview Assigned To => aferraz
2016-11-04 15:30aferrazNote Added: 0091184
2016-11-04 15:30aferrazStatusresolved => closed

Notes
(0090736)
markmm82   
2016-10-20 18:33   
As group admin role:
   Create a new Fiscal Calendar
   Set April-16 as its first period and March-17 as its last period
   Create a new legal with accounting organization as child of F&B International Group
   Open the periods
   Create a Simple G/L Journal using subaccounts that belong to P&L
   Complete and post it
As system admin role:
   Create the DPL cubes from template
   Schedule the Update Time Dimension Refs + Tree Closure Table to run immediately
As group admin role:
   Schedule the Generate Profit And Loss Fact Acct process to run immediately
   Go to Multi-Dimensional Profit and Loss window
   Select the previously created organization and year
   Leave the Period From and Period To empty
   Check the Use Fiscal Calendar option
   Click on Done and check the report is shown correctly with the previously Simple G/L
(0091181)
hgbot   
2016-11-04 15:20   
Repository: erp/pmods/org.openbravo.financial.dimensionalpandlreport
Changeset: eacd26a8320dc937f46d52969efa9aa6e05c5954
Author: Mark <markmm82 <at> gmail.com>
Date: Fri Nov 04 15:01:40 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalpandlreport/rev/eacd26a8320dc937f46d52969efa9aa6e05c5954 [^]

Fixes issue 34197: Fix multi-dimensional profit and loss report

Remove .0 when adding an ID to the node. 0 should only be added when adding a date to the node.

---
M src/org/openbravo/financial/dimensionalpandlreport/ProfitAndLossActionHandler.java
---
(0091182)
hgbot   
2016-11-04 15:20   
Repository: erp/pmods/org.openbravo.financial.dimensionalpandlreport
Changeset: 1ccac357dbd38ec634f0fd6bcf8ff8ba6f4babdb
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Fri Nov 04 15:18:05 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalpandlreport/rev/1ccac357dbd38ec634f0fd6bcf8ff8ba6f4babdb [^]

Related to issue 34197: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0091183)
hgbot   
2016-11-04 15:28   
Repository: erp/pmods/org.openbravo.financial.dimensionalpandlreport
Changeset: 7dc57c18ada6d3748686bde70a1c0d034077a66d
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Fri Nov 04 15:25:01 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalpandlreport/rev/7dc57c18ada6d3748686bde70a1c0d034077a66d [^]

Related to issue 34197: Fix module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0091184)
aferraz   
2016-11-04 15:30   
Code review + Testing OK