Hello,
How can we get the square root of a value with MDX?
I saw that some programmer use this "^" But, it doesn't work for me...
I thought it was an easy task...Maybe it is?
Thanks!

It should work - what error do you get?

http://groups.google.com/group/micro...olap/msg/9ea49
17e0f679ba7
From: "Mosha Pasumansky [MS]"
Date: Mon, 10 Mar 2003 22:14:19 -0800

Subject: Re: SQR Function



Alternatively, you could use "^" operator in MDX - this should provide
better performance then calling into VBA. Example:

WITH MEMBER Measures.X AS ' 4 ^ 0.5 '
SELECT {X} on 0 FROM Sales


--
==================================================
Mosha Pasumansky (moshap at microsoft dot com)
Development Lead in the Microsoft Analysis Server team
More info at http://www.mosha.com/msolap
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***