Page 150 - DCAP606_BUSINESS_INTELLIGENCE
P. 150

Unit 10: Retrieving Data from Analysis Services




                                                                                                Notes
                               Figure 10.1: Excel Accesses Analysis Services

























          Source:http://blogs.msdn.com/blogfiles/excel/WindowsLiveWriter/UsingExcelExcelServiceswith
          SQLServerAnal_B11A/image_thumb.png
          You should now have a connection to a cube within Excel and a pivot table ready.

                                 Figure 10.2: Excel Connection Property







































          Source:  http://blogs.msdn.com/blogfiles/excel/WindowsLiveWriter/UsingExcelExcelServiceswith
          SQLServerAnal_B11A/image_thumb_1.png




                                           LOVELY PROFESSIONAL UNIVERSITY                                   145
   145   146   147   148   149   150   151   152   153   154   155