Skip to Content
author's profile photo
Former Member

display multiple combination of values all at a time in the planning layout

Hi,

we are on BW 3.0B and SEM 3.1B. We've 2 characteristics "COUNTRY" and "CONTINENT" in planning level and package.

in the planning layout, we had placed "CONTINENT" in the lead columns and "COUNTRY" in the header are and COUNTRY is hidden.

Now, when we execute the layout for CONTINENT values "EUROPE and AFRICA" and COUNTRY values "GERMANY and SAFRICA".

output of the layout is as follows for country GERMANY

CONTINENT Value

EUROPE 123

EUROPE 234

EUROPE 456

as COUNTRY is in header, we need to scroll down (use down and upper arrows) to get values for next country SAFRICA combination of CONTINENT "AFRICA" in the layout as follows

CONTINENT value

AFRICA 342

AFRICA 267

AFRICA 768

How do we get the layout to display both AFRICA and EUROPE in the same page without a need to use arrows as follows

CONTINENT Value

EUROPE 123

EUROPE 234

EUROPE 456

AFRICA 342

AFRICA 267

AFRICA 768

the only solution, i can think of is move COUNTRY from header to lead columns. But, we have a need to keep COUNTRY in the header area. I doubt if we can achieve this, but i have some hope as COUNTRY is a hidden field in the header area which we can take advantage of.

any help is greatly appreciated.

thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jul 15, 2004 at 07:34 PM

    Hello Hari (is that your name?)

    well, if you have the continents in the lead column and want to display all of them i.e. Europe and Africa, then it does not make sense at all to have country in the header since a country is assigned to only one continent... at least here on Earth ;-).

    As you said already, you could put country in the lead column as well, but it can not be hidden in this case.

    The alternative is to remove country from the planning level. Then you have two options:

    1) Derive country automatically. It's strange to have a char.relationship from continent to country since there are multiple countries per continent, but if there's a rule in your case to have only one country per continent, then this will work.

    2) Repost the data (country = #) to the right countrz after the input is done.

    Regards,

    Marc

    SAP NetWeaver RIG, US BI

    Add comment
    10|10000 characters needed characters exceeded

    • Hari,

      the answer is the same. The only way to do it is to remove "group" from the planning level.

      Obviously, it is not possible to display data for a specific "group" in the layout as well. Your data is on different levels of detail (once with group and once without it). Therefore, you have really two different planning levels and would need two layouts to display the data. Using a web interface for example, you can put both layouts on the same web page/screen.

      Regards,

      Marc

      SAP NetWeaver RIG, US BI

      PS: BTW, you basically go the same answer on ittoolbox already 😉