[Mondrian] Specific hierarchies in AggLevel

Pedro Salgueiro pedro.salgueiro at inductiva.pt
Fri Aug 24 05:48:58 EDT 2012


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
>



More information about the Mondrian mailing list