Assembly: 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 | |
AggregationElement | The AggregationElement property determines the element, by which matrix aggregated data is available by fixed dimensions. | |
BroughtOutDim | The BroughtOutDim property determines a metrics dimension. | |
BroughtOutDimValue | The BroughtOutDimValue property determines index of metrics dimension element on using the Value attribute. | |
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. | |
CanEdit | The CanEdit property returns whether table data can be edited. | |
ContainsHierarchy | The ContainsHierarchy property returns whether the specified alternative hierarchy is in the collection. | |
DataCacheEnabled | The DataCacheEnabled property returns whether the user works with cached source data. | |
DataSource | The DataSource property determines a data source based on which a table is created. | |
DimCount | The DimCount property returns the number of data sources dimensions, on which the table is based. | |
DimElementsDetailing | The DimElementsDetailing property returns drill down of dimension elements. | |
Dimensions | The Dimensions property returns the collection of data sources dimensions, on which the table is based. | |
DimItem | The DimItem property returns data of data source dimension. | |
DrillThrough | The DrillThrough property determines whether table data is drill down into relational table. | |
Evaluator | The Evaluator property returns settings of calculated table factors. | |
EventsEnabled | The EventsEnabled property determines whether event handler is used in table. | |
Filter | The Filter property returns data filtering parameters in table. | |
FilterHeader | The FilterHeader property returns the collection of dimensions used as a cube filter. | |
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 | TheIsAggregationCalced property returns whether table data aggregation is calculated. | |
IsCalced | The IsCalced property returns whether table data is calculated. | |
IsEditEnabled | The IsEditEnabled property determines whether table data editing is available. | |
IsFactsAggregationAvailable | The IsFactsAggregationAvailable property returns whether fact aggregation is available from data source. | |
IsReadyToExecute | The IsReadyToExecute property returns whether a table is ready for calculation. | |
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 dimensions collection of data sources that are arranged in rows in the table. | |
LocalExecuting | The LocalExecuting property determines calculation status. | |
Locked | The Locked property returns whether table rerendering is locked. | |
Matrix | The Matrix property returns table data as a matrix. | |
MergedAdditionalNamingMode | The MergedAddtionalNamingMode property determines a method for merging additional names of elements of different dimensions. | |
MergedAdditionalNamingSeparator | The MergedAdditionalNamingSeparator property determines a separator that will be used on merging additional names of elements of different dimensions. | |
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 property determines an area, which values are used to rank table data. | |
RankType | The RankType property determines a method of table data ranking. | |
Selection | The Selection property returns the selection according to which table is built up. | |
SeparateCombinedDimsNamings | The SeparateCombinedDimsNamings property determines merging of dimension name additional attributes in table. | |
SortDiapason | TheSortDiapason property determines the sorting mode in table. | |
Sorter | The Sorter property returns parameters of sorting in the table. | |
SplitNamings | The SplitNamings property determines whether multiple attributes can be output to a single data table column. | |
Stub | The Stub property returns table data source as an abstract source. | |
TableNoData | The TableNoData property returns the table without recalculating it. | |
TopHeader | The TopHeader property returns the dimensions collection of data sources that is arranged by columns in the table. | |
UndoRedo | The UndoRedo property returns undo/redo stack parameters of table. | |
UseDataCache | The UseDataCache property determines whether data cache is used while working with table. | |
ValueAreaType | TheValueAreaType property determines area for which data view format is set. | |
ValueType | The ValueType property determines a format of data view in table. | |
ViewMode | The ViewMode property determines a mode of table displaying. | |
ViewOptions | The ViewOption property determines a mode of displaying composite dimensions in table. |
Method name | Brief description | |
AddEventHandler | The AddEventHandler method determines a table event handler. | |
AddHierarchy | The AddHierarchy method adds an alternative hierarchy to the collection. | |
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 drill down into relational data. | |
EndUpdate | The EndUpdate method resumes table rerendering. | |
EndUpdateEx | The EndUpdateEx method resumes table rerendering with advanced settings. | |
EndSelectionUpdate | The EndSelectionUpdate method resumes application of selection in data source on changing selection in the table. | |
FlushDataCache | The FlushDataCache method clears data cache. | |
GroupElement | The GroupElement method groups column data on drill down into relational data. | |
ObtainTable | The ObtainTable method builds and returns the data table. | |
ObtainTables | The ObtainTables method returns the collection of data tables variants. | |
RebuildCompounds | The RebuildCompounds method rebuilds composite dimensions in table. | |
Refresh | The Refresh method updates data table. | |
RemoveEventHandler | The RemoveEventHandler method removes table event handler. | |
RemoveHierarchy | The RemoveHierarchy method removes the alternative hierarchy from the collection. | |
SetDataSource | The SetDataSource method sets a data source. | |
Turn | The Turn method turns a table. | |
UngroupElement | The UngroupElement method cancels data grouping after column grouping on drill down into relational data. |
See also: