I am using Analysis Services 2005 and I need to create a new measure “Sigma”,
for which I have to take the logarithm of another calculated measure.

i.e. Sigma = ln (x) (where x is another calculated measure within the cube.

I searched the web and was not able to find any info about this topic.

Does anyone know how to do this?

Thanks

Well, the VBA natural logarithm function: Log(x) works in AS 2000; and
Exp(x) still seems to work in AS 2005 (June CTP). But using Log(x) in AS
2005 returns an error like "Syntax of Log() is incorrect" - so it seems
to recognize the "Log" keyword, but doesn't execute it.

Maybe this is a bug in the June CTP - have you posted this question to
the SQL Server 2005 Beta Newsgroups?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Thanks a lot

will post his question on SQL Server 2005 news group.

Bruno

"Deepak Puri" wrote:

Log is a keyword because of data mining syntax in AS2005, so you need to
escape it by using [Log] in MDX expressions.

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =
"Bruno" <Bruno (AT) discussions (DOT) microsoft.com> wrote