Dimensions question

View previous topic View next topic Go down

Dimensions question

Post  hespinoza on Mon Oct 14, 2013 4:21 pm

I'm working on my first Data warehouse project.  I'm starting with the basic, identifying business requirements/business processes, initial bus matrix and proritizing my business requirements.  That's on itself is hard to identify, however, it seems that  I have a good start.  For the bus matrix I'm trying to figure out what are the dimension for each of my business processes.  I need your advise on how to establish some of my dimensions.  I'll try to explain the layout of my data as best as possible.  Below is a hopefully clear layout of 4 tables in my database.  The business requirement and business process that I'm identifying here are "report employee location aquisition" and "Location Adquisition" respectively.  An employee can adquire one or more LandLocations which can reside on one or more counties.  How can I define dimension for my bus matrix here?  It seems that I have three dimensions Employee, LandLocation and County but I'm repeating again my database structure isn't?  Any guiadance would be very appreciated.

tbl_Employee
EmployeeID

one to many

tbl_EmployeeBuysLandLocation
EmployeeID
LandLocationID

many to one

tbl_LandLocation
LandLocationID
Field1
Field2
Field3

one
to
many

tbl_LandLocationCounty
LandLocationID
CountyID
Size

many
to
one

tlb_County
CountID

hespinoza

Posts : 5
Join date : 2013-02-19
Location : Midland, TX

View user profile

Back to top Go down

View previous topic View next topic Back to top


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