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. | |
| RebuildCompounds | The RebuildCompounds method rebuilds composite dimensions. | |
| 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: