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?
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/
Edited by: aady89 on Mar 9, 2012 7:39 AM
Detailed steps given in following link will help you dynamically hide/unhide columns in XI 3.1 SP3.
Please try it and let us know if you face any issue.