tag:blogger.com,1999:blog-33209370.post8596642167549355030..comments2009-07-22T18:40:36.120ZAdrian Wardhttp://www.blogger.com/profile/12467688997292586407noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-33209370.post-7148266844074530342009-06-25T01:09:08.505Z2009-06-25T01:09:08.505ZCircular Join can be avoided my using Aliases. In the above example , create an alias for Table1 and then you can model without a CJJoehttp://www.blogger.com/profile/08946358677234455433noreply@blogger.comtag:blogger.com,1999:blog-33209370.post-53597116372592687042009-06-23T07:05:17.187Z2009-06-23T07:05:17.187ZHaving just tried to model a 3NF structure from Ebiz suite (and given up) I&#39;d like to understand what is possible here. My basic understanding is that a table has to be either a dimension or fact, and OBIEE makes this distinction based on the relation direction (1 end is the dimension, many end is the fact). So what do you do when you have what I call a circular relationship with 3 tables:<br />Table 1:Table 2 1:M<br />Table 2:Table 3 1:M<br />Table 3:Table 1 1:M<br /><br />If anyone has some time I&#39;d like to send you the actual ERD for your views, let me knowSteve Devinenoreply@blogger.comtag:blogger.com,1999:blog-33209370.post-76830303072105637812009-06-23T07:03:02.846Z2009-06-23T07:03:02.846ZHaving just tried to model a 3NF structure from Ebiz suite (and given up) I&#39;d like to understand what is possible here. My basic understanding is that a table has to be either a dimension or fact, and OBIEE makes this distinction based on the relation direction (1 end is the dimension, many end is the fact). So what do you do when you have what I call a circular relationship with 3 tables:<br />Table 1:Table 2 1:M<br />Table 2:Table 3 1:M<br />Table 3:Table 1 1:M<br /><br />If anyone has some time I&#39;d like to send you the actual ERD for your views, let me knowSteve Devinenoreply@blogger.comtag:blogger.com,1999:blog-33209370.post-83217211651365434502009-06-19T14:12:50.394Z2009-06-19T14:12:50.394ZIntegrate OBIEE with workspace.<br /><br />Try Single Sign on for workspace.kaustubhnoreply@blogger.comtag:blogger.com,1999:blog-33209370.post-85661581321946502432009-06-18T11:33:59.113Z2009-06-18T11:33:59.113ZModeling 3NF structurs in OBIEE should also be avoided by newbies.<br /><br />Cheers,<br />StijnStijnhttp://www.blogger.com/profile/07408770317929770226noreply@blogger.comtag:blogger.com,1999:blog-33209370.post-62655763856897262342009-06-17T14:04:05.363Z2009-06-17T14:04:05.363Za.) Shouldn&#39;t you be posting somewhere else?<br /><br />b.) 5 an 8 are definitely ugly :-PChristian Berghttp://www.blogger.com/profile/00238714807983505453noreply@blogger.com