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