Skip to Main Content

Oracle Analytics Cloud

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Semantic data modeling questions

brenda_strongFeb 4 2024

I’ve really been working hard to understand how this data modeling should work, but there are a few things I I’m having a hard time understanding

Here’s the Link I am currently studying. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsmd/plan-semantic-model.html#GUID-99680D14-8751-4E53-81E6-EE704DFB3EF0

Here are some things I DO understand now

  1. Joins are all created with the arrow pointing to the ‘many’ side of the join
  2. Models should be created with a star or snowflake pattern. (I don’t really understand the snowflake model).
  3. Hierarchies are created with logical dimensions if you want to drill down
  4. I’ve created a calendar dimension table for drilling

Here are my questions that I don’t understand.

  1. How to determine when to use left join in the BMM
  2. How to determine cardinality in the BMM (these two questions are confusing me because of the way they are joined in the physical layer.)
  3. How to organize the tables. The link above says tables are to be conformed by being combined into one view. Does this mean that I should write a view combining them and then import that metadata? Or does it mean rather that the tables are combined by dragging into one logical table and joined that way? FYI I do understand this doesn’t mean combining all of the tables, but just the related details that would prevent making the star model work.
This post has been answered by Christian Berg-0racle on Feb 8 2024
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked by Renae Stout-Oracle on Jul 8 2024
Added on Feb 4 2024
13 comments
972 views