Microsoft Office Tutorials and References
In Depth Information
Business Intelligence Everywhere
You can control whether or not a user can link to the Excel viewer page to get a full-screen
experience of the workbook. For example, you may want to do this to control where the link on the
title bar goes to use a different viewer page, or to hide the complete workbook and toolbar (that
appears with the viewer page). To do this, turn off the autogenerated title bar link in the Toolbar
And Title Bar section and insert your own title bar in the Title URL box under the Advanced
section in the Web Part properties. This also lets you further obfuscate the workbook URL.
So far in this chapter, you learned how to build BI solutions using sites created from the Report Center
template. Equally (and perhaps even more) interesting is the fact that you can use all the features in any
Office SharePoint Server site. The next section describes how to do this.
Business Intelligence Everywhere
You can create report libraries, DCLs, KPI lists, and dashboards literally anywhere that you can create
regular lists and pages. Moreover, you can add the KPI Web Part or the EWA Web Part to existing pages
(assuming you have the permission to edit them). The same can be done with the filter Web Parts.
The power of this is that you can embed BI functionality within your Web applications and sites. Your
users do not need to go to a special site to see reports and dashboards. If your organization has an HR
portal, for example, or if the Sales division already has a SharePoint Web site, you can add a report library with
HR or sales reports within the respective site. You can also add a KPI list and place the associated Web Part
on the home page of the sales division Web site. By embedding the functionality within the specific
functional and team sites, you can spread the data and the derived value broader. Of course, if there is a need or
preference for a standalone reporting site, you can always revert back to creating a Report Center from the
In the next Try It Out, you add the sales report to the home page of your Office SharePoint Server portal.
This exercise assumes that you have the necessary permissions to edit the home page.
Try It Out Adding Excel Web Access to the Server Home Page
To add EWA to the server home page, follow these steps:
Open the home page of your Office SharePoint Server.
In the Site Actions menu in the upper-left corner, select Edit Page.
Click the Add a Web Part button in the right zone of the page.
Show All Web Parts by clicking the + sign icon.
Select the Excel Web Access Web Part from the Business Data section.
Select a workbook by following the same steps as in the dashboard Try It Outs in the previous
Click the Publish button on the page editing toolbar to make the page available to everyone.
Search JabSto ::

Custom Search