Using .NET DLL in Busniess Intelligence modul

Create and Using .NET dll in Business Intellignece modul

Step 1 Create dll in Visual Studio

Example (TestDll):

PublicClass Class1​

​

PublicFunction AddMyValues(ByVal Value1 AsDouble, ByVal Value2 AsDouble) AsDouble​

​

Dim Result AsDouble​

​

Result = Value1 + Value2

Return Result​

​

EndFunction

​

EndClass​

​

More 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:

Step 3 Create Script in Business Intelligence

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

BI report:

Download example:

Important!! In this example dll file is located D:\.