Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
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 =…