Home > Business objects Web Intelligence > Hide a column in Web Intelligence

Hide a column in Web Intelligence


How to hide a column in WebI

In this post I would like share some information on how to hide columns using alternate and manual methods. The illustrative example report is created from Efashion sample universe in BOXI 3.1.

Let us take the following example,

Here we have a column named “promotion (y/n)” which might not give more information regarding the promotion, so we intend to hide this temporarily until the client/customer asks for it.

Now we are going to hide this column from the block using alerter option from Web Intelligence, following screenshot shows exact report layout before hiding any columns

image

Steps to implement the alerter:

1. Click the alerter option in the reporting toolbar, a new window will open as shown in the sample screenshot below,

clip_image006

2. In Sub – Alerter formula, provide some formula that is always true like the one shown below,

= [Promotion Cost USD] = [Promotion Cost USD]

= 1 = 1

Similarly you can come up with many formulas that returns true.

3. Now go to format option and format everything to match you Web Intelligence background like cell content, border and background colors as shown below in the following screenshot.

clip_image008

4. Now select the column that you wanted to hide and activate the alerter,

clip_image010

5. Go to alerters at reporting toolbar and enable it, then the selected column will be hided from the layout.

image

Hiding completed??

No

Did we notice the column header in above screenshot, why we missed to hide the column header?

In WebI, both are considered as separated layout since column headers are differently formatted from column values fields.

6. Now select the column header and again apply the alerter to hide it.

image

7. The same hiding process can be done by simply formatting the column to match the background color of WebI and resizing the column width.

8. This manual process and alerter based hiding will work only at the display level meaning when the report is exported as excel, we will be seeing the hidden fields. However PDF does the job, it won’t display the column that is hidden in WebI.

Advertisements
  1. Chris
    August 19, 2013 at 8:28 pm

    Great stuff. Works a treat.

    Many thanks.

    Like

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: