Issue: Extra blank rows inserted on second drilldown of Rows dimension. Smart View version: 220.127.116.11.000 (Build 434) Excel version: 2007 SP3 running on Windows XP
Aftering drilling down on a dimension on a row in an ad-hoc query and then drilling back up, it doesn't seem that Smartview "cleans up" extra blank rows on a grid that it no longer needs. The result is that drilling down on another row member inserts a large number of empty rows between the drilled-down members, one row for each of the non-erased rows from the grid.
A workaround for this is to delete all the empty rows from the grid before drilling down on the second dimension. But this is pretty tedious from a user's perspective. Mutiple users are encountering the problem. Has anyone encountered the same situation and, if so, have you found a solve?
This is a know bug. The work around is to turn off "Preserve formulas and comments on in Ad-Hoc operations (except Pivot)" in the member options before you start doing your zoom in or out. (new sheet) I suggest making it your default and then after doing the zooming add formulas as needed.
What's really annoying is I just downloaded and installed the Smartview 18.104.22.168.300 update and it's still not fixed. Fricking Oracle is terrible about stuff like this. Sorry to rant but they seriously need software development help!!!