[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