Microsoft Office Tutorials and References
In Depth Information
Excel Services and SSAS
SQL Server Analysis Services (SSAS) and Excel together—now that’s a great combination for those who would like to
analyze and slice and dice cube data. To do this, we will use the AdventureWorks DW database and demonstrate how
to configure and connect to SSAS.
As a prerequisite, Secure Store Services needs to be configured to authenticate with SSAS. This is similar to what
you’ve done in previous chapters, but we will run through the exercise once again.
Configuring Secure Store Services
From Central Administration ➤ Application Management ➤ Manage Service Applications, choose Secure Store
Service. Click the New button, and enter the Target Application Settings as shown in Figure 5-26 . Choose Group for
the Target Application Type, which ensures that access is granted to the entire group rather than an individual. Click
Next to continue.
Figure 5-26. Setting up a new SSS Application ID for Excel Services
In the credentials fields, choose Windows User Name and Windows Password as shown Figure 5-27 and
Search JabSto ::