Class TableBuilder

Represents the table builder class used to generate pivot engine either from cell set or relational data.

Inheritance

System.Object

TableBuilder

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: Syncfusion.Olap.Engine

Assembly: Syncfusion.Olap.Base.dll

Syntax

public class TableBuilder

Constructors

TableBuilder()

Declaration

public TableBuilder()

Methods

BuildEngineFromCellSet(CellSet, Member, SummaryLayout, GridLayout, Boolean, Boolean)

Builds the pivot engine from the cell set.

Declaration

public static PivotEngine BuildEngineFromCellSet(CellSet cellSet, Member expandedCell, SummaryLayout summaryLayout, GridLayout gridLayout, bool IncludeCellCaption, bool IsMdx)

Parameters

Type	Name	Description
CellSet	cellSet	The cell set.
Member	expandedCell	The expanded cell.
SummaryLayout	summaryLayout	The summary layout.
GridLayout	gridLayout	The grid layout.
System.Boolean	IncludeCellCaption	Indicates whether to include cell caption.
System.Boolean	IsMdx	Indicates whether it is MDX query.

Returns

Type	Description
PivotEngine	The pivot engine.

BuildEngineFromCellSet(CellSet, Member, SummaryLayout, GridLayout, Boolean, Boolean, Object)

Builds the pivot engine from the cell set.

Declaration

public static PivotEngine BuildEngineFromCellSet(CellSet cellSet, Member expandedCell, SummaryLayout summaryLayout, GridLayout gridLayout, bool IncludeCellCaption, bool IsMdx, object dataManager)

Parameters

Type	Name	Description
CellSet	cellSet	The cell set.
Member	expandedCell	The expanded cell.
SummaryLayout	summaryLayout	The summary layout.
GridLayout	gridLayout	The grid layout.
System.Boolean	IncludeCellCaption	Indicates whether to include cell caption.
System.Boolean	IsMdx	Indicates whether it is MDX query.
System.Object	dataManager	The data manager.

Returns

Type	Description
PivotEngine	The pivot engine.

BuildEngineFromCellSet(CellSet, IDataProvider)

Builds the pivot engine from the cell set.

Declaration

public static PivotEngine BuildEngineFromCellSet(CellSet cellSet, IDataProvider dataProvider)

Parameters

Type	Name	Description
CellSet	cellSet	The cell set.
IDataProvider	dataProvider	The data provider.

Returns

Type	Description
PivotEngine

BuildEngineFromCellSetforExcelLayout(CellSet, Member, Boolean, GridLayout)

Builds the engine from cell set for excel layout.

Declaration

public static PivotEngine BuildEngineFromCellSetforExcelLayout(CellSet cellSet, Member expandedCell, bool isMdx, GridLayout layout)

Parameters

Type	Name	Description
CellSet	cellSet	The cell set.
Member	expandedCell	The expanded cell.
System.Boolean	isMdx	if set to true [is MDX].
GridLayout	layout	The layout.

Returns

Type	Description
PivotEngine

BuildEngineFromCellSetforExcelLayout(CellSet, Member, Boolean, GridLayout, Boolean)

Builds the engine from cell set for excel layout.

Declaration

public static PivotEngine BuildEngineFromCellSetforExcelLayout(CellSet cellSet, Member expandedCell, bool isMdx, GridLayout layout, bool showLevelTypeAll)

Parameters

Type	Name	Description
CellSet	cellSet	The cell set.
Member	expandedCell	The expanded cell.
System.Boolean	isMdx	if set to true [is MDX].
GridLayout	layout	The layout.
System.Boolean	showLevelTypeAll	if set to true [show level type all].

Returns

Type	Description
PivotEngine

BuildEngineFromCellSetforExcelLayout(CellSet, Member, Boolean, GridLayout, Boolean, Object)

Builds the engine from cell set for excel layout.

Declaration

public static PivotEngine BuildEngineFromCellSetforExcelLayout(CellSet cellSet, Member expandedCell, bool isMdx, GridLayout layout, bool showLevelTypeAll, object dataManager)

Parameters

Type	Name	Description
CellSet	cellSet	The cell set.
Member	expandedCell	The expanded cell.
System.Boolean	isMdx	if set to true [is MDX].
GridLayout	layout	The layout.
System.Boolean	showLevelTypeAll	if set to true [show level type all].
System.Object	dataManager	The data manager.

Returns

Type	Description
PivotEngine

BuildEngineFromIListSource(IListSource, OlapReport, SortType, String[], String[], SummaryInfo[], Boolean, GridLayout, Boolean, Int32, PivotCellDescriptor, Boolean)

Pivot Engine Generation for Ilistsource.

Declaration

public static PivotEngine BuildEngineFromIListSource(IListSource listSource, OlapReport CurrentReport, SortType sortOrder, string[] columnGroup, string[] rowGroup, SummaryInfo[] summaryInfos, bool isRowSummary, GridLayout layout, bool ExpandAll, int summaryStringCount, PivotCellDescriptor drilledCell, bool drillDown)

Parameters

Type	Name	Description
System.ComponentModel.IListSource	listSource	The list source.
OlapReport	CurrentReport	The current report.
SortType	sortOrder	The sort order.
System.String[]	columnGroup	The column group.
System.String[]	rowGroup	The row group.
SummaryInfo[]	summaryInfos	The summary infos.
System.Boolean	isRowSummary	if set to true [is row summary].
GridLayout	layout	The layout.
System.Boolean	ExpandAll	if set to true [expand all].
System.Int32	summaryStringCount	The summary string count.
PivotCellDescriptor	drilledCell	The drilled cell.
System.Boolean	drillDown	if set to true [drill down].

Returns

Type	Description
PivotEngine

BuildEngineFromIQueryable(IQueryable, OlapReport, SortType, String[], String[], SummaryInfo[], Boolean, GridLayout, Boolean, PivotCellDescriptor, Boolean)

Builds the engine from IEnumerable source

Declaration

public static PivotEngine BuildEngineFromIQueryable(IQueryable queryableSource, OlapReport CurrentReport, SortType sortOrder, string[] columnGroup, string[] rowGroup, SummaryInfo[] summaryInfos, bool isRowSummary, GridLayout layout, bool ExpandAll, PivotCellDescriptor drilledCell, bool drillDown)

Parameters

Type	Name	Description
System.Linq.IQueryable	queryableSource	The IEnumerable source.
OlapReport	CurrentReport	The current report.
SortType	sortOrder	The sort order.
System.String[]	columnGroup	The column group.
System.String[]	rowGroup	The row group.
SummaryInfo[]	summaryInfos	The summary infos.
System.Boolean	isRowSummary	if set to true [is row summary].
GridLayout	layout	The layout.
System.Boolean	ExpandAll	if set to true [expand all].
PivotCellDescriptor	drilledCell	The drilled cell.
System.Boolean	drillDown	if set to true [drill down].

Returns

Type	Description
PivotEngine

BuildEngineTableFromCellSet(CellSet)

Builds the pivot engine from the specified cell set.

Declaration

public static PivotEngine BuildEngineTableFromCellSet(CellSet cellSet)

Parameters

Type	Name	Description
CellSet	cellSet	The cell set.

Returns

Type	Description
PivotEngine

BuildTableFromCellSet(CellSet, SummaryLayout, GridLayout, Boolean)

Builds the pivot engine from the cell set.

Declaration

public static PivotEngine BuildTableFromCellSet(CellSet cellSet, SummaryLayout summaryLayout, GridLayout gridLayout, bool IsMDX)

Parameters

Type	Name	Description
CellSet	cellSet	The cell set.
SummaryLayout	summaryLayout	The summary layout.
GridLayout	gridLayout	The grid layout.
System.Boolean	IsMDX	Indicates whether it is MDX query.

Returns

Type	Description
PivotEngine	The pivot engine.

GetMaxLevel(Axis, Int32)

Returns the maximum level of the tuple set.

Declaration

public static int GetMaxLevel(Axis cubeAxis, int dimension)

Parameters

Type	Name	Description
Axis	cubeAxis	The cube axis.
System.Int32	dimension	The dimension.

Returns

Type	Description
System.Int32

GetMinLevel(Axis, Int32)

Returns the minimum level of the tuple set.

Declaration

public static int GetMinLevel(Axis cubeAxis, int dimension)

Parameters

Type	Name	Description
Axis	cubeAxis	The cube axis.
System.Int32	dimension	The dimension.

Returns

Type	Description
System.Int32