Building dynamic columns in BO Report (BO 4.0)

[Former Member]

Hi All

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.

Thanks.

[nikhil_joy2]

Hello Guruprasad,

PFB link to a good explanation how to display columns dynamically.

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

hide formula for different tables will not be easy when you have more number of columns.

another option is conditional formatting of columns based on a variable value. ie, indirectly hiding it by making background and value color white and keeping dynamic width for column.

Regards,

Nikhil Joy

[TammyPowlas]

Moved to Web Intelligence space

Please post in the proper space in the future.