Analytics Software

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!

Question about multiple LTS

Elena.mtcJun 16 2011 — edited Jun 17 2011

Hi,

I am currently working with the rpd and a general doubt pops up... in the physical layer I have dimensions related, like for example Person, related to another dimension City and for example Age (with Foreign Key join):
City -< Person
Age -< Person

So in order to have a true star schema in the BMM, I need to create a single logical table with these three physical tables, right? The question is how.
I can add the physical tables as 3 logical table sources, or have one single logical table source, mapped to these three physical tables.

What is the difference, if any? Can someone explain, please? I always use the first choice (multiple logical table sources, each of them mapped to one physical table), but is it better to have just one single logical table source?

Thanks in advanced :)

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 15 2011

Added on Jun 16 2011

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #table

9 comments

1,349 views