[Mondrian] Support for Rollup and Cube

[Julian Hyde]

No way at present, but it could be implemented as a feature. Can you log a
jira case for it, with the following comments:
 
The best strategy would be for the Sybase IQ dialect to declare that it
supports grouping sets, so that mondrian does the work of gathering together
requests of different granularity, then when it generates SQL, generate the
appropriate ROLLUP or CUBE.
 
Priority on Pentaho's roadmap would be low. Contributions welcome, as usual.
 
Julian


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Venkatesh U
Sent: Wednesday, December 01, 2010 10:18 PM
To: Mondrian developer mailing list
Subject: [Mondrian] Support for Rollup and Cube


Hi,
 Currently Rollup and Cube are not used in the mondrian, Is there any way to
make use of them in the SQL queries generated by mondrian?? I know that
Grouping Sets are supported by mondrian, but my situation is we are using
SybaseIQ with mondrian and Sybase IQ does not support Grouping sets yet.

Thanks.
Venki


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20101202/2c39eca9/attachment.html