Multi dimensional hierarchical portlet

Discussion created by abhangale on Jan 21, 2012
Latest reply on Jan 27, 2012 by Chris_Hackett
Clarity Gurus,

I am looking to create a multi dimensional portlet where I show resources on the Y axis and ETC by weeks on the X axis. Everything works well till this point. But now I want to add hierarchy where I show aggregate ETC at the manager's level and the manager row expands to display the resources. This doesnt seem to work. Has anyone implemented this or does anyone have any ideas on how to implement this.

I do not want to use any materialized views or staging tables.