Coulm hide in webi

[Former Member]

Hi experts,

As per my reqirement hide the column  based on promt value,

For example have taken promt based on GENDER, while selct the promt value like M in report level Employee name coloun hide

Could you please respond and expalin step by step

Tq

[Former Member]

First get the value of prompt in variable

Prompt_value = UserResponse("Prompt text")

(where prompt text = text assigned to prompt at time of prompt decalaration.

Now you can apply alerter on column which you would like to hide

alerter would be like:

Prompt_value = M then

column width = 0 pixel

remote borders & change backgroud color to white.

all these properties you can set in alterter.

I hope this will help

.

Thanks,

Swapnil

[former_member201488]

You might want to read the above post

[amitrathi239]

For Condition based column hiding use alert/Rule in webi report.

First capture prompt value in variable by userresponse function.

1. Like. Var1=userresponse(“Enter gender”)

Create rule where Gender object is equal to Var1 and format the column like white font color,border.

See attached link for alert.

http://dwbi.org/analysis/business-objects/64-conditional-column-hiding-bo-webi

[Former Member]

But you've not hidden the column - it will still show when you export to Excel and will still be included in calculation contexts. It's far more of a workaround than a solution.

[Former Member]

One way to do it is to create two tables, one with the column you want to conditionally hide and one without it. You can then set the blocks to show based on the result of the UserResponse formula.

You shouldn't need step-by-step for that as there are only three or four steps