[Mondrian] Specific hierarchies in AggLevel

Pedro Alves pmgalves at gmail.com
Fri Aug 24 06:05:15 EDT 2012



I think that's correct.


Then why is it looking for that fully specified member name in all 
dimensions? Luc? Julian?


-pedro



On Fri 24 Aug 2012 10:48:58 AM WEST, Pedro Salgueiro wrote:
> On 08/24/2012 10:25 AM, Pedro Alves wrote:
>> And does it work as expected?
> Well, I am not sure. After seeing our logs, we can find debug messages
> that looks like yours.
> Still, if we use the specific hierarchy in the MDX, we can see in the
> logs that the aggregate table is being used to solve the query.
>
> Just to confirm, we removed that same hierarchy from the aggregate
> tables, and the same MDX query was not able any-more to use the
> aggregate table.  This shows that the aggregate tables are being used,
> right?
>
> Pedro Salgueiro
>
>
>>
>>
>>
>> On Fri 24 Aug 2012 09:52:34 AM WEST, Pedro Salgueiro wrote:
>>> That seems to be correct.
>>> We are using a specific hierarchy in our aggregate table and its
>>> specified in the same way.
>>>
>>> Pedro Salgueiro
>>>
>>> On 08/23/2012 05:56 PM, Pedro Alves wrote:
>>>> Hello
>>>>
>>>>
>>>> I have this aggName def:
>>>>
>>>>
>>>> <AggName name="opt_a_crashdata_date_countr_version"
>>>> approxRowCount="1927773">
>>>>       <AggFactCount column="f_weblog_crashdata_fact_count"/>
>>>>       <AggMeasure column="f_weblog_crashdata_Total_Crash"
>>>> name="[Measures].[Total Crashes]"/>
>>>>       <AggMeasure column="f_weblog_crashdata_Sessions"
>>>> name="[Measures].[Sessions]"/>
>>>> ...
>>>>       <AggLevel column="d_location_Country" name="[Locations].[Country]"/>
>>>>       <AggLevel column="d_location_Continent"
>>>> name="[Locations.Continents].[Continent]"/>
>>>>       </AggName>
>>>>
>>>>
>>>> However, doesn't seem to correctly pick [Locations.Continents]
>>>> hierarchy. In the logs I see:
>>>>
>>>>
>>>> 2012-08-23 17:38:18,662 DEBUG [mondrian.rolap.RolapSchemaReader] looking
>>>> for child "[Locations.Continents]" of [Dates].[All]
>>>> 2012-08-23 17:38:18,668 DEBUG [mondrian.rolap.RolapSchemaReader]
>>>> NumberFormatException in lookupMemberChildByName for parent =
>>>> "[Dates].[All]", childName="[Locations.Continents]", exception: For
>>>> input string: "Locations.Continents"
>>>> 2012-08-23 17:38:18,668 DEBUG [mondrian.rolap.RolapSchemaReader] looking
>>>> for child "[Locations.Continents]" of [Times].[All]
>>>> 2012-08-23 17:38:18,668 DEBUG [mondrian.rolap.RolapSchemaReader]
>>>> NumberFormatException in lookupMemberChildByName for parent =
>>>> "[Times].[All]", childName="[Locations.Continents]", exception: For
>>>> input string: "Locations.Continents"
>>>> 2012-08-23 17:38:18,668 DEBUG [mondrian.rolap.RolapSchemaReader] looking
>>>> for child "[Locations.Continents]" of [Status].[All]
>>>> 2012-08-23 17:38:18,668 DEBUG [mondrian.rolap.RolapSchemaReader]
>>>> NumberFormatException in lookupMemberChildByName for parent =
>>>> "[Status].[All]", childName="[Locations.Continents]", exception: For
>>>> input string: "Locations.Continents"
>>>> 2012-08-23 17:38:18,669 DEBUG [mondrian.rolap.RolapSchemaReader] looking
>>>> for child "[Locations.Continents]" of [Locales].[All]
>>>>
>>>>
>>>>
>>>> Is this not the correct syntax?
>>>>
>>>> -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
>> _______________________________________________
>> 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