Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

One Hierarchy in two dimensions

2 posters

Go down

One Hierarchy in two dimensions Empty One Hierarchy in two dimensions

Post  fabriciabarbosa Wed Aug 20, 2014 11:16 am

Hi, Everyone

I have a question that is a problem for me.

I have to design a logical multidimensional model and MER for database too.

In the business model we have supplies and customers that shared the location hierarchy.

Customer
Name
Age
City of customer
state of customer
country of customer

Supplier
Name
Age
City of Supplier
state of Supplier
country of Supplier


Question: Can I create a location hierarchy and reuse it? If yes, how I design this in the MER?

Thanks in Advance!
Fabricia Barbosa

fabriciabarbosa

Posts : 3
Join date : 2014-03-12
Age : 46
Location : Recife, Brazil

Back to top Go down

One Hierarchy in two dimensions Empty Re: One Hierarchy in two dimensions

Post  ngalemmo Wed Aug 20, 2014 9:53 pm

You could. What is a MER?
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

One Hierarchy in two dimensions Empty Re: One Hierarchy in two dimensions

Post  fabriciabarbosa Thu Aug 21, 2014 1:15 pm

Hi, ngalemmo

thanks for the attencion.

Sorry about the MER, it means Entity Relationship Diagram (ERD) in portuguese.

My question is about how use the same hierarchy in the ERD. How to organize the tables. If I can reuse a hirarchy, I can use star model to this design?


thanks in advance.
Fabricia Barbosa

fabriciabarbosa

Posts : 3
Join date : 2014-03-12
Age : 46
Location : Recife, Brazil

Back to top Go down

One Hierarchy in two dimensions Empty Re: One Hierarchy in two dimensions

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum