Exclude one account from filter

Question

Summary: Looking to exclude a specific account from overall filter

Content (required): Is there a way to exclude one account from a filter that suppresses accounts with zero balance? I have one account that I want to show in the report whether it has a zero balance or not. All other accounts with zero balance should still be excluded.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Ray Gupta · Answer

Thank you, Nathan. For the solution and the feedback on my response.

Nathan CCC · Answer

FYI Regards "Thanks for the reply, this is in OTBI." BOTH publisher "report" "data model" (yellow) and an "analysis" (blue) are both in OTBI which is a suite of products. So you did not answer the question. The syntax of SQL is a bit different if doing a logical query in an analysis versus a publisher report data model in which you can have a dataset from an application database using traditional physical SQL or again a data set from an analysis / data source obiee using teh same logical SQL as in an analysis. But AND and OR in where clauses are the same so it makes no difference really in this case.

Here is the reference

logical sql (analysis) (report data model with dataset data source obiee/analysis)

https://docs.oracle.com/middleware/12213/biee/BIESQ/toc.htm

physical sql (report data model with dataset data source application database)

https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/index.html

Nathan CCC · Answer

Use an OR. You can do this in a physical query or a logical query. where ((account = 500) or (account <> 500 and balance <> 0))