IPivot

Assembly: Pivot;

Namespace: Prognoz.Platform.Interop.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
	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 attribute.
	IBuildWithEmptyHeader	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	The IsRedoAvailable property returns whether operations that can be repeated exist.
	IsUndoAvailable	The IsUndoAvailable property returns whether operations that can be canceled exist.
	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.
	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.

Methods

	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	The FlushUndo method clears the list of all the operations executed by the user.
	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.
	Redo	The Redo method repeats the last cancelled operation.
	Refresh	The Refresh method refreshes data table.
	RemoveEventHandler	The RemoveEventHandler method removes table event handler.
	Turn	The Turn method turns a table.
	Undo	The Undo method cancels the last executed operation.
	UngroupElement	The UngroupElement method cancels data grouping after column grouping on drillthrough into relational data.

See also:

Pivot Assembly Interfaces