DataModelling - Organisation definition

View previous topic View next topic Go down

DataModelling - Organisation definition

Post  RakeshJayaram on Mon Apr 20, 2015 10:26 pm

Hi

I am in the process of modelling an transactional system, where the transaction happens b/w a supplier and manufacturer. I have created a single entity "Organisation" which has both supplier and manufacturer. ( As both are legal entities). Is this approach fine ? or should i consider modelling it as separate entities ( manufacture & Supplier). My concern is creation of a role playing dimension in SSAS or other BI tools to differentiate in reporting and also ease of identification for end users.

Do let me know your suggestions.


Last edited by RakeshJayaram on Mon Apr 20, 2015 10:27 pm; edited 1 time in total (Reason for editing : *)

RakeshJayaram

Posts : 2
Join date : 2015-04-20

View user profile

Back to top Go down

Re: DataModelling - Organisation definition

Post  hkandpal on Tue Apr 21, 2015 11:41 am

Hi,

we can keep the supplier and manufacturer in a single entity as many times they have the common attribute. Many times a supplier will be manufacturer and a manufacturer will be supplier.

thanks

Himanshu

hkandpal

Posts : 113
Join date : 2010-08-16

View user profile

Back to top Go down

Re: DataModelling - Organisation definition

Post  ngalemmo on Tue Apr 21, 2015 3:56 pm

A single entity is fine. You would simply have two role based keys on the fact referencing the appropriate organization as supplier and as manufacturer.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: DataModelling - Organisation definition

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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