Page 202 - DCAP606_BUSINESS_INTELLIGENCE

Unit 14: Reporting Tools

You can preview the report to change the data specifications if required. Once done, press Notes
Ctrl+F5 and the deployment of the report will occur.

Task Prepare a presentation on the steps of generating report using SQL server 2008.

Self Assessment

State whether the following statements are true or false:
3. SSRS supplies some extensions towards the data rendering, consignment and security of
reports thereby allowing it to have a higher programmable ability.
4. SSRS is a comprehensive reporting platform whereby accounts are retained on a centralized
web server (or set of servers).
5. The Report Manager is the central person who acts as a manager to decide when the
reports will be scheduled to run along with maintaining the user profiles on the report
server.

14.3 Analysis Services Using SQL Server

For business intelligence applications Microsoft SQL Server Analysis Services (SSAS) delivers
Online Analytical Processing (OLAP) and data mining functionality. OLAP is supported by
Analysis Services by letting you design, create, and manage multidimensional structures that
contain data aggregated from other data sources, such as relational databases.

Analytical solutions are rapidly evolving mission critical for many companies. This has led to
an explosion of data retained in these systems and a need to support bigger and quicker solutions
that can be created and evolved quickly and effectively.
An Analysis Services instance is deployed in a mode that supports a memory and storage
architecture that is optimized for all kinds of solutions. You can also install PowerPivot for
SharePoint, which has its own internally set server mode. Each server mode is independent of
the other mode; each one supports a type of analytical database that only runs in its modality.
Figure 14.12: Analysis Service

Replication Full-Text

Service Broker Database Search

Engine

Integration Services
Notification
Services
Reporting Analysis
Services
Services

Source: http://i.msdn.microsoft.com/dynimg/IC6000.gif

LOVELY PROFESSIONAL UNIVERSITY 197