NoFIlter() function

[Former Member]

Hello everyone,

Can we use Nofilter() function on dimensions instead of measures?

when i am trying to use this function on dimensions i am getting the below error:

"Unable to retieve the first page of the current report. Error WIJ 20003"

[Former Member · Accepted solution]

hi,

Yes. you can use NoFilter() on dimensions also.

For e.g. you can count the dimension 'Country' as below using NoFilter() function.

=NoFilter(Count([Country]);All)

NOTE:

1) NoFilter (expression;Drill) does not work in query drill mode because the drill filters are added to the query rather than applied to the report data.

2) If you end drill mode with drill filters applied, the drill filters become report filters and can change the value of any expressions to which NoFilter(expression;Drill) is applied.

Source: BO WEBI Help guide

Regards,

Vamsee

Edited by: vamsee m on Jun 1, 2011 2:48 PM

[Former Member · Accepted solution]

what you are doing here (=NoFilter(Count([Country]);All) ) is nothing but using NoFilter() for Measure because Count([Country]) will always gives us measure value.

if suppose i have a set of 10 countries in my country dimension in the database level. And in the query i am using one filter; Country Not Equal to Germany. Now in the dimension we will have 9 countries except germany on the report level. if i want to display Germany also as one of the values of Country Dimension without removing the query filter. then can we use NoFilter() function to achieve this result. if NoFIlter() wont work here, then what is the other alternative that we can use to get the desired result.

[Former Member · Accepted solution]

Hi Vamsee,

Can you help me on the below issue :

I have webi report in both XIR2 and the same report has been migrated to XI4.1 and I m having issue with the block level filters after the migration in XI4.1

XI R2 Report :

Date                   Count(ID)          NoFilter(Count(ID)  Count(ID)/

                                                                              NoFilter(Count(ID)   ABC

6/30/2013	2	76	2.63%	0
9/30/2013	4	76	5.26%	0
12/31/2013	2	77	2.60%	0
3/31/2014	2	78	2.56%	0
9/30/2014	2	84	2.38%	0
12/31/2014	2	84	2.38%	0

In XIR2 I have applied a block level filter i.e on column ABC in the report level to show only the records which satisfy the condition eqaul to 0. Sothe result is correct in XIR2

XI R4.1 Report :

Date                   Count(ID)          NoFilter(Count(ID)  Count(ID)/

                                                                              NoFilter(Count(ID)   ABC

6/30/2013	2	76	2.63%	0
9/30/2013	4	76	5.26%	0
12/31/2013	2	77	2.60%	0
3/31/2014	2	78	2.56%	0
6/30/2014		81		1
9/30/2014	2	84	2.38%	0
12/31/2014	2	84	2.38%	0
3/31/2015		78		1

When I applied the same block filter i.e; on ABC in the report level to show only the records which satisfy the condition equal to 0. But is showing the additional records which has the values of ABC=1 which is in correct in XI 4.1

Please help...

Thank You.

[Former Member · Accepted solution]

Hi Jagadeesh,

In 4.1 system, recreate the block filter- delete existing, save and then create fresh.

For testing, save a copy in your favorites and try this.

-Jagadish