Hide/Unhide Columns in WEBI Report output
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?