OSBI/saiku — Issue #8: Children of Selected Hierarchy Elements Retrieved
Author: buggtb
Created: 2011-10-11 14:25:27+00:00
State: open

The children of the selected hierarchy elements are retrieved unnecessarily.

First reported in ##saiku and fixed by Paul:

(11:11:32 AM) cwarden: saiku seems to be too aggressive about descending hierarchies
(11:12:13 AM) cwarden: for example, if i have a date dimension with year, month, and day levels, and report on a measure by year, saiku queries for all of the months under each year.
(11:12:56 AM) cwarden: any way to disable this behavior?
(11:14:44 AM) pstoellberger: can you describe that in more detail?
(11:14:57 AM) pstoellberger: are you watching SQL? MDX?
(11:15:43 AM) cwarden: i'm watching the sql
(11:16:43 AM) pstoellberger: and you mean during the member cache population?
(11:17:29 AM) pstoellberger: we dont touch any lower levels in our code.... so this must be default mondrian behaviour
(11:19:50 AM) cwarden: i don't see the same behavior with jpivot.
(11:20:05 AM) pstoellberger: if you can show me some mondrian sql log about that i might be able to help you
(11:20:06 AM) cwarden: here's an example of the sql: http://pastebin.com/mQPSHtJv
(11:21:10 AM) pstoellberger: hm
(11:21:22 AM) pstoellberger: i can send you a new jar that you could try
(11:21:25 AM) pstoellberger: i think i have an idea
(11:21:46 AM) cwarden: cool, thanks.
(11:22:48 AM) pstoellberger: if its not that its not in our code base :)
(11:23:32 AM) pstoellberger: http://dl.dropbox.com/u/13927708/saiku-olap-2.2-SNAPSHOT.jar
(11:24:01 AM) pstoellberger: replace your current saiku-olap.jar with that one
(11:24:09 AM) pstoellberger: (make sure you delete/move the old one)
(11:24:24 AM) pstoellberger: tomcat/webapps/saiku/WEB-INF/lib
(11:24:57 AM) pstoellberger: or saiku/lib in the plugin
(11:38:54 AM) pstoellberger: any luck cwarden ?
(11:41:25 AM) cwarden: sorry, one sec. just being a little paranoid and checking the jar against the ci one. :)
(11:41:55 AM) thinkjson: it's a trojan, so he can look at what you're looking at
(11:41:59 AM) thinkjson: j/k
(11:42:00 AM) pstoellberger: lol
(11:42:06 AM) pstoellberger: i just commented about 10 lines of code
(11:42:21 AM) pstoellberger: you can do the changes yourself if you want :)
(11:42:37 AM) cwarden: CheatCellSetFormatter.java?
(11:43:41 AM) pstoellberger: yep
(11:44:16 AM) pstoellberger: line 535-551
(11:44:28 AM) pstoellberger: thats really paranoid :P
(11:44:56 AM) cwarden: half paranoia. half trying to learn a little about the architecture.
(11:45:07 AM) cwarden: anyway, you fixed it
(11:45:11 AM) cwarden: thanks!
(11:45:16 AM) pstoellberger: so it helped?
(11:45:26 AM) pstoellberger: hm yeah i knew that we do lots of stuff we dont *have* to
(11:45:47 AM) pstoellberger: in the code of those formatters might be dragons
(11:46:04 AM) pstoellberger: rewriting them is on my todo :)

http://analytical-labs.com/0001-Don-t-automatically-retrieve-children.patch