Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0039148
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Analyticscriticalalways2018-08-17 08:272018-09-03 09:40
ReporterdmiguelezView Statuspublic 
Assigned Tocaristu 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionde413f358398
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date2018-06-01
Regression introduced by commithttps://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/179ac60fc8a4 [^]
Regression levelPre packaging ( pi )
Review Assigned ToAugustoMauch
Regression introduced in release
Summary

0039148: Data is not shown in report. An error is raised

DescriptionData is not shown in report. An error is raised, making the report unusable.

It seems to be a problem on how the dimension is created, before it was:
[organization].[0].[19404EAD144C49A0AF37D54377CF452D].[2E60544D37534C0B89E765FE29BC0B43]
And now it seems to be:
[organization].[organization].[0].[19404EAD144C49A0AF37D54377CF452D].[2E60544D37534C0B89E765FE29BC0B43]
Steps To ReproduceWith Multi-Dimensional Profit and Loss Module installed

Log in as System Administrator
Go to Cube Definition Window and select the record with the name: DPL - P&L Template
Click on Generate Cubes and select F&B International Group as the Client
Click on Done

Log out and log in as F&B Admin

Go to Cube Definition Window and select the record with the name: DPL - P&L - F&B International Group US_A_US Dollar
Move to Cube Reports || Cube Report Dimension || Cube Report Dimension Element and add a new record with:
  - Show: Member and Children
  - Account: PL - Profit & Loss
  - Exclude: No

Go to process request window and create a new record with:
  - Client: F&B International Group
  - Organization: *
  - Process: Update Time Dimension Refs + Tree Closure Table
  - Timing: Run Immediately
Schedule the process and wait until it finishes successfully (~1min 15 secs)

Create another record with:
  - Client: F&B International Group
  - Organization: *
  - Process: Generate Profit And Loss Fact Acct
  - Timing: Run Immediately
Schedule the process and wait until it finishes successfully (~2 mins)

Go to Multi-Dimensional Profit And Loss Window and select:
  - Organization: F&B US
  - General Ledger: F&B International Group US/A/US Dollar
  - Year: 2017
Click on Done

A Pop Up is shown with Error Loading Query.
In the Log:
Caused by: org.saiku.olap.util.exception.QueryParseException: Unable to find a member with name [[organization], [0], [19404EAD144C49A0AF37D54377CF452D], [2E60544D37534C0B89E765FE29BC0B43]]
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
caused by defect 0038688 closedcaristu Filter is showing more records than expected for some dimensions 

-  Notes
(0106487)
hgbot (developer)
2018-08-27 09:13

 Repository: erp/pmods/org.openbravo.client.analytics
Changeset: de413f358398dd76683003bb9020430d6b7e2db5
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Mon Aug 27 09:02:29 2018 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/de413f358398dd76683003bb9020430d6b7e2db5 [^]

fixes bug 39148: Handle Org entity properly when getting the client/org filter

  This changeset[1] was not complete because it was not taking into account the Organization entity. Although its access level its ALL, the client filter should not be included for the Organization entity. Otherwise the organization '0' is not retrieved by mondrian when calculating the children members of the Organization dimension. This affected some reports avoiding to properly generate the query that calculates its information.


[1] https://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/179ac60fc8a4 [^]

---
M src/org/openbravo/client/analytics/mondrian/Mondrian4SchemaGenerator.java
---
(0106488)
caristu (manager)
2018-08-27 09:48

 Published version 1.4.1002 with the fix: http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/ForgeModuleVersionDetail?moduleVersionId=7A833DC4581246ECA7AE66BABD7114CA [^]
(0106580)
AugustoMauch (administrator)
2018-09-03 09:40

 Code reviewed and verified

- Issue History
Date Modified Username Field Change
2018-08-17 08:27 dmiguelez New Issue
2018-08-17 08:27 dmiguelez Assigned To => Triage Finance
2018-08-17 08:27 dmiguelez Regression level => Production - Confirmed Stable
2018-08-17 08:27 dmiguelez Resolution time => 1536271200
2018-08-17 10:44 dmiguelez Regression date => 2018-06-01
2018-08-17 10:44 dmiguelez Regression introduced by commit => https://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/179ac60fc8a4 [^]
2018-08-17 10:44 dmiguelez Regression level Production - Confirmed Stable => Pre packaging ( pi )
2018-08-17 10:44 dmiguelez Assigned To Triage Finance => platform
2018-08-17 10:44 dmiguelez Category Multi-Dimensional Profit And Loss => Analytics
2018-08-17 10:44 dmiguelez Description Updated View Revisions
2018-08-17 10:54 ngarcia Issue Monitored: ngarcia
2018-08-20 13:36 martinsdan Issue Monitored: martinsdan
2018-08-22 12:00 ngarcia Relationship added caused by 0038688
2018-08-23 16:05 caristu Assigned To platform => caristu
2018-08-23 16:09 caristu Status new => scheduled
2018-08-23 16:13 caristu Steps to Reproduce Updated View Revisions
2018-08-27 09:13 hgbot Checkin
2018-08-27 09:13 hgbot Note Added: 0106487
2018-08-27 09:13 hgbot Status scheduled => resolved
2018-08-27 09:13 hgbot Resolution open => fixed
2018-08-27 09:13 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/de413f358398dd76683003bb9020430d6b7e2db5 [^]
2018-08-27 09:14 caristu Review Assigned To => alostale
2018-08-27 09:48 caristu Note Added: 0106488
2018-08-31 09:05 caristu Review Assigned To alostale => AugustoMauch
2018-09-03 09:40 AugustoMauch Note Added: 0106580
2018-09-03 09:40 AugustoMauch Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker