Make Log10 an internal MDX function - by Christopher Webb

Status : 


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


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, 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.

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.