Does anyone knows how to write logical SQL with factor query in OBIEE 12c? I couldn't find any documentation from the website. If you have experiences on that, would you please share with me? Thank you very much?
Can you please post some example of "Factor Query", please?
Thanks SonPat99, here is an example from https://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:4274185613870
select
parentid, childid,
decode( (select itemType from items where itemid =
itemsets.childid),
'S', to_number(NULL),
(select exp(sum(ln(is2.factor))) from itemsets is2
start with is2.childid = itemsets.childid
connect by prior is2.parentid = is2.childid ) ) factor2
from itemsets
start with parentid = 'BIKE'
connect by prior childid = parentid;
