Hello,
There was a post a while ago of how to use Logarithm function in
SSAS2005 and Mosha pointed out that [Log] syntax should be used in
this case . Actually, it doesn't work either. The parser is not
complaining anymore but when I use CM that uses [Log] I get #VALUE! and
the error message reads:
"The dimension '[Log]' was not found in the cube when the string,
[Log], was parsed"

Any thoughts of what else could be done to fix this?

Thanks!

It worked to calculate the natural logaritm, using this syntax:

VBA

but I'm still looking for how to calculate the log base 10. Log10 does not
work.


"akornilovski (AT) gmail (DOT) com" wrote:

Log Base 10 can be derived from Log Base e:

http://en.wikipedia.org/wiki/Logarithm
Change of base

While there are several useful identities, the most important for
calculator use lets one find logarithms with bases other than those
built into the calculator (usually loge and log10). To find a logarithm
with base b using any other base k:
...

Here's an Adventure Works query illustrating this:

Member [Measures].[LogeX] as
VBA
Member [Measures].[Loge10] as
VBA
Member [Measures].[Log10X] as
[Measures].[LogeX]/[Measures].[Loge10]

select {[Measures].[Order Quantity],
[Measures].[LogeX],
[Measures].[Loge10],
[Measures].[Log10X]} on 0
from [Adventure Works]
---------------------------------------------------
Order Quantity LogeX Loge10 Log10X
274,776 12.5237114992718 2.30258509299405 5.43897879708202

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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