Class QueryBuilderEngine

Generates the MDX query based on MDX query specifications.

Inheritance

System.Object

QueryBuilderEngine

Inherited Members

System.Object.Equals(System.Object)

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

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

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

System.Object.ToString()

Namespace: Syncfusion.Olap.MDXQueryBuilder

Assembly: Syncfusion.Olap.Base.dll

Syntax

public class QueryBuilderEngine

Constructors

QueryBuilderEngine()

Declaration

public QueryBuilderEngine()

Methods

ExecuteUpdateMDXQuery(String[], String, String, OlapDataManager)

Executes the MDX query and updates a write-enabled cube at the back-end.

Declaration

public static string ExecuteUpdateMDXQuery(string[] editValue, string rowMultiUniqueName, string colMultiUniqueName, OlapDataManager dataManager)

Parameters

Type	Name	Description
System.String[]	editValue
System.String	rowMultiUniqueName
System.String	colMultiUniqueName
OlapDataManager	dataManager

Returns

Type
System.String

GenerateQueryEx(MDXQuerySpecification)

Generates the MDX query.

Declaration

public static string GenerateQueryEx(MDXQuerySpecification mdxQuerySpecification)

Parameters

Type	Name	Description
MDXQuerySpecification	mdxQuerySpecification	The MDX query specification.

Returns

Type	Description
System.String	The MDX query of type string.

GenerateQueryEx(MDXQuerySpecification, Boolean, Providers, List<SlicerRangeFiltersInfo>, SerializableDictionary<String, HeaderPositionsInfo>, Boolean, DrillType, Boolean, Boolean)

Generates the MDX query.

Declaration

public static string GenerateQueryEx(MDXQuerySpecification mdxQuerySpecification, bool isCount, Providers ProviderName, List<SlicerRangeFiltersInfo> SlicerRangeInfoFields, SerializableDictionary<string, HeaderPositionsInfo> DrilledCells, bool ShowLevelTypeAll, DrillType DrillType, bool VisualTotalVisibility, bool UseDefaultMember)

Parameters

Type	Name	Description
MDXQuerySpecification	mdxQuerySpecification	The MDX query specification.
System.Boolean	isCount	Indicates whether it includes the count.
Providers	ProviderName	The name of the provider.
System.Collections.Generic.List<SlicerRangeFiltersInfo>	SlicerRangeInfoFields	The list of slicer range information.
SerializableDictionary<System.String, HeaderPositionsInfo>	DrilledCells	The details of drilled cells.
System.Boolean	ShowLevelTypeAll	Indicates whether to show the level type of 'All'.
DrillType	DrillType	The drill type.
System.Boolean	VisualTotalVisibility	Indicates whether to show the visual total.
System.Boolean	UseDefaultMember	Indicates whether to use the default member.

Returns

Type	Description
System.String	The MDX query of type string.

GenerateQueryEx(MDXQuerySpecification, Boolean, Providers, List<SlicerRangeFiltersInfo>, SerializableDictionary<String, HeaderPositionsInfo>, Boolean, DrillType, Boolean, Boolean, Object)

Generates the MDX query.

Declaration

public static string GenerateQueryEx(MDXQuerySpecification mdxQuerySpecification, bool isCount, Providers ProviderName, List<SlicerRangeFiltersInfo> SlicerRangeInfoFields, SerializableDictionary<string, HeaderPositionsInfo> DrilledCells, bool ShowLevelTypeAll, DrillType DrillType, bool VisualTotalVisibility, bool UseDefaultMember, object reportTag)

Parameters

Type	Name	Description
MDXQuerySpecification	mdxQuerySpecification	The MDX query specification.
System.Boolean	isCount	Indicates whether it includes the count.
Providers	ProviderName	The name of the provider.
System.Collections.Generic.List<SlicerRangeFiltersInfo>	SlicerRangeInfoFields	The list of slicer range information.
SerializableDictionary<System.String, HeaderPositionsInfo>	DrilledCells	The details of drilled cells.
System.Boolean	ShowLevelTypeAll	Indicates whether to show the level type of 'All'.
DrillType	DrillType	The drill type.
System.Boolean	VisualTotalVisibility	Indicates whether to show the visual total.
System.Boolean	UseDefaultMember	Indicates whether to use the default member.
System.Object	reportTag	Indicates additional information of current report

Returns

Type	Description
System.String	The MDX query of type string.