Enabling End User And Ad Hoc Reporting With M S S Q L Server 2005 Reporting Services

100 %
0 %
Information about Enabling End User And Ad Hoc Reporting With M S S Q L Server...

Published on June 1, 2009

Author: redondoj

Source: slideshare.net

Data Resides in Many Places Needed “in” Applications Users’ Reporting Needs Change IT Perceived As a Bottleneck Multiple Formats Wanted High Scale Reporting How do I …….. build a report with multiple data sources? enable interactive access to information? enable an end user to build (or modify) their own report? provide reports in a format that end users want? integrate reporting into applications easily?

Tightly integrated “all-in-one” technology solution… increased manageability and the best economics Comprehensive ability to integrate any data… Highly intuitive, visual tools…greater improved data completeness productivity from developers to users Information Delivery Enterprise Client Portal Source Data Marts Reporting Systems Business Insights ERP Familiar, Powerful BI Tools CRM Third Party Applications Interactive Reports LOB Enterprise Devices ETL Data Data Analysis Warehouse (OLAP, Data Mining) Performance Scorecard Familiar tools, look and Automated data integration and manipulation..… User empowerment to create own feel…more productive users enhanced data integrity and reliability analyses and reports…time to value

DELIVERY SharePoint Server Reports DashboardsWorkbooks Analytic Scorecards Excel Views Plans END USER TOOLS & PERFORMANCE MANAGEMENT APPS Excel PerformancePoint Server BI PLATFORM SQL Server SQL Server Reporting Services Analysis Services SQL Server DBMS SQL Server Integration Services

Report Builder Overview Report Builder Demonstration Architecture Model Designer Overview Model Designer Demonstration Licensing Supported Languages Question and Answer

End User Business Analyst Developer Ad-Hoc Reports Report Builder Scorecards PerformancePoint Monitoring Data-Driven Views Standard Reports Excel Report Designer Analytics PerformancePoint Analytics Data Mining Data Mining Add-in

A new ad-hoc report design tool for SQL Server Reporting Services Targeted at business users who want to find and share answers to interesting questions Driven from a business model of the data so users do not need to understand the underlying data structures Fully integrated with Reporting Services and delivered in SQL Server 2005

Report Model Model SQL Server Report Report Builder Designer Generation Studio Designer Manager Client XML Web Service Interface URL Access Report Server Report Builder Query Translation Query generation Drill-through report Data Sources generation Report Processing Rendering Security Data Processing Delivery SQL Server Catalog Report Models Reports

Report Builder is a ClickOnce Windows Forms application managed on the Report Server Users download and launch the client from the Report Manager or 3rd party applications Built on top of familiar Microsoft Office paradigms: Excel, PowerPoint Reports built with report templates (textboxes, tables, matrices, charts) Provides “infinite drill” for exploring data Finished reports can be saved on the server

Report Builder reports are just like any other Reporting Services report… Report Builder reports are defined in RDL Managed by the same APIs Secured by the same APIs Except: Report Builder reports contain semantic model metadata When an Report Builder report is requested by report processing, the metadata is used to generate a query in the source language A new component on the Report Server handles the query generation

Automatic generation of new drillthrough reports allows users to explore data along model navigation paths Queries for navigation reports are generated on the fly, passing the context of the user’s current “location” Users can keep drilling as long as there is a path to follow from the current item Custom reports can be specified for model items Generated navigation reports are not saved unless the user explicitly saves them

Models define entities, fields and roles available for Report Builder Models reference a data source (SQL Server, Analysis Services or Oracle) Models are stored in the Report Server as a new item type Includes new management APIs Published models can be secured Items within models (entities, fields, roles) can also be secured Users only see items they have permissions to see Pre-defined filters can restrict data users can see Model security and management through SQL Server Management Studio

Model Designer is interface for designing/editing a model New project type in Visual Studio Define fields and roles Define calculated fields Organize model Models can be auto-generated in Model Designer or on the Report Server Generates entities, fields and roles based on source metadata Auto-generation against SQL Server, Analysis Services and Oracle databases

Report Builder Report Designer Targeted at business users Targeted at IT pros and developers Ad hoc reports Managed reports Auto-generates queries using Native queries (SQL, OLE semantic layer on top of the DB, MDX, ODBC, Oracle) source Reports built on templates Free-form (nested, banded) reports Click-once application, easy Integrated into Visual Studio to deploy and manage Cannot import Report Can work with reports built in Designer reports Report Builder

Event-triggered Delivery extension specifies delivery type Specify parameters and format http:// Deliver links and rendered reports

Single report to one or more Standard addresses Subscribe with User!UserID and User!Language Dynamic destination list Data-Driven Customized content for each destination

Licensing Report Builder is licensed with SQL Server, there is no separate license Report Builder client in Workgroup, Standard, and Enterprise In Workgroup, local server only or relational only data sources are supported depending on the license Model level security only available in Standard and Enterprise Infinite clickthrough only supported in Enterprise http://www.microsoft.com/sql/2005/productinfo/rsfeat ures.mspx

Report Builder is… a new ad hoc report design tool for SQL Server Reporting Services targeted at business users who want to find and share answers to interesting questions driven from a business model of the data so users do not need to understand the underlying data structures is fully integrated with SQL Server Reporting Services and delivered in SQL Server 2005

© 2007 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

Add a comment

Related pages

Ad Hoc Reporting | LinkedIn

View 63467 Ad Hoc Reporting posts, presentations, experts, and more. Get the professional knowledge you need on LinkedIn.
Read more

SQL Server™ 2005: Report Builder

SQL Server™ 2005: Report Builder ... ad-hoc reporting. This allows end-users to think ... item on the Reporting Services home page. Report Builder is a ...
Read more

sql - Enterprise Reporting Solutions - Stack Overflow

... Reporting Services 2005, and Reporting Services 2008. Here's my ... SQL Server. I'm just ... more end-user interactivity and offers ad-hoc ...
Read more

SQL Server Reporting Services - Wikipedia, the free ...

SQL Server Reporting Services ... The second version was released as a part of SQL Server 2005 ... SQL Server Reporting Services also support ad hoc ...
Read more

What is self-service business intelligence (BI ...

L; M; N; O; P; Q; R; S; T; U; V; W; X; Y; Z # ... system and deploy the self-service query and reporting tools). ... Self- service BI gives end users the ...
Read more

Online analytical processing - Wikipedia, the free ...

OLAP tools enable users to analyze multidimensional ... and ad hoc queries with a ... to give the appearance of traditional OLAP's slicing and ...
Read more

Creating an SRS Report

Creating an SRS Report. ... an end user ad-hoc report designer ... do I need a separate server for the SQL Server 2005 Reporting Services? Here's what ...
Read more

File Server Management with Windows PowerShell ...

Figure 4: Ad Hoc Reporting ... No [L] No to All [S] ... File Server Management with Windows PowerShell 3; Q.
Read more

AD RMS - Frequently Asked Questions (FAQ) - TechNet ...

Blocking access to AD RMS services at the server. ... server the user account that’s being used ... AD RMS secure design, end users do not ...
Read more