In the Mondrian document, it refers to that we can combine closure and aggregate tables with a trick in Mondrian's internal.
Now that i have a cube with structure like the below.
Dimensions: [DIM_WAP_FUNC_ADD], with level [WAP_FUNC_OP_LEVEL] – a parent-child hierarchy
Fact Table: FACT_TOUCH_ACCESS_D(op_id,pv)
Closure Table: WAP_FUNC_OP_LEVEL_closure(id,parent_id,depth)
aggregation table: AGG_TOUCH_ACCESS_OP_PARENT(PV_COLUMN,PARENT_COLUMN,FACT_COUNT)
then , i create a aggregate like this:
<AggPattern pattern="AGG_TOUCH_ACCESS_OP.*" ignorecase="true">
<AggMeasure column="PV_COLUMN" name="[Measures].[pv]">
<AggLevel column="PARENT_COLUMN" name="[WAP_FUNC_OP_LEVEL$Closure].[parent_id]" collapsed="false">
while executing it , i received the error log like "The Hierarchy 'WAP_FUNC_OP_LEVEL$Closure' does not exist" and can't view the cube.