IPivot

Assembly: Pivot;

Description

The IPivot interface contains properties and methods that are used to work with an object that is a base for building a data table.

Inheritance Hierarchy

          IPivot

Comments

To work with table data, use properties and methods of the IPivotTable interface.

Properties

  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.

Methods

  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:

Pivot Assembly Interfaces