Report Portal

Ignore Unrelated Dimensions in a SSAS Cube

Let me re-post a very useful articel by Bryan C. Smith about unrelated dimensions in a cube. The same topic as tackled in a very good SSAS Webcast by Craig Utley. By Bryan C. Smith - http://hccmsbi.blogspot.com/2007/07/ignoreunrelateddimensions.html

Imagine you have a highly simplified Adventure Works cube. In this cube, you have two measure groups, Reseller Sales and Internet Sales. Reseller Sales has relationships with the Geography and Date dimensions and has one measure, Reseller Sales Amount. Internet Sales has a relationship with just the Date dimension and a single measure, Internet Sales Amount. To simplify things even further, imagine the Geography dimension has a single attribute hierarchy, Country, and Date has three attribute hierarchies, Calendar Year, Calendar Quarter, and Date.

Read more...

Tags: design, dimension

 

2007-2015 VidasSoft Systems Inc.