Class Parser

Represents the information needed for parsing the MDX Query.

Inheritance

System.Object

Parser

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.MDXQueryParser

Assembly: Syncfusion.Olap.Base.dll

Syntax

public class Parser

Constructors

Parser()

Declaration

public Parser()

Fields

MDXQueryNew

Gets or sets the new MDX query.

Declaration

public static string MDXQueryNew

Field Value

Type
System.String

measureOption

Gets or sets a value indicating whether to include measure option.

Declaration

public static bool measureOption

Field Value

Type
System.Boolean

olapReport

Gets or sets the OLAP report.

Declaration

public static OlapReport olapReport

Field Value

Type
OlapReport

select

Gets or sets the select query.

Declaration

public static Select select

Field Value

Type
Select

subselectoption

Gets or sets a value indicating whether to include sub-select option.

Declaration

public static bool subselectoption

Field Value

Type
System.Boolean

tempchar

Gets or sets the temporary character.

Declaration

public static char tempchar

Field Value

Type
System.Char

Methods

CellProperties(String, CellsProperties)

Updates the values of cell properties.

Declaration

public static void CellProperties(string cellproperty, CellsProperties cellprops)

Parameters

Type	Name	Description
System.String	cellproperty	The property token.
CellsProperties	cellprops	The properties of cell.

generateReport(String)

Generates the OLAP report.

Declaration

public static OlapReport generateReport(string query)

Parameters

Type	Name	Description
System.String	query	The MDX query.

Returns

Type	Description
OlapReport	The OLAP report.

getFilter(Items, IKeyword, Axis)

Gets the filter.

Declaration

public static void getFilter(Items items, IKeyword ikeyword, Axis axis)

Parameters

Type	Name	Description
Items	items	The collection of items.
IKeyword	ikeyword	The IKeyword object.
Axis	axis	The axis.

getFilter(Items, IKeyword, Axis, MeasureElements)

Gets the filter.

Declaration

public static void getFilter(Items items, IKeyword ikeyword, Axis axis, MeasureElements measureElement)

Parameters

Type	Name	Description
Items	items	The collection of items.
IKeyword	ikeyword	The IKeyword object.
Axis	axis	The axis.
MeasureElements	measureElement	The measure element.

getFilterHierarchies(FilterElement, IKeyword)

Gets the filter hierarchies.

Declaration

public static void getFilterHierarchies(FilterElement filterElements, IKeyword ikeyword)

Parameters

Type	Name	Description
FilterElement	filterElements	The filter element.
IKeyword	ikeyword	The IKeyword object.

getFilterHierarchies(FilterElement, IKeyword, MeasureElements)

Gets the filter hierarchies.

Declaration

public static void getFilterHierarchies(FilterElement filterElements, IKeyword ikeyword, MeasureElements measureElement)

Parameters

Type	Name	Description
FilterElement	filterElements	The filter element.
IKeyword	ikeyword	The IKeyword object.
MeasureElements	measureElement	The measure element.

getFilterMembers(FilterElement, IMember)

Gets the filter members.

Declaration

public static void getFilterMembers(FilterElement filterElements, IMember member)

Parameters

Type	Name	Description
FilterElement	filterElements	The filter element.
IMember	member	The IMember object.

getFilterMembers(FilterElement, IMember, MeasureElements)

Gets the filter members.

Declaration

public static void getFilterMembers(FilterElement filterElements, IMember member, MeasureElements measureElement)

Parameters

Type	Name	Description
FilterElement	filterElements	The filter element.
IMember	member	The IMember object.
MeasureElements	measureElement	The measure element.

getFilterTupleMembers(FilterElement, Tuple, Axis)

Gets the members of filter tuple.

Declaration

public static void getFilterTupleMembers(FilterElement filterElements, Tuple tuples, Axis axis)

Parameters

Type	Name	Description
FilterElement	filterElements	The filter element.
Tuple	tuples	The tuple.
Axis	axis	The axis.

getFilterTupleMembers(FilterElement, Tuple, Axis, MeasureElements)

Gets the members of filter tuple.

Declaration

public static void getFilterTupleMembers(FilterElement filterElements, Tuple tuples, Axis axis, MeasureElements measureElement)

Parameters

Type	Name	Description
FilterElement	filterElements	The filter element.
Tuple	tuples	The tuple.
Axis	axis	The axis.
MeasureElements	measureElement	The measure element.

getHierarchies(Items, IKeyword)

Gets the hierarchies.

Declaration

public static void getHierarchies(Items items, IKeyword ikeyword)

Parameters

Type	Name	Description
Items	items	The collection of items.
IKeyword	ikeyword	The IKeyword object.

getHierarchies(Items, IKeyword, MeasureElements)

Gets the hierarchies.

Declaration

public static void getHierarchies(Items items, IKeyword ikeyword, MeasureElements measureElement)

Parameters

Type	Name	Description
Items	items	The collection of items.
IKeyword	ikeyword	The IKeyword object.
MeasureElements	measureElement	The measure element.

getMembers(Items, IMember)

Gets the members.

Declaration

public static void getMembers(Items items, IMember member)

Parameters

Type	Name	Description
Items	items	The collection of items.
IMember	member	The member.

getMembers(Items, IMember, MeasureElements)

Gets the members.

Declaration

public static void getMembers(Items items, IMember member, MeasureElements measureElement)

Parameters

Type	Name	Description
Items	items	The collection of items.
IMember	member	The IMember object.
MeasureElements	measureElement	The measure element.

getOrders(Items, IKeyword, Axis)

Gets the orders.

Declaration

public static void getOrders(Items items, IKeyword ikeyword, Axis axis)

Parameters

Type	Name	Description
Items	items	The collection of items.
IKeyword	ikeyword	The IKeyword object.
Axis	axis	The axis.

getOrders(Items, IKeyword, Axis, MeasureElements)

Gets the orders.

Declaration

public static void getOrders(Items items, IKeyword ikeyword, Axis axis, MeasureElements measureElement)

Parameters

Type	Name	Description
Items	items	The collection of items.
IKeyword	ikeyword	The IKeyword object.
Axis	axis	The axis.
MeasureElements	measureElement	The measure element.

getTopCount(Items, IKeyword, Axis)

Gets the top count.

Declaration

public static void getTopCount(Items items, IKeyword ikeyword, Axis axis)

Parameters

Type	Name	Description
Items	items	The collection of items.
IKeyword	ikeyword	The IKeyword object.
Axis	axis	The axis.

getTopCount(Items, IKeyword, Axis, MeasureElements)

Gets the top count.

Declaration

public static void getTopCount(Items items, IKeyword ikeyword, Axis axis, MeasureElements measureElement)

Parameters

Type	Name	Description
Items	items	The collection of items.
IKeyword	ikeyword	The IKeyword object.
Axis	axis	The axis.
MeasureElements	measureElement	The measure element.

getTupleFormat(String)

Gets the formatted tuple.

Declaration

public static string getTupleFormat(string query)

Parameters

Type	Name	Description
System.String	query	The MDX query.

Returns

Type	Description
System.String	The formatted query.

Exceptions

Type	Condition
QuerySyntaxError	PARSER ERROR: '.' is expected.

getTuples(Items, Axis)

Gets the tuple.

Declaration

public static void getTuples(Items items, Axis axis)

Parameters

Type	Name	Description
Items	items	The collection of items.
Axis	axis	The axis.

getTuples(Items, Axis, MeasureElements)

Gets the tuple.

Declaration

public static void getTuples(Items items, Axis axis, MeasureElements measureElement)

Parameters

Type	Name	Description
Items	items	The collection of items.
Axis	axis	The axis.
MeasureElements	measureElement	The measure element.

getTuplesMembers(Items, Tuple, Axis)

Gets the members of tuple.

Declaration

public static void getTuplesMembers(Items items, Tuple tuples, Axis axis)

Parameters

Type	Name	Description
Items	items	The collection of items.
Tuple	tuples	The tuple.
Axis	axis	The axis.

getTuplesMembers(Items, Tuple, Axis, MeasureElements)

Gets the members of tuple.

Declaration

public static void getTuplesMembers(Items items, Tuple tuples, Axis axis, MeasureElements measureElement)

Parameters

Type	Name	Description
Items	items	The collection of items.
Tuple	tuples	The tuple.
Axis	axis	The axis.
MeasureElements	measureElement	The measure element.

IsNumeric(String)

Determines whether the specified string is numeric.

Declaration

public static bool IsNumeric(string strToCheck)

Parameters

Type	Name	Description
System.String	strToCheck	The string to check.

Returns

Type	Description
System.Boolean	A value that indicates whether it is numeric string.

RemoveExtraSpace(String)

Removes the unwanted space in the MDX query.

Declaration

public static string RemoveExtraSpace(string query)

Parameters

Type	Name	Description
System.String	query	The MDX query.

Returns

Type	Description
System.String	The MDX query without unwanted space.

TupleSets()

Tuples the sets.

Declaration

public static void TupleSets()

TupleSets(Tokens)

Sets the tuple set on rows and columns

Declaration

public static void TupleSets(Tokens tokens)

Parameters

Type	Name	Description
Tokens	tokens	The token.

Validate(String, Items, Axis)

Validates the specified equation.

Declaration

public static bool Validate(string equation, Items items, Axis ax)

Parameters

Type	Name	Description
System.String	equation	The equation.
Items	items	The collection of items.
Axis	ax	The axis.

Returns

Type	Description
System.Boolean	A value that indicates whether it is valid equation.

Exceptions

Type	Condition
QuerySyntaxError	Error in Hierarchize or Error in Filter or Error in DrillDownLevel or Error in DrillDownMember or Error in Top Count or Error in Order or PARSER ERROR: for ' + str + ' or Invalid Tuple