Adding Functionality to Your Cube - Getting Started with SQL Server 2012 Cube Development - page 194

{
OleDbConnection cn = new
OleDbConnection(cnDef);
DataTable dt = new
DataTable("tblresult");
new OleDbDataAdapter(qDef,
cn).Fill(dt);
return dt;
}
}
}
The preceding code defines a simple class that has a method called ExecQuery
that takes a connection string and a query string as arguments. To call the DLL from
your action, you first need to add the assembly to Analysis Services. You can do
that by connecting to your cube with Management Studio and right-clicking on the
Assemblies folder and choosing New Assembly , as shown in the following screen-
shot:
To call the action, you can use the following code from within Analysis Services: