Skip to Content
0
Former Member
Mar 28, 2008 at 12:34 AM

Drilldown only specific rows of a structure

38 Views

I don't think this is possible, however I was told by someone they did it. Here's the scenario

We have a query which uses a BEx Structure in the row section as follows:

Row1: Cost Centers (Custom grouping)

Row2: Total

When executing query in BEx Analyzer Excel, we want to perform a drilldown on Row1, but NOT Row2.

If Row1 is made up of 50 Cost Centers, after drilldown I should only be able to see 51 rows.

What is happening now we see 100 rows when we drilldown on CC, this is because both Row1 and Row2 are expanded.