How can I add filter for a field by using a formula in SAP BO Webi..

[Former Member]

Hi experts,

I want to put a filter into my webi report for date field, after refresh the webi report. By just right clicking on top of the characteristic column and giving a constant date vale I can do. But the issue is actually i want to filter the posting_date field by using a formula ( <=UserResponse("key date"))... So how can I do this? Is there is away to this in BO? Please help me..

Thanks,

Regards,

Nimesha....

[Former Member]

[Former Member]

Hi Amith,

Thanks for replying. I need to add the filter in infoview level not in query level... So how can I create a formula for that? see my uploaded images.. (this is the report that i'm expecting  to put the filter as  I explained previously). Your formula will not help my task. (see the red colored arrow of the uploaded images). That is where i'm currently using the filter. Problem is when I refresh the report each and every time I have to insert the filter manually. Please help me.

Thanks,

Reagrdars,

Nimesha

[Former Member]

Hi Amit,

I need to correct my comment.. Problem is when I refresh the report each and every time I have to change the date for the posting date filed that we are filtering.

[amitrathi239]

Hi,

Direct option is not in the webi.

workaround.

create Key Datevariable =UserResponse("key date")

Then create Posting Date Variable. =(Posting Date]) where ([Posting date]<={Key Date])

add filter on block level Posting Date variable is not NULL.

or create condition like Test =if(([Posting date]<={Key Date])) then [Posting date] else "1/1/9999"

Add filter where Test not equal to 1/1/9999

Thanks,

Amit

[amitrathi239]

HI,

Can you explain in details what is your requirement.

as per my understanding you want all less than or equal posting date based on the date entered by user.

Key Date=UserResponse("key date")

so you can write a formula. =(Posting Date]) where ([Posting date]<={Key Date])