Home
Kimball Group Home
Search
Register
Log inDimensional Model for Property Management
Page 1 of 1
Dimensional Model for Property Management
min.emerg Mon Nov 05, 2012 11:31 am
Hello
I'm building a data warehouse that will store data associated with Property Management. The difficulty I am facing is that my current dimensional model consists of only a handful of dimensions that are individually quite large.
For instance, Property Groups consist of one or more Properties/Buildings, while Properties consist of one or more Suites. Each of these have additional attributes associated with them (such as region, and the suite type, such as Office or Retail).
As such, my Property dimension looks something like:
(PropertyKey, PropertyGroupName, PropertyName, Region, Suite, LettableSquareFootage, Sector), plus many other ad-hoc properties (such as Property Value, Landlords etc.)
I am tempted to split these into different dimensions and link them via the fact tables, but Property Groups, Properties, and Suites are implicitly associated with each other, and do not need a fact to tie them together. Is it acceptable to have a handful of detailed dimensions as I have at the moment?
I'm building a data warehouse that will store data associated with Property Management. The difficulty I am facing is that my current dimensional model consists of only a handful of dimensions that are individually quite large.
For instance, Property Groups consist of one or more Properties/Buildings, while Properties consist of one or more Suites. Each of these have additional attributes associated with them (such as region, and the suite type, such as Office or Retail).
As such, my Property dimension looks something like:
(PropertyKey, PropertyGroupName, PropertyName, Region, Suite, LettableSquareFootage, Sector), plus many other ad-hoc properties (such as Property Value, Landlords etc.)
I am tempted to split these into different dimensions and link them via the fact tables, but Property Groups, Properties, and Suites are implicitly associated with each other, and do not need a fact to tie them together. Is it acceptable to have a handful of detailed dimensions as I have at the moment?
min.emerg- Posts : 39
Join date : 2011-02-25
Similar topics» Dimensional Model for Project management software
» Question - creating a dimensional model for incident management
» Question - creating a dimensional model for facility management
» Instead of Order Management, this dimensional modeling is more for Quotation and Purchase Order management
» Property Rental Model
» Question - creating a dimensional model for incident management
» Question - creating a dimensional model for facility management
» Instead of Order Management, this dimensional modeling is more for Quotation and Purchase Order management
» Property Rental Model
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum