Make Log10 an internal MDX function - by Christopher Webb

Status : 

 


20
0
Sign in
to vote
ID 666000 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 4/30/2011 3:05:11 PM
Access Restriction Public

Description

At the moment, to find the log of a number in MDX you need to call out to an external function library (eg by using the Log10 function in the Excel library). This is a problem because, by calling out to an external library there's a performance overhead, it forces cell-by-cell mode in the FE, and it forces query scope for the FE cache.

However, the Log10 function is very important for aggregating values as a product (see http://sqlblog.com/blogs/mosha/archive/2006/12/18/how-to-aggregate-values-as-a-product-multiplication-in-mdx.aspx), and this is also very important when rewriting calculations to avoid recursion.
Sign in to post a comment.
Posted by Kieran Patrick Wood on 1/25/2013 at 1:42 AM
The MDX Log10 function is also very important for calculating In / Out Ratios within a line graph pointing to a cube data source.
Posted by RaviChin on 6/14/2011 at 12:41 PM
I add my vote...
Posted by Microsoft on 5/4/2011 at 4:38 PM
Dear Ayyappan,

Thank you for reporting this issue. We will consider this for a future release based on the number of customer requests.

Regards
Siva
Posted by Ayyappan Thangaraj on 5/1/2011 at 8:29 PM
I support Chris Webb's request. MDX would require math function support internally.