[Mondrian] 300 sql queries on a 'simple' query , or , AxisMemberList.getTopParent behaving weird

Paul Stoellberger p.stoellberger at gmail.com
Wed Aug 22 15:35:52 EDT 2012


do you have an all member in your hierarchy? no idea if thats relevant though




Am 22.08.2012 um 20:33 schrieb Pedro Alves <pmgalves at gmail.com>:

> 
> 
> In pentaho master:
> 
> The query:
> 
> SELECT NON EMPTY [Browsers].[Major].Members ON COLUMNS,
> [Locations].[Location].Members ON ROWS FROM [Market Share]
> 
> 
> does 230 sql queries, one for each member of locations.location.
> 
> 
> SELECT NON EMPTY [Store].[Store Country].Members ON COLUMNS,
> [Product].[Product Name].Members ON ROWS FROM [Warehouse]
> 
> on steelwheels does not.
> 
> 
> After a day of debugging, I traced the issue to 
> AxisMemberList.getTopParent that's called from AxisMemberList.mergeMember.
> 
> 
> On foodmart, every [Product].[Product Name] member has [Product].[All 
> Products] as the getTopParent.
> 
> 
> On mine, every location has itself as the top parent, resulting in an 
> axisMembers (on RolapResults) with 230 elements. Foodmart example has 
> only 2 ([Store].[All Stores],[Products].[All Products])
> 
> 
> What am I missing? What causes the getTopParent to return null?
> 
> 
> 
> -pedro
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian


More information about the Mondrian mailing list