Pivot > Pivot Assembly Interfaces > IPivot
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 user access permissions to table cells will 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: