Oracle Fusion ERP Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion ERP Analytics

Categories

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

Snowflake Schema in FDI

Received Response
23
Views
1
Comments
Shiva Uppushetty
Shiva Uppushetty Rank 3 - Community Apprentice
in Oracle Fusion ERP Analytics

Hello,

Is it possible to join Dimension to Dimension in FDI? In an existing logical star, we have requirement to join a OOTB dimension table with custom dimension hierarchy table.

Regards,

Shiva

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics & AI Strategist

    Hi @Shiva Uppushetty

    Please refer documentation -

    Refer -About Semantic Model Customization

    • Manage Logical Star - create a new or modify an existing logical star. You start by creating a fact, then add dimensions, and then joins. You modify an existing logical star by adding dimensions, attributes, and other tables. You can add dimensions to existing ready-to-use facts while creating a new logical star. You can create many logical stars.

    Regards,

    Arjun