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.

Thanks.

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