Oracle Analytics and AI

Shiva Uppushetty

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

Mallikarjuna Kuppauru-Oracle

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