Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

OBIEE 12c Logical SQL with Factor query

Received Response
1
Views
2
Comments
User6449762
User6449762 Rank 1 - Community Starter
edited Aug 13, 2024 5:41PM in Oracle Analytics Forum

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?

Answers

  • SonPat99
    SonPat99 Rank 6 - Analytics & AI Lead

    Can you please post some example of "Factor Query", please?

  • User6449762
    User6449762 Rank 1 - Community Starter

    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;