How can i round a calculated mdx measure up to the nearest integer without having Excel on the server? The Excel-function is CEILING(number, significance), but it is not possible to install Excel on the production ssas-server.
views:
101answers:
2
+1
A:
Here's a link to an article that describes how to do this: Custom Rounding and Truncation of Numbers in MDX
TskTsk
2010-06-07 02:11:53
A:
If this is a Microsoft situation, you can use any VBA functions in your MDX to fiddle with strings or numbers. So Round(xxxxxx, 2) would work.
Magnus Smith
2010-06-11 09:07:44
How do I use VBA functions in my MDX without Excel on the MSAS server?
Espo
2010-06-11 22:01:43
You don't need Excel. If you are using Analysis Services, you just enter the VBA keywords into the MDX. No setup is required.
Magnus Smith
2010-06-14 21:03:16