Skip to Content

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

NoFIlter() function

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
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question