Formula |
Class used for modeling metric sets defined using formulas.
Inheritance HierarchySystemObject
Dundas.BI.FileSystemFileSystemEntry
Dundas.BI.FileSystemFile
Dundas.BI.EntitiesEntityBase
Dundas.BI.Entities.MetricSetsMetricSet
Dundas.BI.Entities.MetricSetsFormulaMetricSet
Dundas.BI.FileSystemFileSystemEntry
Dundas.BI.FileSystemFile
Dundas.BI.EntitiesEntityBase
Dundas.BI.Entities.MetricSetsMetricSet
Dundas.BI.Entities.MetricSetsFormulaMetricSet
Namespace: Dundas.BI.Entities.MetricSets
Assembly: Dundas.BI.Core (in Dundas.BI.Core.dll) Version: 2.0.0.0 (26.2.0.1000)
SyntaxThe FormulaMetricSet type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | FormulaMetricSet(String, String) | Initializes a new instance of the FormulaMetricSet class. |
| FormulaMetricSet(String, String, String, IEnumerableMetricSetUsage) | Initializes a new instance of the FormulaMetricSet class. |
Properties| Name | Description | |
|---|---|---|
 | Alignment | Gets or sets the script alignment behavior. |
| AllChildren |
Gets a flat list of all files and folders in the entry and all of the entry's descendants.
(Inherited from FileSystemEntry) |
| AllChildrenAndSelf | Gets the entry and all of its descendants. (Inherited from FileSystemEntry) |
| AllFiles |
Gets a flat list of all files in the entry and all of the entry's descendants.
(Inherited from FileSystemEntry) |
| AllFilesAndSelf |
Gets the file and all of its child files.
(Inherited from File) |
| AllFolders |
Gets a flat list of all folders in the entry and all of the entry's descendants.
(Inherited from FileSystemEntry) |
| AnalysisStructureId |
Gets the ID of the analysis structure on which the current instance is based.
(Inherited from MetricSet) |
| AnalysisStructureType |
Gets the type of the analysis structure on which the current instance is based.
(Inherited from MetricSet) |
| AxisHierarchies |
Gets the axis hierarchies.
(Inherited from MetricSet) |
| CheckedOutTo |
Gets information about the account to which the object is checked out.
(Inherited from File) |
| ChildCount | Gets the number of direct children contained in the entry. (Inherited from FileSystemEntry) |
| Children | Gets the files and subfolders contained in the entry. (Inherited from FileSystemEntry) |
| ColumnHierarchies |
Gets the column hierarchies usage information.
(Inherited from MetricSet) |
| CreatedBy |
Gets the account information for the user which created the entry.
(Inherited from FileSystemEntry) |
| CreatedTime |
Gets the time, in coordinated universal time (UTC), at which the entry was created.
(Inherited from FileSystemEntry) |
| CurrentRevision | Gets the highest revision number associated with this file. (Inherited from File) |
| DataRetrievalFormat |
Gets or sets the data retrieval format.
(Inherited from MetricSet) |
| DerivedMeasures |
Gets the derived measures.
(Inherited from MetricSet) |
| Description |
Gets an optional description associated with the entry.
(Inherited from FileSystemEntry) |
| DrillDownParameter |
Gets the member drill down information.
(Overrides MetricSetDrillDownParameter) |
| Elements |
Gets all the elements usage information.
(Inherited from MetricSet) |
| EnforceHierarchyCubeCheck | Gets or sets a value indicating whether the parent cubes of the hierarchies are also checked when determining hierarchy compatibilities. |
| EntitySaveOptions | Gets or sets the entity save options. (Inherited from MetricSet) |
| Files |
Gets the files contained in the entry.
(Inherited from FileSystemEntry) |
| Fingerprint | Gets the fingerprint of the revision. (Inherited from EntityBase) |
| Folders | Gets the folders contained in the entry. (Inherited from FileSystemEntry) |
| FriendlyFullName |
Gets the full path of the entry (friendly).
(Inherited from FileSystemEntry) |
| FriendlyLocation |
Gets the location of the entry (friendly representation).
(Inherited from FileSystemEntry) |
| FriendlyLocationElements |
Gets a read-only list of distinct path elements which compose FriendlyLocation.
(Inherited from FileSystemEntry) |
| FriendlyName | Gets the name of the entry (friendly representation). (Inherited from FileSystemEntry) |
| FullName |
Gets the full path of the entry.
(Inherited from FileSystemEntry) |
| HasWarnings |
Gets a value indicating whether this instance,or one of its dependencies, has warnings.
(Inherited from MetricSet) |
| HierarchyMemberGroups |
Gets the custom hierarchy member groups.
(Inherited from MetricSet) |
| Id |
Gets the unique identifier of the entry.
(Inherited from FileSystemEntry) |
| IsCheckedOut | Gets a value indicating whether the file is checked out. (Inherited from File) |
| IsCheckedOutToCaller |
Gets a value indicating whether the file is checked out to caller.
(Inherited from File) |
| IsCustomLocalizationApplied | Gets or sets a value indicating whether a custom localization applied on this entity. (Inherited from EntityBase) |
| IsFolder | Gets a value indicating whether the entry is a folder. (Inherited from FileSystemEntry) |
| IsInactive |
Gets a value indicating whether the file is inactive.
(Inherited from File) |
| IsProtected | Gets a value indicating whether the entry is protected. (Inherited from FileSystemEntry) |
| IsRecycled | Gets a value indicating whether the entry is recycled. (Inherited from FileSystemEntry) |
| IsRecycledDirectly | Gets a value indicating whether the entry is recycled directly and not as a part of parent entry recycling. (Inherited from FileSystemEntry) |
| IsRelationshipsAvailable |
Gets a value indicating whether the current instance is based on a data flow the user is allowed to modify.
(Inherited from MetricSet) |
| IsResultTransposed |
Gets or sets a value indicating whether the current instance requires the result to be transposed.
(Inherited from MetricSet) |
| IsSubentry |
Gets a value indicating whether the entry is contained by a File.
(Inherited from FileSystemEntry) |
| IsTemporary |
Gets a value indicating whether the entry resides under a temporary folder.
(Inherited from FileSystemEntry) |
| IsTenantIdAvailable |
Gets a value indicating whether the TenantId property can be accessed without throwing an exception.
(Inherited from FileSystemEntry) |
| IsTransient | Gets a value indicating whether the file is transient. (Inherited from File) |
| LastCheckedInTime | Gets the time when the file was last checked in. (Inherited from File) |
| LastModifiedTime |
Gets the time, in coordinated universal time (UTC), at which the entry was last modified.
(Inherited from FileSystemEntry) |
| Location | Gets the location of the entry. (Inherited from FileSystemEntry) |
| Measures |
Gets the measures usage information.
(Inherited from MetricSet) |
| Metadata | Gets arbitrary metadata associated with the entry. (Inherited from FileSystemEntry) |
| Name |
Gets the name of the entry.
(Inherited from FileSystemEntry) |
| ObjectType |
Gets the type of the entry.
(Inherited from FileSystemEntry) |
| OtherGroupSettings |
Gets the "Other" group settings for the current instance, if available.
(Inherited from MetricSet) |
| Parameters |
Gets all the parameters exposed by the metric set.
(Inherited from MetricSet) |
| ParentId |
Gets the ID of the item's parent.
(Inherited from FileSystemEntry) |
| PreventDataExport |
Gets or sets a value indicating whether the metric set's data can be exported to Excel or CSV.
(Inherited from MetricSet) |
| PrimaryEntryId | Gets the ID of the primary object which contains the entry. (Inherited from FileSystemEntry) |
| PrivilegeInheritanceBehavior |
Gets the privilege inheritance behavior.
(Inherited from FileSystemEntry) |
| Privileges |
Gets the entry's privilege assignments.
(Inherited from FileSystemEntry) |
| ProjectId |
Gets the ID of the project containing the entry.
(Inherited from FileSystemEntry) |
| QueryHintValues |
Gets the query hint values for the current instance.
(Inherited from MetricSet) |
| References |
Gets information about which other entities are directly referenced by this instance.
(Inherited from EntityBase) |
| Revision | Gets the revision of this instance. (Inherited from EntityBase) |
| RevisionComment | Gets the check-in comment associated with the revision. (Inherited from EntityBase) |
| RevisionCreatedBy | Gets information about the account which checked-in (or created) the revision. (Inherited from EntityBase) |
| RevisionCreatedTime | Gets the time when the revision was checked in (or created). (Inherited from EntityBase) |
| RowHierarchies |
Gets the row hierarchies usage information.
(Inherited from MetricSet) |
| ShownTotals |
Gets or sets the value indicating what totals are requested.
(Inherited from MetricSet) |
| SlicerHierarchies |
Gets the slicer hierarchies usage information.
(Inherited from MetricSet) |
| StateGroups |
Gets the state groups.
(Inherited from MetricSet) |
| Subtype | Gets or sets the type-specific sub-type of the entry. (Inherited from FileSystemEntry) |
| Tags |
Gets a collection of explicit tags associated with the entry.
(Inherited from FileSystemEntry) |
| TenantId |
Gets the ID of the tenant associated with the entry.
(Inherited from FileSystemEntry) |
| TopBottomSettings |
Gets the top / bottom settings for the current instance, if available.
(Inherited from MetricSet) |
| VersionCode |
Gets a number representing the current version of the file system entry's database record.
(Inherited from FileSystemEntry) |
| Visualization |
Gets or sets the visualization. This is stored as a string (JSON for JavaScript) for efficiency purposes.
(Inherited from MetricSet) |
| Warnings |
Gets the warnings for the current instance, as well as for any dependency objects.
(Inherited from MetricSet) |
Methods| Name | Description | |
|---|---|---|
| AddCalculatedHierarchy |
Add a new script hierarchy, based on a Dundas statement that combines existing measures and possible numeric parameters.
(Inherited from MetricSet) |
| AddCalculatedMeasure(MeasureUsage, MetricSetUsage) | Add a new measure to the current instance. The measure must belong to one of the already defined dependencies. |
| AddCalculatedMeasure(String, String, String) |
Add a new script measure, based on a Dundas statement that combines existing measures and possible numeric parameters.
(Inherited from MetricSet) |
| AddCalculatedMeasure(String, String, String, IEnumerableMetricSetUsage) | Add a new calculated measure to the current instance. |
| AddColumnHierarchy |
Adds a new column hierarchy and automatically links any corresponding generic dependency parameters to the current usage element parameters.
(Overrides MetricSetAddColumnHierarchy(IHierarchy)) |
| AddContextualMeasure |
Add a new contextual measure. The user is responsible for entering contextual measure data.
(Inherited from MetricSet) |
| AddCountHierarchyMeasure(IHierarchy) |
Add a new measure, based on the count or distinct count of a specified hierarchy members.
(Inherited from MetricSet) |
| AddCountHierarchyMeasure(IHierarchyLevel) |
Add a new measure, based on the count or distinct count of a specified hierarchy level members.
(Inherited from MetricSet) |
| AddCountMeasure |
Adds an automatic count measure.
(Inherited from MetricSet) |
| AddDynamicHierarchy |
Adds a new dynamic hierarchy to the current instance.
(Inherited from MetricSet) |
| AddDynamicMeasure |
Adds a new dynamic measure to the current instance.
(Inherited from MetricSet) |
| AddHierarchy | Adds a new hierarchy and automatically links any corresponding parameters of the dependency with the specified name to the current usage element parameters. |
| AddMeasure |
Add a new measure to the current instance. The measure must belong to one of the already defined dependencies.
(Overrides MetricSetAddMeasure(IMeasure)) |
| AddParallelPeriodMeasure(String, MeasureUsage, HierarchyUsage) |
Add a new parallel period measure, based on an existing metric set measure.
(Overrides MetricSetAddParallelPeriodMeasure(String, MeasureUsage, HierarchyUsage)) |
| AddParallelPeriodMeasure(String, MeasureUsage, ITimeHierarchyLevel, Int32) |
Add a new parallel period measure, based on an existing metric set measure.
(Overrides MetricSetAddParallelPeriodMeasure(String, MeasureUsage, ITimeHierarchyLevel, Int32)) |
| AddParallelSlicedMeasure |
Add a new parallel sliced measure, based on an existing measure.
(Overrides MetricSetAddParallelSlicedMeasure(String, MeasureUsage)) |
| AddQueryOptimizationHint |
Adds the appropriate query optimization value for the specified provider query hint ID.
(Inherited from MetricSet) |
| AddRowHierarchy |
Adds a new row hierarchy and automatically links any corresponding generic dependency parameters to the current usage element parameters.
(Overrides MetricSetAddRowHierarchy(IHierarchy)) |
| AddSlicerHierarchy |
Adds a new slicer hierarchy and automatically links any corresponding generic dependency parameters to the current usage element parameters.
(Overrides MetricSetAddSlicerHierarchy(IHierarchy)) |
| AddStateGroup(String, String) |
Adds a new state group, linked to all the metric set measures.
(Inherited from MetricSet) |
| AddStateGroup(MeasureUsage, String, String) |
Adds a new state group, linked to the specified measure.
(Inherited from MetricSet) |
| ChangeHierarchyPlacement |
Changes the hierarchy placement.
(Inherited from MetricSet) |
| ConfigureSortPriorities |
Configures the sorting priorities for the current instance.
The method allows changing the index position on the corresponding axis for all the metric set elements, thus reflecting the new sorting priorities.
(Inherited from MetricSet) |
| GetAnalysisStructure |
Gets the analysis structure on which the current instance is based.
(Inherited from MetricSet) |
| HideParameter | Sets the script metric set inherited parameter as private, and assigns it the specified default value. |
| LinkParameters(Parameter, Parameter) | Sets the linked parameter as private and links its values to the source parameter. |
| LinkParameters(Parameter, IEnumerableParameter) | Sets all the linked parameters as private and links their values to the source parameter. |
| MoveElementBefore |
Moves the source element before the target element in the metric set element collection.
(Inherited from MetricSet) |
| RemoveAllHierarchyGroups |
Removes all hierarchy groups.
(Inherited from MetricSet) |
| RemoveAnalysisElement |
Removes the specified usage element.
(Inherited from MetricSet) |
| RemoveCustomHierarchyGroup |
Removes the specified custom hierarchy group.
(Inherited from MetricSet) |
| RemoveOtherGroupSettings |
Removes the existing "Other" group settings.
(Inherited from MetricSet) |
| RemoveQueryOptimizationHint |
Removes the query optimization hint.
(Inherited from MetricSet) |
| RemoveQueryOptimizationHints |
Removes the query optimization hints.
(Inherited from MetricSet) |
| RemoveStateGroup |
Removes the state group.
(Inherited from MetricSet) |
| RemoveTopBottomSettings |
Removes the existing top / bottom settings.
(Inherited from MetricSet) |
| ReplaceElement |
Replaces the original usage element with the analysis element, if the categories are compatible.
The target element is removed.
(Overrides MetricSetReplaceElement(AnalysisElementUsage, IAnalysisElement)) |
| SetupOtherGroupSettings |
Creates an "Other" group settings for the current instance, using the specified measure. Any previous settings are cleared.
(Inherited from MetricSet) |
| SetupTopBottomSettings |
Creates a new top / bottom settings for the current instance, using the specified measure. Any previous settings are cleared.
(Inherited from MetricSet) |
| ToString | Returns a string that represents the current object. (Inherited from FileSystemEntry) |
See Also