Step 1 Create dll in Visual Studio Example (TestDll): PublicClass Class1PublicFunction AddMyValues(ByVal Value1 AsDouble, ByVal Value2 AsDouble) AsDoubleDim Result AsDouble Result = Value1 + Value2 Return ResultEndFunction EndClassMore information about dll creation: http://www.dreamincode.net/forums/topic/121314-creating-a-dll-and-using-it-in-your-application/
Step 2 Open Business Intelligence (BI) modul and add new project Add new quantity and new expression:
Script: Public Shared Function Test(ByVal x As Double) As Double Dim retval As double Dim parameters(1) As Object Dim AddRef As System.Reflection.Assembly = System.Reflection.Assembly.LoadFrom("d:\TestDLL.dll") Dim obj As Object = AddRef.CreateInstance("TestDLL.Class1") Dim t As Type = obj.GetType Dim AddMyValues As System.Reflection.MethodInfo = t.GetMethod("AddMyValues", Reflection.BindingFlags.Public Or Reflection.BindingFlags.Instance) parameters(0) = 1.0 parameters(1) = 3.5 retval=AddMyValues.Invoke(obj, parameters) return retval End Function