Extending MDX with Stored Procedures - Microsoft SQL Server 2008 Analysis Services - page 237

}
public static string GetLastName(string fullName)
{

string[] names = fullName.Split(' ');
if (names.Length <= 0)
return fullName;

else

return names[names.Length - 1];

}

}

}

After you have written the code and compiled it into a .NET assembly, you can deploy it
to a server. You can either issue a DDL request similar to the one in Listing 14.2 (we
removed some of the data blocks to make the listing smaller), or you can use BI Dev
Studio or SQL Server Management Studio.

NOTE
Listing 14.2 contains lines of binary data.

LISTING 14.2

DDL Request to Create an Assembly

<Create AllowOverwrite=”true”
xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine”>
<ObjectDefinition>
<Assembly xsi:type=”ClrAssembly”
xmlns:xsd=”http://www.w3.org/2001/XMLSchema”
xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”>
<ID>SimpleStoredProcedure</ID>
<Name>SimpleStoredProcedure</Name>
<Description/>
<ImpersonationInfo>
<ImpersonationMode>Default</ImpersonationMode>
</ImpersonationInfo>
<Files>
<File>
<Name>SimpleStoredProcedure.dll</Name>
<Type>Main</Type>
<Data>
<Block>TVqQAAMAAAAEAAAA//8AALgAAAAAAAAAQAAAAAAAAA

AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAAA4fug4AtAnNIbgBTM0hVGhpcyBw

➥

cm9ncmFtIGNhbm5vdCBiZSBydW4gaW4gRE9TIG1vZGUuDQ0KJAAAAAAAAABQRQAATAEDAP

➥

JOJ0QAAAAAAAAAAOAADiELAQgAABAAAAAgAAAAAAAAbicAAAAgAAAAQAAAAABAAAAgAAAA

➥