[Mondrian] Specific hierarchies in AggLevel

Pedro Alves pmgalves at gmail.com
Thu Aug 23 12:56:02 EDT 2012



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



More information about the Mondrian mailing list