Microsoft Office Tutorials and References
In Depth Information
Enter values in the credential fields for the Target Application that has access to the SSAS database as shown in
Figure 5-30 .
Figure 5-30. Setting credentials for the SSS Target Application group
Now that your credential cache is ready, let's see how to connect Excel with SSAS using the Secure Store Service
Application ID.
prOBLeM CaSe
Connect excel with the multidimensional cube, and analyze the internet Sales information from the adventure
Works DW database.
Solution
1.
Open the excel 2013 client. On the Data tab, choose From analysis Services, as shown in
Figure 5-31 .
 
Search JabSto ::




Custom Search