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

Pedro Alves pmgalves at gmail.com
Wed Aug 22 15:51:31 EDT 2012


Tried both ways. I do have it

<Dimension type="StandardDimension" highCardinality="false" 
name="Locations">
<!--<Hierarchy hasAll="false" defaultMember="[Locations].[Worldwide]" 
primaryKey="d_statcounter_location_tk">-->
<Hierarchy hasAll="true" allMemberName="All" 
primaryKey="d_statcounter_location_tk">
<Table name="d_statcounter_location"></Table>
<Level name="Location" column="country" type="String" 
uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
<!--<Property name="Type" column="territorytype"/>-->
</Level>
</Hierarchy>
</Dimension>



On 08/22/2012 08:35 PM, Paul Stoellberger wrote:
> 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
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>


More information about the Mondrian mailing list