Hide Column in BEx Analyer using customer exit variable

[Former Member]

Hello,

i'm searching for a solution to hide some columns in my query/workbook after the user selected a special variable. how can i do this with a customer exit variable? i can't find any attributes or something else to hide a column

can someone help me?

[hendrik_brandes]

Hello Homer,

this is not so easy, if you cannot "deselect" some of the data.

E.g. if your columns are type 0CALYEAR, it is simple, to select via a customer exit, which results in a E EQ selected year.

For other columns, you will have to select with the negative value of the column value.

Kind regards,

Hendrik

[Former Member]

so i have to calculate in my user exit code the negative value and then suppress all column with data zero?

is there any other solutions?

[former_member182470]

It is not possible to hide columns in run time. You can pre-define them to Hide in Query designer.

You can try with -ve values idea too

[hendrik_brandes]

I meant to "de-select" the column value - not to deliver the value.

E.g. Columns are 0CALYEAR. So you should only select all valid 0CALYEAR.

Hiding the column due to the "supress-zero" option will be another solution but not so easy, because you will have to know how to bring them to zero.

Some more ( with much development effort ) options:

* Virtual Keyfigures with option "Supress on zero")

* A Virtual InfoProvider with option "Supress on zero")

Kind regards,

Hendrik

[Former Member]

Hi Homer,

I second Hendrik on this.

Br, H