Can we hide column in a query depending upon the variable selected

[Former Member]

Hi all,

let us say my report have 10 column.

now i am giving user option to select the values (let us say 'a' or 'b')

columns must be displayed depending upon the value selected by user ..

for example if user has selected 'a' then first five columns should be displayed..and if user has selected 'b' last five column should be displayed..(it will be OK even if we can hide the columns depending upon the selection )

Is it possible in BEx...please let me know

[Former Member]

Closing the thread

[Former Member]

If your columns are characteristics then you could use hierarchy variables. This is not possible for key figures, although you do have the option (mentioned above) of hiding key figures but allowing them to be shown in the query.

[Pravender]

Is it for key figure or characterstics?

Please do not post duplicate threads.

Edited by: Pravender on May 14, 2010 12:58 PM

[Former Member]

Hi

Pravender ,

I want to hide key figures.

Sorry for duplicate posting.

[shanthi_bhaskar]

we cannot have that option to hide automatically, one option is the hided kf's can be shown in the query... by selecting the property by hide and can be shown

[Pravender]

I did it sometime back. A bit complicated process.

Create an infoobject, manually enter the values "keyfig1" and "keyfig2".

Include this infoobject in the filters and restrict it using a "ready for input" variable.

Now create two formula variables.

Write a customer exit such that when you select "keyfig1", first formula variable's value should be set to 1 and other one's to 0.

Then in the query create two calculated key figures, multiply both with the formula variable. Also supress column (all active value == 0).

Then it will show the key figure which you have selected.

Pravender

[Former Member]

thank Parvender for reply,

But i want key figuresto be displayed on existing Characterstics..

Do i need to do same process for that.

Edited by: milind dange on May 14, 2010 2:18 PM

[Pravender]

Do you mean that you do not want to include additional infoobject?

What you can do is you can create an multiprovider and include in it. Then create a query over multiprovider.