You develop a SQL Server Analysis Services (SSAS) stored procedure.
You need to ensure that developers can create Multidimensional Expressions (MDX)
calculations that use the stored procedure.
What should you do?
A.
Register the assembly on the SSAS server instance.
B.
Copy the assembly to the SSAS installation directory and register it by using the CREATE
ASSEMBLY T-SQL command.
C.
Register the assembly on the SSAS server by using regedit.exe.
D.
Register the assembly on the SharePoint server by using regeditexe.
A
0
0
the correct answer is B
0
0
The correct answer is A.
Steps to register as assembly using SSMS (also possible via SSDT):
Connect to your Analysis Services server.
In Object Explorer, expand the list of databases and navigate to the target database.
Right-click the Assemblies node, and choose New Assembly from the resulting menu.
In the Register Database Assembly dialog box, select StoredProcedure.dll as
the filename of the assembly.
6. SQL Server Management Studio produces a name of the assembly that is, by default,
the same as the name of the file. You can change it.
1
0
“A”
http://bisherryli.com/2012/10/16/ssas-28-setup-to-learn-ssas-stored-procedures/
0
0