Skip to Main Content
Forums

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!

WID columns in Dimension

802660Oct 3 2010 — edited Oct 4 2010
Hi ,

I am new to obiee and was going throught the samplesale schema that comes with the installation.

I found that Dimension column also caontains other WID columns apart from the ROW_WID column.As far as my understanding, the ROW_WID colums are the Primary key.

So what is the purpose of other WID columns in DImension.Are they foreign key to other dimensions.If yeas, then that would be a snowfake schema.

Ca someone help me to understand this ?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2010
Added on Oct 3 2010
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
2 comments
1,177 views