Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and Pentaho Documentation

AggTable

Parent article

A definition of an aggregate table for a base fact table. This aggregate table must be in the same schema as the base fact table.

Attributes

AttributeData TypeDefinition
ignorecaseBooleanWhether or not the match should ignore case.

Constituent Elements

ElementDefinition
AggFactCountDescribes what the fact_count column looks like.
AggIgnoreColumnTells Mondrian to ignore a column in an aggregate table.
AggForeignKeyMaps a foreign key in the fact table to a foreign key column in the candidate aggregate table.
AggMeasureMaps a measure to a column in the candidate aggregate table.
AggLevelMaps a level to a column in the candidate aggregate table.