Class Level
- Inheritance
-
Level
- Implements
- Inherited Members
- Namespace
- TabularEditor.TOMWrapper
- Assembly
- TOMWrapper.dll
Represents a level in a hierarchy that provides a logical hierarchical drilldown path for client applications. It is a child of a Hierarchy object. The level is based on the values in a column.
public sealed class Level : TabularNamedObject, ICustomTypeDescriptor, INotifyPropertyChanging, IComparable, IDescriptionObject, ILineageTagObject, IChangedPropertiesObject, IExtendedPropertyObject, ITranslatableObject, IAnnotationObject, ISynonymObject, IClonableObject, ITabularTableObject, ITabularNamedObject, ITabularObject, INotifyPropertyChanged, IHandlerObject, INamedObject
- Extension Methods
Properties
Annotations
The collection of Annotations on the current Level.
[Browsable(true)]
public AnnotationCollection Annotations { get; }
Property Value
Type | Description |
---|---|
AnnotationCollection |
ChangedProperties
Gets or sets a comma-separated list of names of properties that should no longer be synchronized from the source.
[Browsable(false)]
public string ChangedProperties { get; set; }
Property Value
Type | Description |
---|---|
string |
Column
A reference to a Column object associated with this Level.
[TypeConverter(typeof(HierarchyColumnConverter))]
public Column Column { get; set; }
Property Value
Type | Description |
---|---|
Column |
Description
The description of the level, visible to developers at design time and to administrators in management tools, such as SQL Server Management Studio.
public string Description { get; set; }
Property Value
Type | Description |
---|---|
string |
ExtendedProperties
The collection of Extended Properties on the current Level.
public ExtendedPropertyCollection ExtendedProperties { get; }
Property Value
Type | Description |
---|---|
ExtendedPropertyCollection |
Hierarchy
A reference to a Hierarchy object that owns this level.
[Browsable(false)]
public Hierarchy Hierarchy { get; }
Property Value
Type | Description |
---|---|
Hierarchy |
LineageTag
A tag that represents the lineage of the object.
public string LineageTag { get; set; }
Property Value
Type | Description |
---|---|
string |
Remarks
Lineage tags enable stable identification of objects across different semantic models. Using lineage tags enables Power BI features such as composite models to maintain their binding to referenced tables or columns, even if the source semantic model object is renamed.
This property is only supported when the compatibility level of the database is at 1540 or above.
Ordinal
The position of the level within the hierarchy. The levels in the hierarchy must be properly ordered, starting with 1 and increasing monotonically.
public int Ordinal { get; set; }
Property Value
Type | Description |
---|---|
int |
Parent
The parent Hierarchy of the current Level.
public Hierarchy Parent { get; }
Property Value
Type | Description |
---|---|
Hierarchy |
SourceLineageTag
A tag that represents the lineage of the source for the object.
public string SourceLineageTag { get; set; }
Property Value
Type | Description |
---|---|
string |
Remarks
This property is only supported when the compatibility level of the database is at 1550 or above.
Synonyms
Collection of localized synonyms for this Level.
[Browsable(true)]
public SynonymIndexer Synonyms { get; }
Property Value
Type | Description |
---|---|
SynonymIndexer |
Table
[Browsable(false)]
public Table Table { get; }
Property Value
Type | Description |
---|---|
Table |
TranslatedDescriptions
Collection of localized descriptions for this Level.
[Browsable(true)]
public TranslationIndexer TranslatedDescriptions { get; }
Property Value
Type | Description |
---|---|
TranslationIndexer |
TranslatedNames
Collection of localized names for this Level.
[Browsable(true)]
public TranslationIndexer TranslatedNames { get; }
Property Value
Type | Description |
---|---|
TranslationIndexer |
Methods
ClearAnnotations()
Removes all annotations from this object.
public void ClearAnnotations()
ClearChangedProperties()
Clears the list of names of changed properties.
public void ClearChangedProperties()
ClearExtendedProperties()
Removes all Extended Properties from this object.
public void ClearExtendedProperties()
Clone(string, bool, Hierarchy)
Creates an exact copy of this Level object.
public Level Clone(string newName = null, bool includeTranslations = true, Hierarchy newParent = null)
Parameters
Type | Name | Description |
---|---|---|
string | newName | |
bool | includeTranslations | |
Hierarchy | newParent |
Returns
Type | Description |
---|---|
Level |
CreateNew(Hierarchy, string)
Creates a new Level and adds it to the parent Hierarchy. Also creates the underlying metadataobject and adds it to the TOM tree.
public static Level CreateNew(Hierarchy parent, string name = null)
Parameters
Type | Name | Description |
---|---|---|
Hierarchy | parent | |
string | name |
Returns
Type | Description |
---|---|
Level |
GetAnnotation(int)
Gets the value of the annotation with the given index, assuming it exists.
public string GetAnnotation(int index)
Parameters
Type | Name | Description |
---|---|---|
int | index |
Returns
Type | Description |
---|---|
string |
GetAnnotation(string)
Gets the value of the annotation with the given name. Returns null if no such annotation exists.
public string GetAnnotation(string name)
Parameters
Type | Name | Description |
---|---|---|
string | name |
Returns
Type | Description |
---|---|
string |
GetAnnotations()
Gets a collection of all annotation names on the current Level.
public IEnumerable<string> GetAnnotations()
Returns
Type | Description |
---|---|
IEnumerable<string> |
GetAnnotationsCount()
Gets the number of annotations on the current Level.
public int GetAnnotationsCount()
Returns
Type | Description |
---|---|
int |
GetExtendedProperties()
Gets a collection of all ExtendedProperty names on the current object.
public IEnumerable<string> GetExtendedProperties()
Returns
Type | Description |
---|---|
IEnumerable<string> |
GetExtendedProperty(int)
Gets the value of the ExtendedProperty with the given index, assuming it exists.
public string GetExtendedProperty(int index)
Parameters
Type | Name | Description |
---|---|---|
int | index |
Returns
Type | Description |
---|---|
string |
GetExtendedProperty(string)
Gets the value of the ExtendedProperty with the given name. Returns null if no such ExtendedProperty exists.
public string GetExtendedProperty(string name)
Parameters
Type | Name | Description |
---|---|---|
string | name |
Returns
Type | Description |
---|---|
string |
GetExtendedPropertyCount()
Gets the number of ExtendedProperties on the current object.
public int GetExtendedPropertyCount()
Returns
Type | Description |
---|---|
int |
GetExtendedPropertyType(int)
Gets the type of the ExtendedProperty with the given index, assuming it exists.
public ExtendedPropertyType GetExtendedPropertyType(int index)
Parameters
Type | Name | Description |
---|---|---|
int | index |
Returns
Type | Description |
---|---|
ExtendedPropertyType |
GetExtendedPropertyType(string)
Gets the type of the ExtendedProperty with the given name, assuming it exists.
public ExtendedPropertyType GetExtendedPropertyType(string name)
Parameters
Type | Name | Description |
---|---|---|
string | name |
Returns
Type | Description |
---|---|
ExtendedPropertyType |
GetNewAnnotationName()
Returns a unique name for a new annotation.
public string GetNewAnnotationName()
Returns
Type | Description |
---|---|
string |
GetNewExtendedPropertyName()
Returns a unique name for a new ExtendedProperty.
public string GetNewExtendedPropertyName()
Returns
Type | Description |
---|---|
string |
HasAnnotation(string)
Returns true if an annotation with the given name exists. Otherwise false.
public bool HasAnnotation(string name)
Parameters
Type | Name | Description |
---|---|---|
string | name |
Returns
Type | Description |
---|---|
bool |
HasExtendedProperty(string)
Returns true if an ExtendedProperty with the given name exists. Otherwise false.
public bool HasExtendedProperty(string name)
Parameters
Type | Name | Description |
---|---|---|
string | name |
Returns
Type | Description |
---|---|
bool |
OnPropertyChanged(string, object, object)
Fired after a property is changed
protected override void OnPropertyChanged(string propertyName, object oldValue, object newValue)
Parameters
Type | Name | Description |
---|---|---|
string | propertyName | |
object | oldValue | |
object | newValue |
OnPropertyChanging(string, object, ref bool, ref bool)
Called before a property is changed on an object. Derived classes can control how the change is handled. Throw ArgumentException within this method, to display an error message in the UI.
protected override void OnPropertyChanging(string propertyName, object newValue, ref bool undoable, ref bool cancel)
Parameters
Type | Name | Description |
---|---|---|
string | propertyName | Name of the changed property. |
object | newValue | New value assigned to the property. |
bool | undoable | Return false if automatic undo of the property change is not needed. |
bool | cancel | Return true if the property change should not apply. |
RemoveAnnotation(string)
Remove an annotation by the given name.
public void RemoveAnnotation(string name)
Parameters
Type | Name | Description |
---|---|---|
string | name |
RemoveExtendedProperty(string)
Remove an ExtendedProperty by the given name.
public void RemoveExtendedProperty(string name)
Parameters
Type | Name | Description |
---|---|---|
string | name |
SetAnnotation(int, string)
Sets the value of the annotation with the given index, assuming it exists.
public void SetAnnotation(int index, string value)
Parameters
Type | Name | Description |
---|---|---|
int | index | |
string | value |
SetAnnotation(string, string)
Sets the value of the annotation having the given name. If no such annotation exists, it will be created. If value is set to null, the annotation will be removed.
public void SetAnnotation(string name, string value)
Parameters
Type | Name | Description |
---|---|---|
string | name | |
string | value |
SetExtendedProperty(int, string, ExtendedPropertyType)
Sets the value of the ExtendedProperty with the given index, optionally specifiying the type (string or JSON) of the ExtendedProperty.
public void SetExtendedProperty(int index, string value, ExtendedPropertyType type)
Parameters
Type | Name | Description |
---|---|---|
int | index | |
string | value | |
ExtendedPropertyType | type |
SetExtendedProperty(string, string, ExtendedPropertyType)
Sets the value of the ExtendedProperty having the given name. If no such ExtendedProperty exists, it will be created. If value is set to null, the ExtendedProperty will be removed.
public void SetExtendedProperty(string name, string value, ExtendedPropertyType type)
Parameters
Type | Name | Description |
---|---|---|
string | name | |
string | value | |
ExtendedPropertyType | type |