[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?

eg:

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