70-466 · Question #159
You have a SQL Server Analysis Services (SSAS) multidimensional cube. You need to enable users to view the cube data from an iPad. What should you do?
The correct answer is C. Configure Excel Services in SharePoint.. Excel Services in SharePoint renders SSAS-connected workbooks in a browser, making cube data accessible on iPads without requiring any installed client software.
Question
Options
- AInstall SQL Server 2012 Reporting Services (SSRS) in SharePoint integrated mode.
- BDevelop a custom web application that connects to the cube.
- CConfigure Excel Services in SharePoint.
- DInstall SQL Server 2012 Reporting Services (SSRS) in native mode.
How the community answered
(31 responses)- A6% (2)
- B3% (1)
- C87% (27)
- D3% (1)
Why each option
Excel Services in SharePoint renders SSAS-connected workbooks in a browser, making cube data accessible on iPads without requiring any installed client software.
SSRS in SharePoint integrated mode delivers paginated reports but does not provide the interactive self-service cube exploration that Excel Services offers for mobile users.
A custom web application could technically work but is an unnecessary development investment when Excel Services already provides this capability natively.
Excel Services in SharePoint publishes Excel workbooks connected to SSAS cubes as interactive browser-based pivot tables and charts, accessible via Safari or any modern mobile browser on an iPad. It acts as a server-side rendering intermediary that translates SSAS cube data into HTML-based output suitable for iOS devices. This approach requires no client-side installation and provides native interactive cube browsing for mobile users.
SSRS in native mode delivers reports via a standalone web portal but lacks the interactive cube pivoting and filtering capabilities that Excel Services provides.
Concept tested: SSAS cube mobile access via SharePoint Excel Services
Source: https://learn.microsoft.com/en-us/sharepoint/administration/overview-of-excel-services-in-sharepoint-server-2013
Topics
Community Discussion
No community discussion yet for this question.