MDX Parser for Java and .NET

MDX queries that GSP parses

SELECT [Measures].[Sales Amount] ON COLUMNS,
  [Product].[Category].Members ON ROWS
FROM [Adventure Works];

Parse it in Java

import gudusoft.gsqlparser.*;

TGSqlParser parser = new TGSqlParser(EDbVendor.dbvmdx);
parser.sqltext = sql; // the MDX query above
if (parser.parse() == 0) {
    System.out.println(parser.sqlstatements.size() + " statement(s) parsed");
} else {
    System.out.println(parser.getErrormessage());
}

Parse it in C#

using gudusoft.gsqlparser;

TGSqlParser parser = new TGSqlParser(EDbVendor.dbvmdx);
parser.sqltext = sql; // the MDX query above
if (parser.parse() == 0)
{
    Console.WriteLine(parser.sqlstatements.size() + " statement(s) parsed");
}
else
{
    Console.WriteLine(parser.Errormessage);
}

Same grammar, .NET-idiomatic API — properties instead of Java getters. See the C# quick start or the .NET SQL Parser SDK.

What GSP handles in MDX

• Cube SELECT with axis specifications (ON COLUMNS, ON ROWS, numbered axes), NON EMPTY, and HAVING
• WITH and CREATE [SESSION] MEMBER / CREATE SET calculated definitions
• CREATE SUBCUBE, SESSION CUBE, GLOBAL CUBE, REFRESH CUBE, and ALTER CUBE
• DRILLTHROUGH queries and cell / dimension PROPERTIES clauses
• MDX script statements — SCOPE ... END SCOPE, CALCULATE, FREEZE, IF ... THEN, CASE
• Bracketed multi-segment identifiers and member, tuple, and set expressions

Beyond parsing, the same AST powers table/column extraction, validation, formatting, and column-level lineage for MDX.

Recent MDX parser updates

• 2026-04-05 [MDX] Add data lineage support for MDX queries

Full history in the release notes.