Class QueryBuilderEngine

Generates the MDX query based on MDX query specifications.

Inheritance
System.Object
QueryBuilderEngine
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.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 Description
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.

Extension Methods