Class TableBuilder

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

Inheritance
System.Object
TableBuilder
Namespace: Syncfusion.Olap.UWP.Engine
Assembly: Syncfusion.Olap.UWP.dll
Syntax
public class TableBuilder : Object

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.

BuildEngineFromCellSetforExcelLayout(CellSet, Member, Boolean, GridLayout)

Builds the engine from cell setfor 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 setfor 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 setfor 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

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

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

Extension Methods