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!

RPD - Physical layer model design

User_E9OMMJul 9 2014 — edited Jul 9 2014

Requirement is to build a data model for a given complicated SQL.

Query is having all dimension tables. The joining relationship between the tables is like this - >

T1(one)->(many)T2

T2(many)->(one)T3

T3(one)->(many)T4

T3(one)->(many)T5

What can be done to design the data model in physical layer of OBIEE RPD ?

( We can for a time being use direct database request to create report out of sql query. However we have been asked to design a model. )

Please let us know your views. Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 6 2014

Added on Jul 9 2014

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

3 comments

160 views