Package mondrian.udf

Class InverseNormalUdf

java.lang.Object

mondrian.udf.InverseNormalUdf

All Implemented Interfaces:

UserDefinedFunction

public class InverseNormalUdf
extends Object
implements UserDefinedFunction

A user-defined function which returns the inverse normal distribution value of its argument.

This particular function is useful in Six Sigma calculations, for example,

 WITH MEMBER [Measures].[Yield]
         AS '([Measures].[Number of Failures] / [Measures].[Population])',
         FORMAT_STRING = "0.00%"
     MEMBER [Measures].[Sigma]
         AS 'IIf([Measures].[Yield] <> 0,
                 IIf([Measures].[Yield] > 0.5,
                     0,
                     InverseNormal(1 - ([Measures].[Yield])) + 1.5), 6)',
         FORMAT_STRING = "0.0000"
 

Nested Class Summary

Nested classes/interfaces inherited from interface mondrian.spi.UserDefinedFunction

UserDefinedFunction.Argument

Constructor Summary

Constructors

Constructor	Description
InverseNormalUdf()

Method Summary

Modifier and Type	Method	Description
Object	execute(Evaluator evaluator, UserDefinedFunction.Argument[] args)	Applies this function to a set of arguments, and returns a result.
String	getDescription()	Returns a description of the user-defined function.
String	getName()	Returns the name with which the user-defined function will be used from within MDX expressions.
Type[]	getParameterTypes()	Returns an array of the types of the parameters of this function.
String[]	getReservedWords()	Returns a list of reserved words used by this function.
Type	getReturnType(Type[] types)	Returns the return-type of this function.
Syntax	getSyntax()	Returns the syntactic type of the user-defined function.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

InverseNormalUdf

public InverseNormalUdf()

Method Details

getName

public String getName()

Description copied from interface: UserDefinedFunction

Returns the name with which the user-defined function will be used from within MDX expressions.

Specified by:

getName in interface UserDefinedFunction

getDescription

public String getDescription()

Description copied from interface: UserDefinedFunction

Returns a description of the user-defined function.

Specified by:

getDescription in interface UserDefinedFunction

getSyntax

public Syntax getSyntax()

Description copied from interface: UserDefinedFunction

Returns the syntactic type of the user-defined function. Usually Syntax.Function.

Specified by:

getSyntax in interface UserDefinedFunction

getReturnType

public Type getReturnType(Type[] types)

Description copied from interface: UserDefinedFunction

Returns the return-type of this function.

Specified by:

getReturnType in interface UserDefinedFunction

Parameters:

types - Parameter types

Returns:

Return type

getParameterTypes

public Type[] getParameterTypes()

Description copied from interface: UserDefinedFunction

Returns an array of the types of the parameters of this function.

Specified by:

getParameterTypes in interface UserDefinedFunction

execute

public Object execute(Evaluator evaluator,
 UserDefinedFunction.Argument[] args)

Description copied from interface: UserDefinedFunction

Applies this function to a set of arguments, and returns a result.

Specified by:

execute in interface UserDefinedFunction

Parameters:

evaluator - Evaluator containts the runtime context, in particular the current member of each dimension.

args - Expressions which yield the arguments of this function. Most user-defined functions will evaluate all arguments before using them. Functions such as IIf do not evaluate all arguments; this technique is called lazy evaluation.

Returns:

The result value.

getReservedWords

public String[] getReservedWords()

Description copied from interface: UserDefinedFunction

Returns a list of reserved words used by this function. May return an empty array or null if this function does not require any reserved words.

Specified by:

getReservedWords in interface UserDefinedFunction