How to use....WEBI NoFilter Operator??

[dshaberkorn]

I have to create a report which contain a colum with the total per year for a "Measure" and then two or three more colums which contain a monthly periods (usually last 3 months). This month Period should be put in the imput variable created in BEx Query.

The problem is that this imput variable restricts the year Measure in the first colum for only 3 month,

I was thinking try to create a new variable using the NoFilter Opretator. I am not sure if it will works well, because I have never could work this operator correctly. I can´t create a formula without errors.

I read the On line Manual " Using Functions, Formulas and Calculations in Web Intelligence" and the Syntax should be:

expression_output_type NoFilter(expression;[All|Drill])

Can somebody give me an example how it should be?  because I can´t write the syntax correctly.

What does "expression_output_type" means ??

Thanks in advance!

[dshaberkorn · Accepted solution]

Thanks both of you guys.

Do you have any sugestion that I can use to get the Anual Amount in the First colum and in the next two or three column the detail of the months that the user want to see?? chosing in a Imput Variable??

[abkshatriya · Accepted solution]

Hi,

Can you please share a Screen shot of your current scenario and what you want....

Thanks

[former_member189638 · Accepted solution]

NoFilter will not work in your case because you are using Prompts which is a Query filter.

You need to make 2 queries in WebI.

In the 1st Query, use the Month Prompt and Drag the Month and Amount

In the 2nd query don't use any prompt.  Drag thje Year and Amount.

Now create a measure variable with the following formula in 2nd query. And use this Variable instead of the actual Amount object.

VAR = [Amount] where ([Year] = FormatDate(ToDate(UserResponse(<Month Prompt Text>);"MM/yyyy");"yyyy"))

(Assuiming your month format is 03/2009. If not then use the correct format in ToDATE function.)

[Former Member · Accepted solution]

Similar operator question, i am trying to use conditional formatting and it changes when i add Filter bar. and the condition says anything above the average(calculated column). is there any way to work around that?

[Former Member]

Dear All,

Can anyone explain how to use "no filter" in Bex Query Designer?

[abkshatriya]

Hi Karthik,

"No FIlter" is a function of WEBI. it is not available in BEx Query Designer.

Thanks

[abkshatriya]

Hi,

NoFilter will work only for BLOCK filter not for Query Filter..

Thanks

[former_member189638]

Examples

1. When placed in a block footer, NoFilter(Sum([Sales Revenue])) returns the total sales revenue of all possible rows in the block, even when rows are filtered out of the block.

2. NoFilter(Sum([Sales Revenue]);All) returns the sum of the sales revenue for all countries including France, even though there is a filter that excludes France from the report.

3. NoFilter(Sum([Sales Revenue]);Drill) returns the sum of the sales revenue for all countries, even when there is a drill filter on the [Country] dimension.

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

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