Design Measures and calculations in cubes without natural hierarchies | Measures and calculations in cubes without natural hierarchies |
| Written by Thomas Ivarsson | |
| Friday, 21 March 2008 19:19 | |
|
In this part of my attribute relations series I will create a simple cube with only attribute relations to the dimension key and no user or natural hierarchies. After the cube is created I will look how cube measures and calculated measures will be affected. One obvious reason for creating attribute relations in natural hierarchies is that they are the foundation for creating aggregations and better performance. There is also the point of not having wrong values in your cube fact measures but this is mainly caused by having wrong attribute relations in natural hierarchies and this will decide the distribution of measures values and not the totals. I will create two simple dimension tables (Product and Time) and a fact table with a few records. After that we will create a cube without natural hierarchies and attribute relations in these hierarchies. We will only rely on the attribute relations between the dimension key and the attributes. Run this script on a suitable database in management studio. |
Top Rated
- SSRS Report Against a SSAS Parent Hierarchy
- SSAS Implementation Best Practices slides in PDF format
- 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
- Binomial distribution for a KPI status (parts 1 and 2)
- Passing MDX parameters in Reporting Services reports
- Measures and calculations in cubes without natural hierarchies
