How can I use a variable in my Query Filter?

[former_member603041]

I'm pretty new to SAP BI and am currently in the process of wrapping up our reporting for a current customer. I took this over from someone who's no longer with the company. Anyways, the report I'm working on is mostly done I just have one issue I need to update the query filter to exclude some of the results coming back. One of my columns the data is shown via a formula variable. I need to check result of this variable in my query filter so that we don't return any results if this value for that record is 0. Is there a way to pull the variable into the universe so that I can use it in my query filter?

[omacoder · Accepted solution]

If you want to use that formula as a query filter, it will have to be an object added to the universe, or use custom SQL.

Otherwise, can you just do a report filter on that variable within the report itself and exclude everything where the value = 0?

[former_member603041]

omacoder How would I go about adding a report filter on that variable? Is that done somewhere other than in the Query Filters section of the Query Panel?

[omacoder]

It's done in the report, not in the query panel. Please search your help document for "report filter". You'll see it's pretty easy- go into design mode, and right click in a white space on the report and choose filter from the context menu.