SSAS Articles 
Design Calculated members are better than assignments to real members (at least sometimes)
Design Calculated members are better than assignments to real members (at least sometimes)
| Calculated members are better than assignments to real members (at least sometimes) |
| Written by Chris Webb |
| Friday, 24 October 2008 02:03 |
|
Earlier this year I blogged about how, in my experience, using real members and overwriting them with MDX Script assignments sometimes seemed to perform worse than using calculated members. Recently I came across this problem again but was able to get together a proper repro and open a support case with Microsoft. Read more...
|
Tags: 2005, article, design
Latest Author Articles
- What hierarchies are actually being used in my cube?
- NonEmpty() and that all-important second parameter
- Reporting Services-generate MDX, Subselects and Formula Caching
- Calculated members are better than assignments to real members (at least sometimes)
- Using AS Data Mining to Add Forecast Values to a Cube
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)
