WAD Chart problem

[Former Member]

Hello All,

I made a Bex query for a chart in WAD, it contains columns in 2 levels. For example, Company Code(5 company codes) and Month(3 months). When i see the out put of the chart, Company code text is being repeated for each month.

But if i see the same query in the Table object, company code is not repeated for all months, i.e for the 3 months, company code is appearing only once. But the same thing is not happening in Chart. If we have large numbr of Company codes, then Chart looks not very clear.

Could you please explain how can I do it in WAD Chart.

Regards,

Ravi

[Former Member]

in the chart x-axis,

column description for example one company code looks as

ccode/mon1 ccode/mon2 ccode/mon3

but i would like to see

ccode/mon1 mon2 mon3 like in table.

Please let me know how i can do this?

regards

ravi

[former_member184494]

Ravi ,

things that might be causing this :

1. Multiplpe structures ? one above the other ?

2. You said this does not occur when one CC is selected but happens when multiple CC are selected ?

Could you give a layout of the data table the way it is versus the way you want it to be like

CC | Mon 1 | Mon 2 | Mon 3

100 | 123 | 234 | 345

200 | 234 | 345 | 456

Is this the way you want it ?

P.S I know CC is a 4-digit value but gave too little space.

Arun

[Former Member]

Hi Arun,

1. Multiplpe structures ? one above the other ?

--> One characterstic for company code and one structure for Months.

2. You said this does not occur when one CC is selected but happens when multiple CC are selected ?

--> It is occuring even when i select one company code. What i meant was, when see the data in table it is showing the in the required format.

i want the format as below in the WAD chart X-axis:

CC1

mon1 mon2 mon3

but now it is showing

CC1/mon1 CC1/mon2 CC1/mon3

Hope it is clear for you.

Please let me know how i can solve this problem.

Regards,

Ravi.

Message was edited by: Ravi Pasumarty

[former_member184494]

Ravi , one way to do this would be to have CC above the structure for KF , something like

CC

Structure

--KF1

--KF2

If you have your characteristics in this format in the columns , you will get the structure desired , if this does not work , try creating a structure for characteristiocs and having it above the structure for KF

Structure

--CC

Structure

--KF1

Hope this helps..

Arun

[Former Member]

Arun, thanks for your response.

currently i am having in the columns

CC

Structure

--KF1

--KF2

which is not providing desired format.

but already i have one structure in the rows,

and according to your suggestion i have to create

Structure

--CC

Structure

--KF1

in columns. According to my knowledge, Bex cant support, 3 structures in a query.

do you have any other ideas?

Many thanks,

Ravi.