Using CalculatedMembers in Aggregated tables with mondrian 2.4.2

205 Views Asked by At

I'm trying to set up custom aggregated tables in our mondrian data warehouse. I defined the custom aggregated table like this:

<Table>
  <AggName name="..." ...>
    <AggFactCount ...></AggFactCount>
    <AggMeasure name="[Measures].[Example]" column="..."> </AggMeasureName>
  </AggName>
</Table>

As long as [Measures].[Example] points to a <Measure name="Example" column="..." .../> item it works fine. When it points to a <CalculatedMember name="Example" formula="..." ... /> then I get the following error message:

"Failed to find measure 'Example' for Cube 'ExampleCube'"

As far as I checked it online, this thing should be working for recent versions. We're using mondrian 2.4.2 which supports only Measures in AggregatedTables.

Is there any workaround, sg. like defining a cache-table? Maybe is it enough to provide a configuration item?

Thanks, Tamas

0

There are 0 best solutions below