Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

User6449762 Rank 1 - Community Starter

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 =…