[Mondrian] Specific hierarchies in AggLevel

Pedro Salgueiro pedro.salgueiro at inductiva.pt
Fri Aug 24 04:52:34 EDT 2012


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
>



More information about the Mondrian mailing list