Skip to Content
Sep 28, 2018 at 07:39 PM

How can I use a variable in my Query Filter?

1209 Views Last edit Sep 28, 2018 at 07:38 PM 2 rev

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?