Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0034197 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Modules] Multi-Dimensional Profit And Loss | major | always | 2016-10-13 12:46 | 2016-11-04 15:30 | |||
| Reporter | ngarcia | View Status | public | |||||
| Assigned To | markmm82 | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | eacd26a8320d | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Regression date | ||||||||
| Regression introduced by commit | ||||||||
| Regression level | ||||||||
| Review Assigned To | aferraz | |||||||
| Regression introduced in release | ||||||||
| Summary | 0034197: Cannot launch the multi-dimensional profit and loss report if the fiscal calendar does not match the natural calendar | |||||||
| Description | Cannot launch the multi-dimensional profit and loss report if the fiscal calendar does not match the natural calendar | |||||||
| Steps To Reproduce | 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 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) ... | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0090736) markmm82 (developer) 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 (developer) 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 (developer) 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 (developer) 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 (manager) 2016-11-04 15:30 |
Code review + Testing OK |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2016-10-13 12:46 | ngarcia | New Issue | |
| 2016-10-13 12:46 | ngarcia | Assigned To | => Triage Finance |
| 2016-10-13 12:46 | ngarcia | Resolution time | => 1478127600 |
| 2016-10-13 12:46 | ngarcia | Issue Monitored: networkb | |
| 2016-10-13 16:57 | vmromanos | Assigned To | Triage Finance => markmm82 |
| 2016-10-13 17:00 | markmm82 | Status | new => scheduled |
| 2016-10-16 22:46 | eugeni | Issue Monitored: eugeni | |
| 2016-10-20 18:33 | markmm82 | Note Added: 0090736 | |
| 2016-11-04 14:50 | aferraz | Relationship added | related to 0032802 |
| 2016-11-04 15:20 | hgbot | Checkin | |
| 2016-11-04 15:20 | hgbot | Note Added: 0091181 | |
| 2016-11-04 15:20 | hgbot | Status | scheduled => resolved |
| 2016-11-04 15:20 | hgbot | Resolution | open => fixed |
| 2016-11-04 15:20 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalpandlreport/rev/eacd26a8320dc937f46d52969efa9aa6e05c5954 [^] |
| 2016-11-04 15:20 | hgbot | Checkin | |
| 2016-11-04 15:20 | hgbot | Note Added: 0091182 | |
| 2016-11-04 15:28 | hgbot | Checkin | |
| 2016-11-04 15:28 | hgbot | Note Added: 0091183 | |
| 2016-11-04 15:30 | aferraz | Review Assigned To | => aferraz |
| 2016-11-04 15:30 | aferraz | Note Added: 0091184 | |
| 2016-11-04 15:30 | aferraz | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |