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"
Vamsee Krishna Mandlem replied
Yes. you can use NoFilter() on dimensions also.
For e.g. you can count the dimension 'Country' as below using NoFilter() function.
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
Edited by: vamsee m on Jun 1, 2011 2:48 PM