how to hide a row in a table in webi

[former_member201536]

Hi All

I have a table that will display 7 rows dynamically now now my issue is one of the row has one column with "Null", Now I want to hide that row in preview.

How can I achive this in Webi.

Thanks in advance.

Siva

[arijit_das · Accepted solution]

use a report level filter : [Column] Is not null

If the value is Null(a string with "Null" value), the you can use the following filter: [Column] Not Equal to Null

[former_member201536 · Accepted solution]

Thanks for your reply @Arijit.

But where can we find the report level filters?

Sorry for asking somany question I am new to webi

[Former Member · Accepted solution]

Hi Siva,

Right click on the block and select filters as shown in snapshot below.

[arijit_das · Accepted solution]

[former_member201536 · Accepted solution]

Thanks for your reply @Ambreen Quadri

Which version of the BO are using as I can't see any filter option when I right click on block.

[former_member201536 · Accepted solution]

If I place the filed in filter pane then I am able to select the required option but can't see the options as shown by you.

I think BO version is different.. I am using BO 3.0 can you please help me for that version.

[arijit_das · Accepted solution]

Select the block to be filtered.

[Former Member · Accepted solution]

Hi Siva,

Under Analysis Tab you can find the filter option

[former_member201536 · Accepted solution]

Thanks Arijit your answer is very much helpful to me..

I have one more query.

1.I am developing the non Adhoc reports so my question here is if I add filter while development then if client opens it after delivering then the same filter will be aplied at that time.

2. This filter is applied on whole report I want only to that block, Can you please suggets me how to limit to block.

Thanks for your support.

[former_member201536 · Accepted solution]

Thanks sushma for the answer I could able to solve the issue.

[arijit_das · Accepted solution]

1. The filter, once saved, will be applied to all users viewing the report.

2. You can apply such filter to a particular block or to entire tab.

- To apply the filter to a particular block, select the block(click on any cell in the block) and then define the filter.

- To apply the filter to entire tab, click on any white space inside the report and then define the filter.

You can navigate to Map > Structure to see the report level filters and block level filters as a tree view. A report level filter will always be applied to all blocks inside the report while the scope of a block level filter is restricted to that block only.

[Former Member]

Hi Siva,

Two ways to apply filters in BO XI3.1. Have a look at this example in which I have a webi report based on e-fashion universe. I am extracting two columns: State(dimension) and Extended Price (Measure).

Suppose that I would like to apply the filter on Extended Price to eliminate the null values:

Fist way: Click on the icon: Show/Hide Filter Pane on the left, this area will be displayed:

In this area drag and drop "Extended Price":

The following window will be displayed: You should choose the operator "Is Not Null" then click on "OK"

Second method:

Click on "Edit Query" icon, a new window will be displayed in which you can applt your filter by dragging and dropping "Extended Price" in the Query filter area:

Click on the arrow in front of the default operator displayed then choose "Is not null" among the operator list appearing then click on "Run Query":

I hope that this is clear for you.

Best regards,

Wafa

[former_member201536]

Thanks wafa for the answer I could able to solve the issue.

[former_member221192]

hi,

plz find the screen shot,,