Class CalculationGroupTable

Inheritance

object

DynamicPropertyObject

TabularObject

TabularNamedObject

Table

CalculationGroupTable

Implements

ICustomTypeDescriptor

INotifyPropertyChanging

IComparable

IDescriptionObject

ILineageTagObject

IExtendedPropertyObject

ITabularPerspectiveObject

IHideableObject

ITranslatableObject

IAnnotationObject

ISynonymObject

IClonableObject

ITabularObjectContainer

IDaxObject

IDaxDependantObject

IExpressionObject

ITabularNamedObject

ITabularObject

INotifyPropertyChanged

INamedObject

ITomErrorMessageObject

Inherited Members

Table.ClearAnnotations()

Table.GetAnnotation(int)

Table.HasAnnotation(string)

Table.GetAnnotation(string)

Table.SetAnnotation(int, string)

Table.GetNewAnnotationName()

Table.SetAnnotation(string, string)

Table.RemoveAnnotation(string)

Table.GetAnnotationsCount()

Table.GetAnnotations()

Table.ClearExtendedProperties()

Table.HasExtendedProperty(string)

Table.GetExtendedPropertyType(int)

Table.GetExtendedPropertyType(string)

Table.GetExtendedProperty(int)

Table.GetExtendedProperty(string)

Table.SetExtendedProperty(int, string, ExtendedPropertyType)

Table.GetNewExtendedPropertyName()

Table.SetExtendedProperty(string, string, ExtendedPropertyType)

Table.RemoveExtendedProperty(string)

Table.GetExtendedPropertyCount()

Table.GetExtendedProperties()

Table.Clone(string, bool)

Table.AddMeasure(string, string, string, IInsertOptions)

Table.AddPartition(string, string)

Table.AddMPartition(string, string)

Table.AddPolicyRangePartition(string)

Table.AddEntityPartition(string, string)

Table.AddCalculatedColumn(string, string, string, IInsertOptions)

Table.AddDataColumn(string, string, string, DataType, IInsertOptions)

Table.AddHierarchy(string, string, IInsertOptions, params Column[])

Table.AddHierarchy(string, string, params string[])

Table.AddHierarchy(string, string, params Column[])

Table.AddHierarchy(string, string, IInsertOptions, params string[])

Table.Children_CollectionChanged(object, NotifyCollectionChangedEventArgs)

Table.OnPropertyChanging(string, object, ref bool, ref bool)

Table.OnPropertyChanged(string, object, object)

Table.AddRefreshPolicy()

Table.RemoveRefreshPolicy()

Table.CustomReinit()

Table.ApplyRefreshPolicy(DateTime)

Table.ApplyRefreshPolicy()

Table.Annotations

Table.ExtendedProperties

Table.DataCategory

Table.Description

Table.IsHidden

Table.ShowAsVariationsOnly

Table.IsPrivate

Table.AlternateSourcePrecedence

Table.ExcludeFromModelRefresh

Table.LineageTag

Table.SourceLineageTag

Table.SystemManaged

Table.ExcludeFromAutomaticAggregations

Table.InPerspective

Table.TranslatedDescriptions

Table.TranslatedNames

Table.Synonyms

Table.Parent

Table.Sets

Table.Partitions

Table.Columns

Table.Hierarchies

Table.Measures

Table.IsVisible

Table.TableGroup

Table.DependsOn

Table.ReferencedBy

Table.AllLevels

Table.UsedInRelationships

Table.DataColumns

Table.CalculatedColumns

Table.RelatedTables

Table.Source

Table.SourceType

Table.RowLevelSecurity

Table.DaxObjectName

Table.DaxObjectFullName

Table.DaxTableName

Table.ObjectLevelSecurity

Table.DefaultDetailRowsExpression

Table.RefreshPolicy

Table.Mode

Table.PolicyType

Table.RollingWindowGranularity

Table.RollingWindowPeriods

Table.IncrementalGranularity

Table.IncrementalPeriods

Table.IncrementalPeriodsOffset

Table.PollingExpression

Table.SourceExpression

Table.EnableRefreshPolicy

Table.DefaultExpressionProperty

TabularNamedObject.AllowDelete(out string)

TabularNamedObject.CanEditName()

TabularNamedObject.CanDelete()

TabularNamedObject.CanDelete(out string)

TabularNamedObject.Delete()

TabularNamedObject.CompareTo(object)

TabularNamedObject.MetadataIndex

TabularNamedObject.MetadataObject

TabularNamedObject.Name

TabularObject.SetValue(object, object, Action<object>, string)

TabularObject.SetValue<T>(T, T, Action<T>, string)

TabularObject.IsRemoved

TabularObject.Model

TabularObject.ObjectTypeName

TabularObject.PropertyChanged

TabularObject.PropertyChanging

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Namespace

TabularEditor.TOMWrapper

Assembly

TOMWrapper.dll

Calculation Group Tables are special tables that only contain a single column

public class CalculationGroupTable : Table, ICustomTypeDescriptor, INotifyPropertyChanging, IComparable, IDescriptionObject, ILineageTagObject, IExtendedPropertyObject, ITabularPerspectiveObject, IHideableObject, ITranslatableObject, IAnnotationObject, ISynonymObject, IClonableObject, ITabularObjectContainer, IDaxObject, IDaxDependantObject, IExpressionObject, ITabularNamedObject, ITabularObject, INotifyPropertyChanged, INamedObject, ITomErrorMessageObject

Extension Methods

ScriptHelper.Output(object)

DaxDependencyHelper.Tokenize(IDaxDependantObject)

DaxDependencyHelper.Tokenize(IDaxDependantObject, bool)

DaxDependencyHelper.Tokenize(IDaxDependantObject, ExpressionProperty)

DaxDependencyHelper.Tokenize(IDaxDependantObject, ExpressionProperty, bool)

TabularObjectContainerHelper.GetChildrenRecursive(ITabularObjectContainer, bool)

Properties

CalculationGroup

The Calculation Group object owned by this Calculation Group Table

public CalculationGroup CalculationGroup { get; }

Property Value

Type	Description
CalculationGroup

CalculationGroupAnnotations

Annotations on the Calculation Group object.

public AnnotationCollection CalculationGroupAnnotations { get; }

Property Value

Type	Description
AnnotationCollection

CalculationGroupDescription

The description of the Calculation Group object.

public string CalculationGroupDescription { get; set; }

Property Value

Type	Description
string

CalculationGroupPrecedence

When multiple Calculation Groups are used as a filter condition, this property determines the order of evaluation.

public int CalculationGroupPrecedence { get; set; }

Property Value

Type	Description
int

CalculationItems

The collection of CalculationItem items on the CalculationGroup of this table.

public CalculationItemCollection CalculationItems { get; }

Property Value

Type	Description
CalculationItemCollection

ErrorMessage

Gets the error message currently reported on this calculation group table.

public override string ErrorMessage { get; }

Property Value

Type	Description
string

MultipleOrEmptySelectionDescription

The description of the CalculationGroupExpression, visible to developers at design time and to administrators in management tools, such as SQL Server Management Studio.

public string MultipleOrEmptySelectionDescription { get; set; }

Property Value

Type	Description
string

MultipleOrEmptySelectionExpression

The expression defined on this object will be applied to the selected measure in DAX queries, when multiple calculation items are aplied.

public string MultipleOrEmptySelectionExpression { get; set; }

Property Value

Type	Description
string

MultipleOrEmptySelectionFormatStringExpression

The format string expression defined on this object will be applied to the selected measure in DAX queries, when multiple calculation items are aplied.

public string MultipleOrEmptySelectionFormatStringExpression { get; set; }

Property Value

Type	Description
string

NoSelectionExpression

The expression defined on this object will be applied to the selected measure in DAX queries, when no calculation items are applied.

public string NoSelectionExpression { get; set; }

Property Value

Type	Description
string

NoSelectionExpressionDescription

The description of the CalculationGroupExpression, visible to developers at design time and to administrators in management tools, such as SQL Server Management Studio.

public string NoSelectionExpressionDescription { get; set; }

Property Value

Type	Description
string

NoSelectionFormatStringExpression

The format string expression defined on this object will be applied to the selected measure in DAX queries, when no calculation items are applied.

public string NoSelectionFormatStringExpression { get; set; }

Property Value

Type	Description
string

ObjectType

The type of this object (Folder, Measure, Table, etc.).

public override ObjectType ObjectType { get; }

Property Value

Type	Description
ObjectType

Reordering

Set to true, when multiple calculation items are going to be re-ordered as one action.

[Browsable(false)]
public bool Reordering { get; }

Property Value

Type	Description
bool

Methods

AddCalculationItem(string, string)

Adds a calculation item with the given name and expression to the calculation group table.

public CalculationItem AddCalculationItem(string name = null, string expression = null)

Parameters

Type	Name	Description
string	name
string	expression

Returns

Type	Description
CalculationItem

CompactLevelOrdinals()

public void CompactLevelOrdinals()

CreateNew(Model, string)

public static CalculationGroupTable CreateNew(Model parent, string name = null)

Parameters

Type	Name	Description
Model	parent
string	name

Returns

Type	Description
CalculationGroupTable

FixItemOrder(CalculationItem, int)

public void FixItemOrder(CalculationItem item, int newOrdinal)

Parameters

Type	Name	Description
CalculationItem	item
int	newOrdinal

GetChildren()

Returns all columns, measures, and hierarchies inside this table.

public override IEnumerable<ITabularNamedObject> GetChildren()

Returns

Type	Description
IEnumerable<ITabularNamedObject>

GetExpression(ExpressionProperty)

Gets the specified expression from the current object.

public override string GetExpression(ExpressionProperty expressionProperty)

Parameters

Type	Name	Description
ExpressionProperty	expressionProperty

Returns

Type	Description
string

Exceptions

InvalidEnumArgumentException

Thrown when the current object does not support the specified ExpressionProperty

GetExpressionProperties()

Gets all supported expression properties on the current object.

public override IEnumerable<ExpressionProperty> GetExpressionProperties()

Returns

Type	Description
IEnumerable<ExpressionProperty>

Init()

Derived members should override this method to instantiate child objects

protected override void Init()

SetExpression(ExpressionProperty, string)

Sets the specified expression on the current object.

public override void SetExpression(ExpressionProperty expressionProperty, string expression)

Parameters

Type	Name	Description
ExpressionProperty	expressionProperty
string	expression

Exceptions

InvalidEnumArgumentException

Thrown when the current object does not support the specified ExpressionProperty

SetItemOrder(IList<CalculationItem>)

public void SetItemOrder(IList<CalculationItem> order)

Parameters

Type	Name	Description
IList<CalculationItem>	order