Skip to main content
Pentaho Documentation

Level

Level of a hierarchy.

Attributes

Attribute Data type Definition
approxRowCount String The estimated number of members in this level. Setting this property improves the performance of MDSCHEMA_LEVELS, MDSCHEMA_HIERARCHIES and MDSCHEMA_DIMENSIONS XMLA requests
name String  
table String The name of the table that the column comes from. If this hierarchy is based upon just one table, defaults to the name of that table; otherwise, it is required. Can be localized from Properties file using #{propertyname}.
column String The name of the column which holds the unique identifier of this level.
nameColumn String The name of the column which holds the user identifier of this level.
ordinalColumn String The name of the column which holds member ordinals. If this column is not specified, the key column is used for ordering.
parentColumn String The name of the column which references the parent member in a parent-child hierarchy.
nullParentValue String Value which identifies null parents in a parent-child hierarchy. Typical values are 'NULL' and '0'.
type String Indicates the type of this level's key column: String, Numeric, Integer, Boolean, Date, Time or Timestamp. When generating SQL statements, Mondrian encloses values for String columns in quotation marks, but leaves values for Integer and Numeric columns un-quoted. Date, Time, and Timestamp values are quoted according to the SQL dialect. For a SQL-compliant dialect, the values appear prefixed by their typename, for example, "DATE '2006-06-01'".
uniqueMembers Boolean Whether members are unique across all parents. For example, zipcodes are unique across all states. The first level's members are always unique.
levelType String Whether this is a regular or a time-related level. The value makes a difference to time-related functions such as YTD (year-to-date).
hideMemberIf String Condition which determines whether a member of this level is hidden. If a hierarchy has one or more levels with hidden members, then it is possible that not all leaf members are the same distance from the root, and it is termed a ragged hierarchy.
formatter String Name of a formatter class for the member labels being displayed. The class must implement the mondrian.olap.MemberFormatter interface. Allowable values are: Never (a member always appears; the default); IfBlankName (a member doesn't appear if its name is null or empty); and IfParentsName (a member appears unless its name matches the parent's.
caption String A string being displayed instead of the level's name. Can be localized from Properties file using #{propertyname}.
captionColumn String The name of the column which holds the caption for members.

Constituent elements

Element Definition
KeyExpression The SQL expression used to populate this level's key.
NameExpression The SQL expression used to populate this level's name. If not specified, the level's key is used.
OrdinalExpression The SQL expression used to populate this level's ordinal.
ParentExpression The SQL expression used to join to the parent member in a parent-child hierarchy.
Closure  
Property