Microsoft Office Tutorials and References
In Depth Information
User-Defined Function Assemblies
Click on Add User-Defined Function Assembly to set and enable .NET assemblies containing user-defined functions
that extend ECS capabilities. The assembly details are shown in Figure 5-9 . Here is a summary of the options:
• Assembly: Type the assembly path, either the full path or the strong name of the assembly.
• Assembly Location: Choose between GAC or the file path for the assembly location.
• Enable Assembly: If the Enable Assembly check box is selected, ECS will load and use the assembly.
Clearing this check box disables the assembly without deleting the assembly from the entry list.
• Description: This is a field where you can enter optional text describing the user-defined
Figure 5-9. Setting up UDFs for Excel Services
For more information on UDFs, visit http://msdn.microsoft.com/en-us/library/ms499792(v=office.14).aspx .
Data Model Settings
If you imported external data into Excel and created a data model within Excel, you need an instance of SQL Server
Analysis Services (SSAS) for Excel Services to load, query, and refresh the data model. When users interact with the
Excel workbook on the browser, Excel Services uses this Analysis Services instance to provide the back-end support to
handle the analytical needs of the data model. This Analysis Services instance should run SQL 2012 SP1 or later and
must be installed in SQL Server PowerPivot for SharePoint mode.
Once you have the Analysis Services ready, you can configure Excel Services to use the instance of Analysis
Services by adding an entry in the Data Model settings. More than one server can be configured in the Data Model
settings if Load balancing is required.
Now that we’ve set up Excel Services, let’s author a simple Excel file and publish it to Excel Services.
Search JabSto ::