I am trying to filter my query to only retrieve rows from SAP BW with a measure value greater than 0. For example, if the query originally pulls:
I would only want the query to retrieve:
The dataset consists of over 2 million rows therefore the query must limit the data retrieved as opposed to filtering after retrieval. I have copied below the current query from Advanced Editor and bold and underlined the measure that I would want to apply the greater than 0 parameter. I would greatly appreciate support on this!