Who is online?
0
guests and
1
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: Junk Dimension
3 results found
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
Page 1 of 1 (3 items)