Can we interchange the Axis objects in web intelligence.

[Former Member]

Hi, All.

I have a report,  in that Bar chart has Dimension and Measure objects.. I would like to interchange dimensions. Is it possible in Web Intelligence?

Thanks in  Advance...

Arjun.

[sateesh_kumar1]

Hi Arjun,

You can achieve it with Input controls Custom value property .

Let's say you have month , week and sales.

You want to change the month and week in chart.

1.create a variable with default value

Choose Dimension

Month (don't put =Month, it'll give error)

Place this in input control, in Custom values , enter value Week

Create another variable

=If([Choose Dimension]="Month";[Month];If([Choose Dimension]="Week";[Week]))

use this variable in charts.

change your selections with Input control.

[kohesco]

Hi,

I'm afraid no, If you are not a key user.

But no stress if the requiement is to play bewteen predefined views, then you can achieve it, while using dynamic visibality, see doc http://scn.sap.com/docs/DOC-54818

I used to interchange table and grapgh.

Grtz

Koen