Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 02, 2008 at 03:35 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Sep 02, 2008 at 03:43 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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