Skip to main content
Hitachi Vantara Lumada and Pentaho Documentation


A fact or dimension table.


AttributeData TypeDefinition
nameStringThe name of the table
schemaStringOptional qualifier for table
aliasStringAlias to be used with this table when it is used to form queries. If not specified, defaults to the table name, but in any case, must be unique within the schema. You can use the same table in different hierarchies, but it must have different aliases.

Constituent Elements

SQLThe SQL WHERE clause expression to be appended to any select statement
AggExcludeExclude a candidate aggregate table by name or pattern matching
AggTableA definition of an aggregate table for a base fact table.