[Mondrian] Specific hierarchies in AggLevel

[Pedro Alves]

And does it work as expected?



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