Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039148ModulesAnalyticspublic2018-08-17 08:272018-09-03 09:40
Reporterdmiguelez 
Assigned Tocaristu 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
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
Support ticket
OBNetwork customer
Regression introduced in release
Summary0039148: 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]]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
caused by defect 0038688 closed caristu Filter is showing more records than expected for some dimensions 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-08-17 08:27dmiguelezNew Issue
2018-08-17 08:27dmiguelezAssigned To => Triage Finance
2018-08-17 08:27dmiguelezRegression level => Production - Confirmed Stable
2018-08-17 08:27dmiguelezResolution time => 1536271200
2018-08-17 10:44dmiguelezRegression date => 2018-06-01
2018-08-17 10:44dmiguelezRegression introduced by commit => https://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/179ac60fc8a4 [^]
2018-08-17 10:44dmiguelezRegression levelProduction - Confirmed Stable => Pre packaging ( pi )
2018-08-17 10:44dmiguelezAssigned ToTriage Finance => platform
2018-08-17 10:44dmiguelezCategoryMulti-Dimensional Profit And Loss => Analytics
2018-08-17 10:44dmiguelezDescription Updatedbug_revision_view_page.php?rev_id=17538#r17538
2018-08-17 10:54ngarciaIssue Monitored: ngarcia
2018-08-20 13:36martinsdanIssue Monitored: martinsdan
2018-08-22 12:00ngarciaRelationship addedcaused by 0038688
2018-08-23 16:05caristuAssigned Toplatform => caristu
2018-08-23 16:09caristuStatusnew => scheduled
2018-08-23 16:13caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=17562#r17562
2018-08-27 09:13hgbotCheckin
2018-08-27 09:13hgbotNote Added: 0106487
2018-08-27 09:13hgbotStatusscheduled => resolved
2018-08-27 09:13hgbotResolutionopen => fixed
2018-08-27 09:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/de413f358398dd76683003bb9020430d6b7e2db5 [^]
2018-08-27 09:14caristuReview Assigned To => alostale
2018-08-27 09:48caristuNote Added: 0106488
2018-08-31 09:05caristuReview Assigned Toalostale => AugustoMauch
2018-09-03 09:40AugustoMauchNote Added: 0106580
2018-09-03 09:40AugustoMauchStatusresolved => closed

Notes
(0106487)
hgbot   
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   
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   
2018-09-03 09:40   
Code reviewed and verified