advanced sql server 2005 reporting services l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Advanced SQL Server 2005 Reporting Services PowerPoint Presentation
Download Presentation
Advanced SQL Server 2005 Reporting Services

Loading in 2 Seconds...

play fullscreen
1 / 28

Advanced SQL Server 2005 Reporting Services - PowerPoint PPT Presentation


  • 182 Views
  • Uploaded on

Advanced SQL Server 2005 Reporting Services. Melville Thomson IT Pro Evangelist HTTP://blogs.technet.com/melville. Welcome to this TechNet Event . “Pick your Own Collateral” URL for on-line feedback is in your reminder e-mail No Planned Fire Drills Please turn your Mobile Phones off

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Advanced SQL Server 2005 Reporting Services' - melvina


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
advanced sql server 2005 reporting services

Advanced SQL Server 2005 Reporting Services

Melville Thomson

IT Pro Evangelist

HTTP://blogs.technet.com/melville

welcome to this technet event
Welcome to this TechNet Event
  • “Pick your Own Collateral”
  • URL for on-line feedback is in your reminder e-mail
  • No Planned Fire Drills
  • Please turn your Mobile Phones off
  • To find out about future TechNet events: www.microsoft.com/uk/technetevents
what is technet plus
What is TechNet Plus?

The Toolkit for IT Professionals

  • TechNet Plus is an annual subscription
  • Access to TechNet Knowledge Base
  • No-limits Evaluation software for Testing
  • Beta software available immediately
  • 2 Free Technical Support calls worth £320
  • 20% off all further Support Calls
  • Managed Newsgroups with guaranteed answers in 24hrs
  • Now available by Download from only £230 / year (excl VAT)

For all information on TechNet Plus Subscriptions visit:

www.microsoft.com/technet/abouttn/subscriptions

the technet programme
The TechNet Programme

A range of tools and resources for IT Professionals

  • FREE TechNet Newsletter
  • FREE Events and Webcasts
  • FREE TechNet BETA Central (www.microsoft.com/uk/betacentral)
  • FREE Quarterly TechNet Magazine
  • FREE comprehensive technical website
  • FREE TechNet Radio, Security Centre, Learning Paths and Virtual Labs
  • TechNet Plus – Now available for Download!

www.microsoft.com/technet

windows server system
Windows Server System

SecurityInfrastructure

IT OperationsInfrastructure

Applications Infrastructure

CollaborationInfrastructure

what will we cover
What Will We Cover?
  • New Data Sources in SSRS 2005
  • Reporting Services Data Extensions
  • Working with SSAS and SSIS Data
  • End-User Sort and Parameterization
  • Schedules and Subscriptions
helpful experience
Helpful Experience
  • Knowledge of Reporting Services
  • Familiarity with SSIS and SSAS
  • Experience with SQL Server
agenda
Agenda
  • Understanding Data Extensions
  • Using Report Models
  • Building SSAS-Based Reports
  • Building Parameterized Reports
  • Creating Schedules and Subscriptions
sql server 2005 bi
SQL Server 2005 BI

Integrate

Analyze

Report

Data acquisition from source systems and integration

Data transformation and synthesis

Data enrichment with business logic and hierarchical views

Data discovery through data mining

Data presentation and distribution

Data access for the masses

data sources and extensions
Data Sources and Extensions

SP1

  • SQL Server
  • OLE DB
  • ODBC
  • Oracle
  • Other .NET

Providers

  • SSIS
  • SSAS
  • XML
  • Report Models
  • SAP R/3
  • SAP BW

Data Sources

(SQL, OLE DB,

ODBC, Oracle, Custom)

Data Processing

Rendering

Output Formats

(HTML, Excel, PDF, Custom)

ReportServer

Report Processing

SQL Server Report Catalog

integrating ssis and ssrs
Integrating SSIS and SSRS

\MSSQL.n\Reporting Services\ReportServer\rsreportserver.config

Install SSIS; uncomment extension entry

Design the package properly

Set up account for unattended reports

slide12

demonstration

Demo

Creating Reports on Integration Services Packages

  • View the IS Package in Visual Studio
  • Design a Report that Consumes the IS Package
agenda13
Agenda
  • Understanding Data Extensions
  • Using Report Models
  • Building SSAS-Based Reports
  • Building Parameterized Reports
  • Creating Schedules and Subscriptions
slide15

demonstration

Demo

Designing Reports that Use Report Models

  • Design a Report in Report Builder
  • Design a Report in Report Designer
  • Use a Drill-through Report
agenda16
Agenda
  • Understanding Data Extensions
  • Using Report Models
  • Building SSAS-Based Reports
  • Building Parameterized Reports
  • Creating Schedules and Subscriptions
analysis services integration
Analysis Services Integration

MDX queries

DMX queries

Analysis Services

Data Sources

ReportServer

Report Processing

Data Processing

OLAP Cube

SQL Server Report Catalog

Data Mining Model

MDX parameters

Member extended properties

Server aggregates

slide18

demonstration

Demo

Creating Reports on Analysis Services

  • Build a Report that Uses a Data Mining Model
  • Build a Report that Uses a Cube
  • Add Programmatic Padding and Show/Hide Functionality
agenda19
Agenda
  • Understanding Data Extensions
  • Using Report Models
  • Building SSAS-Based Reports
  • Building Parameterized Reports
  • Creating Schedules and Subscriptions
parameters in reports
Parameters in Reports

Complete a data query

Link reports

Filter the query data

Populate drop-downs

Change report layout

slide21

demonstration

Demo

Adding End-User Sorting and Parameters to Reports

  • Build a New Report
  • Enable Detail-Level Sorting
  • Enable Group-Level Sorting
agenda22
Agenda
  • Understanding Data Extensions
  • Using Report Models
  • Building SSAS-Based Reports
  • Building Parameterized Reports
  • Creating Schedules and Subscriptions
schedules
Schedules
  • Management events

Caching, subscriptions, history

  • Stored in database

Integrated with SQL Agent

  • Polled by Windows service
  • Calls the Report Processor

Shared schedules

subscriptions
Subscriptions
  • Event-triggered
  • Delivery extension specifies delivery type
  • Specify parameters and format
  • Deliver links and rendered reports

http://

subscription types
Subscription Types

Standard

Data-Driven

Single report to one or more addresses

Subscribe with User!UserID and User!Language

Dynamic destination list

Customized content for each destination

session summary
Session Summary
  • New data sources, especially SSIS and SSAS
  • End-user sort and parameterization
  • Subscriptions automate report deliveries
ihr potenzial unser antrieb

Ihr Potenzial. Unser Antrieb.

Thank you for attending this TechNet Event

Find these slides at:

http://www.microsoft.com/uk/technetslides

slide28

Melville Thomson

IT Pro Evangelist

http://blogs.technet.com/melville