Query Drill Down without affecting the structure layout

[Former Member]

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]

Hi,

For the example shown by you, does not require 2 structure, You can doing it using One structure.

Consider the following in Rows and Columns:

Rows:

1. Material or other cahar and material in Free char.

Columns:

1. Fiscal Year

2. Structure comprising the KFs Revenue, cost and Margin.

Try this it should solve.

Regards,

Vishwa.

[Former Member]

HI Vishwa,

Thanks for your reply , let me clarify the requirement for having two structure , we need a comparision for each year month with the last year month so my query would look some ting like this

JAN FEB

2007 2008 | 2007 2008

revenue 10 20 30 40

cost 5 10 15 20

margin 5 10 15 20

Regards

Sudip

[Former Member]

Drilldown on the material, then swap the material with your structure in rows.

The Drilldown is adding a char in row/column after the one on which you were positioned when you choose drilldown, or at the rightiest position of the report.

If you don't want to add another navigation step, just save a query view, and create a button which will display the saved view instead of the query.

[Former Member]

HI Frédéric,

Thanks for your reply , but i dont want to drill down and swap the structure ( I have already mentioned that in the question ) . Also saving as a query view doesnt help as there are many different characteristics in my query and material is one of them .

I am looking for an option by which , the layout of the structure remains intact during drill down . Not sure if there exist any config in the webtemplate by which we can achive this .

Regards

Sudip