Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Query Drill Down without affecting the structure layout

Hi All,

We have a query which has structure both in Rows & Columns . When we drilldown ( WAD ) the drilldown characteristics goes within the structure . What i want is even we drilldown the sturcture layout shoud not chnage .

For example the structure is as below

2007 2008

Revenue 100 200

Cost 50 100

Margin 50 100

say we drill down by material , then i want the layout to be like this

Material 0001 2007 2008

Revenue 50 100

Cost 25 50

Margin 25 50

Material 0002

Revenue 50 100

Cost 25 50

Margin 25 50

currently we are getting

2007 2008

Revenue

Material 001 50 100

Material 002 50 100

Cost

Material 001 25 50

Material 002 25 50

Margin

Material 001 25 50

Material 002 25 50

We are currently in BW 3.5 version . Is there any settings in WAD or anywhere , by which the drilldown should not affect the structure layout. ( Please note i dont want to fix the drilldown in query or swap axis during navigation to get the desired result ).

Kind Regards

Sudip

Former Member
Not what you were looking for? View more on this topic or Ask a question