menu

WPF

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class QueryBuilderEngine - WPF API Reference | Syncfusion

    Show / Hide Table of Contents

    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.

    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved