View Full Version : Any OLAP report designer planned ?

03-17-2003, 07:40 AM
I'd like to know if the scope of Mondrian/JPivot includes the development of a report designer (i.e. a module that allows a user to create on-line new queries) ?

03-27-2003, 12:17 PM
In a sense, you can do this already: every time you perform an operation on a JPivot report, the underlying MDX mutates. (Click on the 'cube' icon and the 'MDX' icon, add a dimension, and see the MDX change.) You can save that MDX in a JSP page as a 'report'.
JPivot already supports some fairly complex operations such as ranking, but it would be great if JPivot allowed you to create calculated members, calulcated sets, and parameters. I suggest you lobby the JPivot guys!

04-05-2003, 06:22 AM
Any ideas how such a thing would look like? Is it possible at all to have a GUI that allows you to create queries like:
For each Product-Category show me the TOP 3 Customers with maximum Store Sales in 1997.