Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Building dynamic columns in BO Report (BO 4.0)

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.


Former Member
Not what you were looking for? View more on this topic or Ask a question