Thursday, 14 February 2013

Tight Integration of Data | MSBI Tutorial pdf

Tight Integration of Data

Office SharePoint Server 2007 introduces new technologies that provide advanced and interactive collaboration features that enable you to integrate data and see different levels of detail. Document sharing and links to subject matter expert sites also help make it easier for you to establish chains of responsibility.

Business Data Catalog
Office SharePoint Server 2007 provides an easy way for you to integrate business data from SAP, Siebel, or similar applications with your corporate portal. Create metadata that describes the database or Web Service and then register the exposed data in Business Data Catalog. Business Data Catalog can use this metadata to retrieve relevant data.
After you register a data source in Business Data Catalog, the business data entities are available for use by any of the following business data features:
=> Business Data Web Parts display any entity from Business Data Catalog without deploying new code. The Web Parts provide customization, connections, and the standard look and feel of Microsoft Windows SharePoint Services.
=> Business Data in Lists enables you to add any entity defined in the Business Data Catalog to a SharePoint list or document library.
=> Business Data Actions provide a link to the back-end data source. Actions are implemented as links, so you can also use actions to perform simple procedures such as sending an e-mail message or opening a customer’s home page.
=> Business Data Search offers a full-text search of the data sources registered in Business Data Catalog.

Simplified Dashboard Building
With Office SharePoint Server 2007, anyone with the appropriate SharePoint permissions can create a dashboard with just a few clicks. Once you’ve created the dashboard, you can choose which Web Parts you want to display as well as where they’re displayed. You then configure the dashboard within your Web browser by setting up which spreadsheets are shown (and how), what KPIs are shown in the KPI list, and
what filters should be made available. None of the procedures require you to produce code.

                                            Fig : Excel Services with a KPI list.

Content Reuse and Distribution
Office SharePoint Server 2007 supports the distribution and reuse of content by using “live copies.” A live copy is a document a user copies to another SharePoint site location that retains a pointer to the original document. When the original document is edited, Office SharePoint Server 2007 notifies the user, who has the option of updating the copy. In addition, Office SharePoint Server 2007 offers rendition support, which enables users to locate the same content that has been saved in a different file format.

No comments: