Kimball GroupDecember 2007 - Kimball Group
  • Home
  • Resources
    • Kimball Techniques
    • Books
    • Articles & Design Tips
    • Kimball Forum
  • About
  • Contact
  • More about the Kimball Group Reader (Kimball/Ross, 2016)

Kimball Group

More about the Kimball Group Reader (Kimball/Ross, 2016)
  • Home
  • Resources
    • Kimball Techniques
    • Books
    • Articles & Design Tips
    • Kimball Forum
  • About
  • Contact

Monthly Archives: December 2007

  • Home /
  • All Tips/
  • 2007 /
  • December

Design Tip #97 Modeling Data as Both a Fact and Dimension Attribute

  • Ralph Kimball
  • December 11, 2007

In the dimensional modeling world, we try very hard to separate data into two contrasting camps: numerical measurements that we put into fact tables, and textual descriptors that we put into dimension tables as “attributes”. If only life were that easy… Remember that numerical facts usually have an implicit time series of observations, and usually participate in numerical […]

Categories

  • Before Diving In
  • Project/Program Planning
  • Requirements Definition
  • Data Architecture
  • Dimensional Modeling Fundamentals
  • Dimensional Modeling Tasks
  • Fact Table Core Concepts
  • Dimension Table Core Concepts
  • Advanced Dimension Patterns & Case Studies
  • ETL and Data Quality
  • Technical Architecture
  • Business Intelligence Applications

Archives

  • 2015
    • December
    • November
    • October
    • September
    • July
    • June
    • May
    • March
    • February
    • January
  • 2014
    • July
    • June
    • May
    • March
    • January
  • 2013
    • August
    • June
    • May
    • February
  • 2012
    • July
    • May
    • February
  • 2011
    • November
    • August
    • June
    • May
    • April
  • 2010
    • December
    • October
    • September
    • February
  • 2009
    • October
    • August
    • June
    • May
    • March
  • 2008
    • November
    • September
    • August
  • 2007
    • December
    • October
    • July
  • 2006
    • July
    • June
  • 2005
    • December
    • March
  • 2004
    • October
    • March
    • February
    • January
  • 2003
    • October
    • June
    • April
    • March
    • February
    • January
  • 2002
    • November
    • September
  • 1999
    • December
  • 1998
    • December
    • May
  • 1997
    • August
    • July
  • 1995
    • December
The Kimball Group. All Rights Reserved. Spark Logix Studios