[Mondrian] Mondrian API: Adding a condition to a Query object

Pedro Alves pmgalves at gmail.com
Fri Jul 24 12:31:56 EDT 2009

Hey there.

Is it possible to add conditions to the Query object after the query 
string has been parsed?


String query = "select NON EMPTY {[Measures].[Quantity]} ON COLUMNS, 
NON EMPTY  [Product].Children ON ROWS from [SteelWheelsSales] where 
[Markets].[All Markets].[EMEA]";

Query mdxQuery = connection.parseQuery(query);

// Add an extra condition: [Date].[2006]

// And evaluate it
RolapResult result = (RolapResult) connection.execute(mdxQuery);

Tips appreciated, thanks

More information about the Mondrian mailing list