Hide/Unhide Columns in WEBI Report output

[Former Member]

We have a WEBI report which has 2 columns/measures to display the cost in EUR and USD. User would like to have the flexibility to filter the column so as to display USD or EUR cost column. Is it possible to hide/unhide column in WEBI. Can we have a input control on multiple measures so that user can dynamically select which measures they want to see on report.

Its possible in BEx Analyser using filter option on key figure. Is simillar functionality available in WEBI? We're on BO 3.1 XI. Is thre any other way to achieve this?

Thanks,

Milind

[Former Member · Accepted solution]

Hi Milind,

Why are you not writing a formula at the report level to show the measures depending on some condition like user prompt. Eg:

= If([Currency] = "USD") Then [Sales USD] ElseIf([Currency] = "EUR")  Then [Sales EUR] 

Regards,

Rohit

[Former Member · Accepted solution]

Thanks Rohit,

To implement the solution with user prompt, we need adummy object in universe on which we can create prompt using @prompt function. Is is possible to create dummy object in universe? Is there any other way?

Thanks,

Milind

[Former Member]

Hi Milind,

Detailed steps given in following link will help you dynamically hide/unhide columns in XI 3.1 SP3.

http://blog.davidg.com.au/2011/09/dynamic-measures-in-webi-on-any-data.html

Please try it and let us know if you face any issue.

[Former Member]

Hi,

You can create a variable saying

if(Currency=USD) then Show

[Former Member]

hi,

i think it is not possible to hide a column based on condition. but in webi 4.0 u have an option using which, u can hide/ show a table based on the user selection. in ur scenario, create two tables, one with value in USD and other in EU, super impose the table. then right onthe table and select "Format cell". in that u ll have a option to hide the table based on condition. select that and apply the condition.

see the follwoing url for more info : http://bihappyblog.com/2011/11/05/dynamic-visibility-in-webi/

thank u,

Edited by: aady89 on Mar 9, 2012 7:39 AM