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?