Question:
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.
Answer:
You can do it if Continent is both a dimension in the cube and an attribute of Country - leave the continent dimension in the header and also display it as an attribute of the lead column Country.
_________________
CF
Answer:
Hi CF,
thanks for your reply. we don't need to put continent in header. sorry to confuse you. I am giving an example in a more realistic way. look for it at the end of this mail.
continent and country don't have any attributes. they are strictly characteristics.
I did try with a characteristic A that has an attribute Characteristic B.
in the layout, I had put B in the header and also selected attribute (B) of A in the lead columns.
when i execute, planning folder, it prompted to select "1st selection" for B as (i think) is in the header. that way, I didn't get the desired result.
we have cube data as follows
Code Area Group Price
ABCD EUR 111 20USD
ABCD USA 222 30USD
Code, Area, Group are not attributes of each other.
we have a plannin folder with variables for Code and Area with an input layout that has "Code and Group" in the header and "Area" in the lead columns.
after we execute folder, if we enter values "ABCD" for variable "Code" and variable range "EUR to USA" for "Area", current layout is as follows
======
Header
======
Code : ABCD
Group: 111 (not visible as Group is hidden in the header area of layout)
======
Layout
======
Area Price
EUR 20USD
for next combination, if we use down arrow to scroll down to Group 222, layout is as follows
======
Header
======
Code : ABCD
Group: 222 (not visible as Group is hidden in the header area of layout)
======
Layout
======
Area Price
USA 30USD
we are interested to see all "areas" for Code ABCD irrespective of "Group" as follows.
if we enter "ABCD" for Code and "EUR to USA" for "Area" variables, we need to have layout
======
Header
======
Code : ABCD
======
Layout
======
Area Price
EUR 20USD
USA 30USD
this might also work out for us
======
Header
======
Code : ABCD
======
Layout
======
Area Price Group
EUR 20USD 111
USA 30USD 222
How do i achive this? we have a need to keep Group in the header area of the layout to get data from other source.
hope it is clear.
Answer:
I don't think there is any way to make the layout do what you want because only one value can be shown in the header at a time, regardless of whether it is hidden or not. In any case, what do you mean by "... need to keep Group in the header area of the layout to get data from other source"? Maybe if you can elaborate on what you are trying to accomplish, i.e. what data are you getting from other source and how would keeping Group in the header area enable you to get the data, it could help generate other ideas.
_________________
CF