nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

How to model in the web bases semantic modeler a Fact table with multiple joins to same dimension

User_Q5S8S

Hi!

I have a Fact Enrollment table, i have enrollment dates, but also completion dates. I have a Calendar dimension. I am trying to implement the best way possible the joins. I have been reading and there are multiple ways, but I am not sure what way to go. In the physical layer I cant join twice on the same calendar dimension by the two dates: enrollment and completion.

Thanks in advance any help is much appreciated

Find more posts tagged with

Accepted answers

Chere-Oracle

Yes, the logical dims should have the physical aliases as their source tables.

All comments

Chere-Oracle

Hi. Create aliases for your dimension physical table—one alias per join to the fact table.

User_Q5S8S

Perfect! Thank you so much.

That means I need to have those new replicas in my logical layer as well right?

Chere-Oracle

Yes, the logical dims should have the physical aliases as their source tables.