Using non standard SQL queries with multiple conditions in a BI Publisher Data Model

Question

Hi there,

I've followed the documentation from Oracle on conditional queries using an if else expression wrapped around SQL data models in BI Publisher.

Creating Data Sets Using SQL Queries

I can successfully run a non SQL query with a parameter in my data model where one condition is present using the following syntax

$if{ (:p_agg_pic_acc == Yes) }$

SQL Statement

$else{

SQL Statement

}$

$endif$

But I'm struggling to find a solution if I need two conditions to be met.

So for example trying something along the lines of the approach below

$if{ (:p_agg_pic_acc == Yes && :p_agg_zero_supp == Yes ) }$

Does anyone  have any thoughts on the syntax ?

Thanks

Mark

Brendan T · Answer

use 'and' instead of &&

$if{ (:p_agg_pic_acc == 'Yes' and :p_agg_zero_supp == 'Yes') }$ SQL Statement A $else{ SQL Statement B }$

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/28709/using-non-standard-sql-queries-with-multiple-conditions-in-a-bi-publisher-data-model

Hi Mark,

Can you please try below?

$if{ (:p_agg_pic_acc == Yes) }$

$if{ (:p_agg_zero_supp  == Yes) }$

SQL Statement

$endif$

$else{

SQL Statement

}$

$endif$

Thanks.