tag:blogger.com,1999:blog-7325550215422085906.post8752746342894938529..comments2024-03-28T12:51:00.793+05:30Comments on DATAWAREHOUSE CONCEPTS: Dimension Hierarchies in OBIEE:Level-Based Hierarchy and Parent-Child HierarchyUnknownnoreply@blogger.comBlogger7125tag:blogger.com,1999:blog-7325550215422085906.post-74504529094506322412019-12-09T13:26:05.922+05:302019-12-09T13:26:05.922+05:30each child requires to also acts as a parent in is...each child requires to also acts as a parent in is-a-relationship.<br />eg: employee reports to manager, manager is also an employee<br />each employees has a role, level , band, salary type, which are all the attributes of an employee, so it is has-a-relationship and it is level-based-hierarchyAnonymoushttps://www.blogger.com/profile/06299741784940289210noreply@blogger.comtag:blogger.com,1999:blog-7325550215422085906.post-69924661955181851202019-12-09T13:20:35.731+05:302019-12-09T13:20:35.731+05:30level-based relation : has-a-relation
value-based-...level-based relation : has-a-relation<br />value-based-relation : is-a-relation<br />Anonymoushttps://www.blogger.com/profile/06299741784940289210noreply@blogger.comtag:blogger.com,1999:blog-7325550215422085906.post-41376942312773059962019-12-09T13:16:53.180+05:302019-12-09T13:16:53.180+05:30employees in the company are organized in levels b...employees in the company are organized in levels based hierarchy with each employee having designation (level ) ,as well each employe is assigned to manager ( employee) ,who in turn reports to his manager ( employee) which indeed also arranged in parent-child heirarchy fashion.<br />Anonymoushttps://www.blogger.com/profile/06299741784940289210noreply@blogger.comtag:blogger.com,1999:blog-7325550215422085906.post-82986732581487053692019-07-11T21:35:29.740+05:302019-07-11T21:35:29.740+05:30A dimension contains two or more logical levels. F...A dimension contains two or more logical levels. For example, a Time hierarchy might have three levels for Year, Quarter, and Month. Level-based hierarchies can also contain parent-child relationships.<br /><br /> This is interesting, can you show me how can I do it please? <br /><br />Thanks Ritchhttps://www.blogger.com/profile/10474374372359506404noreply@blogger.comtag:blogger.com,1999:blog-7325550215422085906.post-36672093481503001702019-02-07T16:46:58.922+05:302019-02-07T16:46:58.922+05:30In Finding Nemo, the sharks and fish forge a new f...In Finding Nemo, the sharks and fish forge a new friendship.The sharks even recite a membership pledge to show their dedication to their new friends: "If I am to change this image, I must first change myself. Fish are friends, not food." The relationship between the sharks and fish begins as predator and prey but ends in a lasting caring friendship. Sometimes relationships between parents and teachers can be like this. <a href="http://parentingteenagersacademy.com/" rel="nofollow">parenting teenagers advice</a><br />MR MADhttps://www.blogger.com/profile/11006091473803841039noreply@blogger.comtag:blogger.com,1999:blog-7325550215422085906.post-19004104923494707672014-03-26T09:22:13.375+05:302014-03-26T09:22:13.375+05:30This comment has been removed by a blog administrator.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7325550215422085906.post-26268814150314667112012-12-20T15:31:34.821+05:302012-12-20T15:31:34.821+05:30Level-based hierarchies can also contain parent-ch...Level-based hierarchies can also contain parent-child relationships.<br /><br />Can someone explain how to do this? <br />Or at least, paste link where can read details how to do it?<br />Thx!!Anonymoushttps://www.blogger.com/profile/08886424626511753846noreply@blogger.com