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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0032195
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Analyticsmajoralways2016-02-11 08:232016-02-16 14:06
ReporteralostaleView Statuspublic 
Assigned Toplatform 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision06fd91ccddac
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commithttp://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/9609fcb9bcb0f4a4e67c6e6a7b2f3f0e7e95e8de [^]
Regression levelCoding ( Testing )
Review Assigned Tomtaal
Regression introduced in release
Summary

0032195: Business Partner/Product dimensions show no data

DescriptionWhen a cube defines a dimension for Business Partner or Product using for it a property in the fact table being a FK to C_BPartner or M_Product, it cannot be used: no data is shown.

The problem is Business Partner and Product dimensions are treated as a tree since patch for 0029989. Though there are trees for these entities in default Openbravo, they do not get populated, therefore the query is performed assuming data is the the tree table returning no results.
Steps To Reproduce1. Open OB Analytics window
2. Select Sales Details Fact cube (any other cube with Product or Business Partner dimensions has the same problem)

2.1. Add "Quantity" in Columns and "Business Partner" in Rows
  This MDX is generated
    SELECT
    NON EMPTY {Hierarchize({[Measures].[Quantity]})} ON COLUMNS,
    NON EMPTY {Hierarchize({[businessPartner].[businessPartnerLevel].Members})} ON ROWS
    FROM [D47E1F393C00496E826A0A0F462F2A93]
      -> ERROR: No data is shown

2.2. Add "Quantity" in Columns and "Product" in Rows
  This MDX is generated
    SELECT
    NON EMPTY {Hierarchize({[Measures].[Quantity]})} ON COLUMNS,
    NON EMPTY {Hierarchize({[product].[productLevel].Members})} ON ROWS
    FROM [D47E1F393C00496E826A0A0F462F2A93]
      -> ERROR: No data is shown
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
caused by feature request 0029989 closedmtaal It would be fine if Analytics supported more entities with tree structure 

-  Notes
(0084092)
hgbot (developer)
2016-02-11 09:08

 Repository: erp/pmods/org.openbravo.client.analytics
Changeset: 06fd91ccddac64894e93ae36f9360976b2a24aff
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Feb 11 09:03:39 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/06fd91ccddac64894e93ae36f9360976b2a24aff [^]

fixed issue 32195: Business Partner/Product dimensions show no data

  Data was not shown for those dimensions because they were treated as trees even
  ad_tree does not get populated for them.

  The fix:
   - Adds new API to define entities that, even having an associated tree, should
     not be generated as tree.
   - Adds Product and BP entities to the tree ignored entities.

---
M src/org/openbravo/client/analytics/OBAnalyticsUtils.java
M src/org/openbravo/client/analytics/OBOlapClosureTreeHandler.java
---
(0084093)
alostale (manager)
2016-02-11 09:17

 Published 1.2.500 fixing this issue.

http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/sso/ForgeModuleVersionDetail?moduleVersionId=E642C1D6404648159594F0ACCFC444AF [^]
(0084251)
mtaal (manager)
2016-02-16 14:06

 Reviewed

- Issue History
Date Modified Username Field Change
2016-02-11 08:23 alostale New Issue
2016-02-11 08:23 alostale Assigned To => platform
2016-02-11 08:24 alostale Regression introduced by commit => http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/9609fcb9bcb0f4a4e67c6e6a7b2f3f0e7e95e8de [^]
2016-02-11 08:24 alostale Regression level => Coding ( Testing )
2016-02-11 08:24 alostale Resolution time => 1441576800
2016-02-11 08:24 alostale Review Assigned To => mtaal
2016-02-11 08:24 alostale Relationship added caused by 0029989
2016-02-11 08:38 alostale Summary Business Partner dimension show no data => Business Partner/Product dimensions show no data
2016-02-11 08:38 alostale Description Updated View Revisions
2016-02-11 08:38 alostale Steps to Reproduce Updated View Revisions
2016-02-11 09:08 hgbot Checkin
2016-02-11 09:08 hgbot Note Added: 0084092
2016-02-11 09:08 hgbot Status new => resolved
2016-02-11 09:08 hgbot Resolution open => fixed
2016-02-11 09:08 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/06fd91ccddac64894e93ae36f9360976b2a24aff [^]
2016-02-11 09:17 alostale Note Added: 0084093
2016-02-11 09:22 alostale Description Updated View Revisions
2016-02-16 14:06 mtaal Note Added: 0084251
2016-02-16 14:06 mtaal Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker