Search Results: Junk Dimension

• 
  Junk Dimensions with no Loading Needed

  When you are working with dimensional modeling there are some situations where several dimensional attributes don’t make since to be in any other dimension. When this occurs you can combine them into one dimension call a Junk Dimension. In this example yo

  Author:  MikeDavis     Date: 5/6/2011     Section: Blog

  tags : Cube, Dimension, DSV, Junk Dimension, SSAS
• 
  Loading a Junk Dimension with all options.

  Every time I've loaded a junk dimension, I've added the various combinations as I've needed them, not all of them beforehand. I'm currently loading one and using a T-SQL Cross Join in the data source to generate all of the combinations. Does anyone have a

  Author:  DavidStein     Date: 7/25/2011     Section: Forum

  tags : Junk Dimensions
• 
  Slow Cube Build Times

  Take a look at the following link: http://www.datamartist.com/mystery-or-junk-data-warehouse-dimensions Does the distinct count of each of your degenerate dimensions roughly equal the number of rows in your fact table? If the answer is yes, then they prob

  Author:  MMilligan     Date: 12/6/2011     Section: Forum