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.
	CanRestoreState	The CanRestoreState property returns whether data table pivot state can be restored.
	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.
	Drill	The Drill property returns table data drilldown/drillup settings.
	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.
	IsDimEnabled	The IsDimEnabled property determines whether a dimension with the specified key will be displayed in the list of dimensions to set selection.
	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.
	UnmatchedUnitsText	The UnmatchedUnitsText property determines the text displayed in the calculated cell if cell value cannot be calculated.
	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.
	BeginSelectionUpdate	The BeginSelectionUpdate method disables selection in data source while changing selection in the table.
	BeginStateUpdate	The BeginStateUpdate method starts saving of data table pivot state.
	BeginUpdate	The BeginUpdate method disables any table rerendering.
	CanUngroupElement	The CanUngroupElement method determines whether to cancel data grouping after column grouping on drill down into relational data.
	DropState	The DropState method resets the saved data table pivot state.
	EndSelectionUpdate	The EndSelectionUpdate method resumes application of selection in data source on changing selection in the table.
	EndStateUpdate	The EndStateUpdate method finishes saving of data table pivot state.
	EndUpdate	The EndUpdate method resumes table rerendering.
	EndUpdateEx	The EndUpdateEx method resumes table rerendering with advanced settings.
	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.
	RestoreState	The RestoreState method restores table state in the specified mode.
	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.