SSAS Articles 
MDX How to round detail rows and totals?
MDX How to round detail rows and totals?
| How to round detail rows and totals? |
| Written by Hilmar Buchta |
| Saturday, 23 August 2008 02:03 |
|
There had been quite some posts about rounding values in MDX or on a report. For most cases we want to do the rounding in the presentation layer of the application (like with other formatting issues too) using formatting or maybe built-in round functions. One issue with rounding is that the sum over the rounded details does not necessarily match the rounded total as in the following simple example: Read more... |
Tags: 2005, article, mdx
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)
