[Mondrian] AggTableManager: Two levels share the same foreign key column

[Pedro Alves]

Hello everyone.


I'm defining an aggregate table; I have 2 hierarchies in the same
dimension.


Mondrian is throwing this error:

2009-06-02 19:24:07,837 ERROR [mondrian.rolap.aggmatcher.AggTableManager] BlockList Analysis:PatternTableDef:TableDef: Context 'BlockList Analysis:PatternTableDef:TableDef': Two levels, '[Locations.Countries].[Country name]' and '[Locations].[Country name]', share the same foreign column name 'locations_Country_name'


My mondrian file has this:

<AggLevel column="locations_Continent_name" name="[Locations].[Continent name]"/>
<AggLevel column="locations_Country_name" name="[Locations].[Country name]"/>
<AggLevel column="locations_Region_name" name="[Locations].[Region name]"/>
<AggLevel column="locations_Country_name" name="[Locations.Countries].[Country name]"/>
<AggLevel column="locations_Region_name" name="[Locations.Countries].[Region name]"/>


Since I have 2 different hierarchies - one with and one w/o continent level
- I wanted to use the same agg table for both cases

This is my location table def:

    Table:
      alias=locations
      relation=locations
      Columns:
        Continent name (20): "locations"."continent_name"
        Country name (21): "locations"."country_name"
        Region name (22): "locations"."region_name"
        City (23): "locations"."city_name"
        Continent code (24): "locations"."continent_code"
        Country code (25): "locations"."country_code"
        Region code (26): "locations"."region_code"
      Condition:
        left="blocklist_requests_by_day"."location_id"
        right="locations"."location_id"


Isn't this possible?


Thanks.



-- 
Pedro Alves
pmgalves-at-gmail.com