Building dynamic columns in BO Report (BO 4.0)
To start with I am new to BO and using reporting tool
I have a requirement to create a WEBI report which contain a table with a feature to hide / remove columns based on input selection. ( dynamic columns)
I tried to do this by following concept
In my test scenario table has 3 columns. user will select which columns to show when refreshing the report.
I created 4 tables .
table 1: column 1, column 2 and colum 3
table 2: column 1, column 2
table 3: column 1, column 3
table 4: column 2, column 3
all tables were overlapped in display.
I am trying to hide the table using the property which is available in table properties "Hide when following formula is true"
to display table 1: formula is as follows
=UserResponse("Enter Column") = "column1;column2;column3"
The problem doing this way is
1. selection should happen in a given order
2. If there are mulitple columns , it doesn't make sense to create multiple tables as combination of columns increases.
Is there a better formula to set using user response to achieve the above.
Is there any better way to achieve the above generally.
any suggestion and guidance will be appreciated.