Skip to Content
Former Member
Aug 03, 2009 at 08:23 PM

Maintain Columns for Higher Levels in Hierarchy when using Drill Down


Hello all,

I've searched through this forum looking for an answer to this, since I thought it might be a common question, but I wasn't able to find any related content. So I apologize if this has already been answered in the past.

I would like to know if when drilling down in a WEBI report, it is possible to automatically add dimension columns to a report as you drill down to the lower levels in the heirarchy, and keep the columns with the higher level dimension values, rather than replace those columns, which is the default behavior. As a simple example, suppose I have the following columns in a report:

Product Sales Amount

Now suppose I have set up a heirarchy in the Universe with Product, Sub-Product, then Region, in that order. In the WEBI report with the drill filter options enabled, when I click on the Product link, the default behavior is to replace the Product column with the Sub-Product dimension and display the following:

Sub-Product Sales Amount

Instead, I would like it to display:

Product Sub-Product Sales Amount

Then subsequently, of course:

Product Sub-Product Region Sales Amount

Does anybody know of a simple way to accomplish this? I suppose this could be accomplished using the openDocument method with links to separate reports showing the addtional columns, but this seems a bit complicated for a relatively smple requirement. I'm hoping that there is an existing simpler solution to this problem. Please advise. Any information would be greatly appreciated.