Assembly: Pivot;
Namespace: Prognoz.Platform.Interop.Pivot;
The IPivot interface contains properties and methods that are used to work with an object that is a base for building a data table.
IPivot
To work with table data, use properties and methods of the IPivotTable interface.
Property name | Brief description | |
ABCColumn | Outdated. The ABCColumn property determines index of the column, by which the 80/20 analysis is executed. | |
ABCRow | Outdated. The ABCRow property determines index of the row, by which the 80/20 analysis is executed. | |
AggregationElement | The AggregationElement property determines the element, by which data is set by dimensions to matrix. | |
BroughtOutDim | The BroughtOutDim property determines a metrics dimension. | |
BroughtOutDimValue | The BroughtOutDimValue property determines index of metrics dimension element on using the Value». | |
BuildWithEmptyHeader | The BuildWithEmptyHeader property returns whether heading or sidehead are built when selection is empty. | |
CalculateDataRights | The CalculateDataRights property determines whether data access permissions should be calculated. | |
DataCacheEnabled | The DataCacheEnabled property returns whether the user works with cached source data. | |
DataSource | The DataSource property determines data source, which data is contained in the table. | |
DimCount | The DimCount property returns the number of data source dimensions, on which the table data is based. | |
Dimensions | The Dimensions property returns the collection of data sources dimensions, on which the table is based. | |
DimItem | The DimItem property returns dimension data. | |
DrillThrough | The DrillThrough property determines whether table data is drilled through into relational table. | |
Evaluator | The Evaluator property returns settings of calculated table factors. | |
Filter | The Filter property returns filtering parameters. | |
FixedElementsAggregation | The FixedElementsAggregation property determines aggregation method that is applied on multiple selection in fixed dimensions. | |
FixedHeader | The FixedHeader property returns the collection of fixed dimensions. | |
HasScaledData | The HasScaledData property returns whether measurement units are taken into account on conditional formatting. | |
HeadersAndData | The HeadersAndData property determines whether a table is created. | |
Highlight | The Highlight property returns parameters of table data highlighting. | |
IsAggregationCalced | The IsAggregationCalced property returns whether aggregation is calculated. | |
IsRedoAvailable | Outdated. The IsRedoAvailable property returns whether operations that can be repeated exist. | |
IsUndoAvailable | Outdated. Use IUndoRedo.UndoCount. | |
KeepDataMatrix | The KeepDataMatrix property determines whether data matrix should be cleared after extracting data from it. | |
LastException | The LastException property returns information about the last occurred error in the table. | |
LeftHeader | The LeftHeader property returns the collection of dimensions of data sources that are arranged in rows. | |
Locked | The Locked property returns whether table rerendering is locked. | |
Matrix | The Matrix property returns table data as a matrix. | |
MergedNamingMode | The MergedNamingMode property determines a method for merging elements of different dimensions. | |
MergedNamingSeparator | The MergedNamingSeparator property determines the separator that will be used on merging names of elements from different dimensions. | |
ObtainDataMode | The ObtainDataMode property determines data transformation mode in table. | |
Pareto | The Pareto property returns 80/20 analysis parameters. | |
RankAreaType | The RankAreaType determines area, by which values data is ranked. | |
RankType | The RankType property determines a method of data ranking. | |
Selection | The Selection property returns the selection, according to which express report data table is built up. | |
SeparateCombinedDimsNamings | The SeparateCombinedDimsNamings property determines merging of dimension name additional attributes in table. | |
SortDiapason | The SortDiapason property determines a mode, in which sorting in the express report table is executed. | |
Sorter | The Sorter property returns parameters of sorting in the table. | |
SplitNamings | The SplitNamings property determines whether several attributes can be output into one table column. | |
Stub | The Stub property returns table data source as an abstract source. | |
TopHeader | The TopHeader property returns the dimensions collection of data sources arranged in columns. | |
UndoRedo | The UndoRedo property returns undo/redo stack parameters of express report table. | |
UseDataCache | The UseDataCache property determines whether data cache is used while working with the table. | |
ValueArea | Outdated. The ValueArea property determines a value view area. | |
ValueAreaType | The ValueAreaType property determines area, for which data view format is set. | |
ValueFormat | Outdated. The ValueFormat property determines a format of value view in the table. | |
ValueType | The ValueType property determines a data view format. | |
ViewMode | The ViewMode property determines a mode of table displaying. | |
ViewOptions | The ViewOptions property determines a mode of displaying composite dimensions in express report table. |
Method name | Brief description | |
AddEventHandler | The AddEventHandler method determines a table event handler. | |
BeginUpdate | The BeginUpdate method disables any table rerendering. | |
BeginSelectionUpdate | The BeginSelectionUpdate method disables selection in data source while changing selection in the table. | |
CanUngroupElement | The CanUngroupElement method determines whether to cancel data grouping after column grouping on drillthrough into relational data. | |
EndUpdate | The EndUpdate method resumes table rerendering after the BeginUpdate method paused it. | |
EndSelectionUpdate | The EndSelectionUpdate method resumes application of selection in data source on changing selection in the table. | |
FlushDataCache | The FlushDataCache method clears data cache. | |
FlushUndo | Outdated. Use IUndoRedo.Flush. | |
GroupElement | The GroupElement method groups column data on drillthrough into relational data. | |
ObtainTable | The ObtainTable method builds and returns data table. | |
ObtainTables | The ObtainTables method returns the collection of data tables variants. | |
Redo | Outdated. Use IUndoRedo.Redo. | |
Refresh | The Refresh method refreshes data table. | |
RemoveEventHandler | The RemoveEventHandler method removes table event handler. | |
Turn | The Turn method turns a table. | |
Undo | Outdated. Use IUndoRedo.Undo. | |
UngroupElement | The UngroupElement method cancels data grouping after column grouping on drillthrough into relational data. |
See also: