Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

How I can associate a table with my new fact in Business model diagram

Received Response
12
Views
1
Comments
Sangeeta Pandey
Sangeeta Pandey Rank 6 - Analytics Lead
edited Aug 13, 2024 5:13PM in Oracle Analytics Cloud and Server

Hello Experts,

I can see table Dim - Insurable person in physical diagram however not in business model diagram:


Physical diagram:

Business model diagram:

I guess this happened because this was common table between 2 fact tables and hence was already present in BMM layer and hence I did not drag from physical to BMM again with my new fact table .

I am not sure how I can associate this table with my new fact in Business model diagram?

Kindly help.


Thanks,

Answers

  • Sangeeta Pandey
    Sangeeta Pandey Rank 6 - Analytics Lead

    Hello Experts,

    I managed to associate a new dim table to fact table in business model diagram using foreign key option in fact table at BMM layer ( as depicted in below ):

    However , I do not see foreign key listed here for other table joins in Business Model Diagram. I see only foreign keys which I manually created to map a new table to business model diagram. The foreign keys for those dim tables are not listed here which were dragged from physical layer to BMM layer along with fact table.

    Is it expected ?


    Thanks,