Click here to Skip to main content
15,889,096 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi Mubin,

I need help. Is it possible if can create multiple hierachi in the one or two table within one dimension. We have entity table where we have entity and parent entity. wentityid is unique key in the table and related is based on wparentid in the same table. We have multiple geographical structure in the table and same base level is belong to different structure. My system is working fine with one stucture. but when we have same entity in two structure failing.
Is it possible if we can create multiple hierarchi in the same entity dimension. Please suggest me solutation?

Thanks for help in advance.

Regards,
Rehan Khan
Posted
Comments
Sergey Alexandrovich Kryukov 31-May-14 22:17pm    
You need to describe what "multiple hierarchy" could possibly be. Normally, the term "hierarchy" is associated with such as simple graph as tree. How can it possibly multiple or non-multiple. Your further description looks quite vague. You should better first describe the structure you keep in mind as formal relationship (if graph terms, set-theory terms or relational algebra terms, whatever seems more convenient for you), and then you could illustrate it in application terms, if it seems appropriate. Probably you would need more words to express it, but those words should be strict enough.

Some terms you are using are from relational databases. And it's known that relational model can express any preliminary defined relationship. Do you need help with modeling it? A database schema or something? Just explain more. What is your structure more exactly, what did you try and where do you see a blocker?

—SA

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900