I try an OLAP view with a Mondrian schema in an Ad Hoc report, but it seems that there is no totals functionality. Is this the case or I miss something?
Using an Ad Hoc report with a Domain you can see totals in rows and columns. However you cannot set up hierarchies and custom ordering in fields (e.g name column – ordinal column)?
So it seems that there is some limitations in Jasper pro edition as the best is to be able in both Domain and Mondrian Ad Hoc reports to have the same functionality (totals, ordering, etc).
Is this possible?