SSAS Articles 
Design Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
Design Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
| Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005 |
| Written by Ajit Singh |
| Friday, 16 May 2008 10:49 |
|
Traditionally the cubes structure is designed based on either star or snowflake schema. The dimensions in the cube is totally independent of each other and in the results can be obtained for any dimension members to any dimension. This is a classic illusion of an ideal world, i.e. even though the intention is good but the performance suffers since the cube is very sparse. High cube sparsity adversely affect the MDX query performance. A very sparse cube can take longer to resolve calculated members and calculated cells, and MDX functions involving empty cells, such as CoalesceEmpty or NonEmptyCrossjoin, take slightly longer to process because of the large volume of empty cells that must be considered by such functions. |
Latest Author Articles
- Fact table design for "State Workflow Analysis": Analysis Services Dimensional modeling
- NextAnalytics and MDX : Part 1 - Swap Cells with Row Labels
- Aggregate(), Sum() functions using calculated members does not work in Analysis Services 2005 SP2 (9.00.3042.00 version) but works in Analysis Services 2000 SP4
- Identifying intra-dimensional members relationship and reducing cube sparsity in Analysis Services 2005 SP2 : Cube design tip
- Code : utility code for converting cellset to a data table
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
