Attributes

Attribute	Data Type	Definition
approxRowCount	String	The estimated number of members in this level. Setting this property improves the performance ofMDSCHEMA_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.