Level of a hierarchy.
| 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. |
