Advanced sql server 2005 reporting services
This presentation is the property of its rightful owner.
Sponsored Links
1 / 51

Advanced SQL Server 2005 Reporting Services PowerPoint PPT Presentation


  • 125 Views
  • Uploaded on
  • Presentation posted in: General

Advanced SQL Server 2005 Reporting Services. 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. Knowledge of Reporting Services

Download Presentation

Advanced SQL Server 2005 Reporting Services

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


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

Level 300


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


Sql server 2005 bi1

SQL Server 2005 BI

Integrate

Data acquisition from source systems and integration

Data transformation and synthesis


Sql server 2005 bi2

SQL Server 2005 BI

Integrate

Analyze

Data acquisition from source systems and integration

Data transformation and synthesis

Data enrichment with business logic and hierarchical views

Data discovery through data mining


Sql server 2005 bi3

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


Sql server 2005 bi4

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 and extensions1

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

ReportServer

Report Processing

SQL Server Report Catalog


Data sources and extensions2

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


Integrating ssis and ssrs1

Integrating SSIS and SSRS

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

Install SSIS; uncomment extension entry

Design the package properly


Integrating ssis and ssrs2

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


Advanced sql server 2005 reporting services

demonstration

Demo

Creating Reports on Integration Services Packages

  • View the IS Package in Visual Studio

  • Design a Report that Consumes the IS Package


Agenda1

Agenda

  • Understanding Data Extensions

  • Using Report Models

  • Building SSAS-Based Reports

  • Building Parameterized Reports

  • Creating Schedules and Subscriptions


Report model data extension

Report Model Data Extension


Report model data extension1

Report Model Data Extension


Advanced sql server 2005 reporting services

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


Agenda2

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


Analysis services integration1

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


Advanced sql server 2005 reporting services

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


Agenda3

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


Parameters in reports1

Parameters in Reports

Complete a data query

Link reports

Filter the query data

Populate drop-downs

Change report layout


Parameters in reports2

Parameters in Reports

Complete a data query

Link reports

Filter the query data

Populate drop-downs

Change report layout


Parameters in reports3

Parameters in Reports

Complete a data query

Link reports

Filter the query data

Populate drop-downs

Change report layout


Parameters in reports4

Parameters in Reports

Complete a data query

Link reports

Filter the query data

Populate drop-downs

Change report layout


Advanced sql server 2005 reporting services

demonstration

Demo

Adding End-User Sorting and Parameters to Reports

  • Build a New Report

  • Enable Detail-Level Sorting

  • Enable Group-Level Sorting


Agenda4

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


Schedules1

Schedules

  • Management events

    Caching, subscriptions, history

  • Stored in database

    Integrated with SQL Agent


Schedules2

Schedules

  • Management events

    Caching, subscriptions, history

  • Stored in database

    Integrated with SQL Agent

  • Polled by Windows service


Schedules notes

Schedules - Notes

  • 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


Subscriptions1

Subscriptions

  • Event-triggered

  • Delivery extension specifies delivery type


Subscriptions2

Subscriptions

  • Event-triggered

  • Delivery extension specifies delivery type

  • Specify parameters and format


Subscriptions3

Subscriptions

  • Event-triggered

  • Delivery extension specifies delivery type

  • Specify parameters and format

  • Deliver links and rendered reports

http://


Subscription types

Subscription Types

Standard

Single report to one or more addresses

Subscribe with User!UserID and User!Language


Subscription types notes

Subscription Types - Notes

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


For more information

For More Information

Visit TechNet atwww.microsoft.com/technet

Visit the following site for additional information

www.microsoft.com/technet/SQL-07


Non microsoft publications

Non-Microsoft Publications

These books can be found at all major bookstores and online retailers.


Training resources

Training Resources

For training information and availabilitywww.microsoft.com/learning


Readiness with skills assessment

Readiness with Skills Assessment

  • Self-study learning tool free to anyone

  • Determines skills gaps

  • Provides learning plans

  • Post your score; see how you stack up

Visit

www.microsoft.com/assessment


Become a microsoft certified professional

Become a Microsoft Certified Professional

  • What are MCP certifications?

    Validation in performing critical IT functions.

  • Why certify?

    Wide recognition of skills gained through experience

    More effective deployments with reduced costs

  • What certifications are there for IT pros?

    MCP, MCSE, MCSA, MCDST, MCDBA

www.microsoft.com/learning/mcp


Heard the news about technet

Heard the News about TechNet?

  • Software without time limits

  • Complimentary technical support

  • The most current resources on hand

www.microsoft.com/technet/subscriptions


Advanced sql server 2005 reporting services

Find all these support options at www.microsoft.com/technet/supportMicrosoft offers a progressive series of support options starting with no-charge online support and developing through subscription, incident, and contract support.

1. No-Charge Online Support

Knowledge BaseSearch a vast database of articles to pinpoint the information you need.

NewsgroupsAccess over 20,000 active newsgroups on scores of topics.

Product Support CentersGet answers to frequently asked questions, plus how-to articles and step-by-step instructions organized by product.

DLL Help Database Search here to identify the software used to install a specific DLL version.

Events and Errors Message CenterResolve event and error messages fast with explanations, recommendations, and links to support and resources.

Support WebcastsTune in to live technical presentations by Microsoft experts and take part in real-time Q&A.

ChatsChat online with Microsoft specialists or search the transcript archives.

User Group ProgramAccess information and support for IT and other interest-specific user groups.

TechNet Security Resource CenterGet ahead of security risks with resources that keep you current, including security newsletters and the Microsoft notification service.

2. Subscription-Based Support

TechNet Subscription

Subscribe to TechNet for a personal library of articles, service packs, how-to’s, resource kits, tools, utilities, and more. Your subscription includes monthly updates delivered on CD or DVD, so you always have the latest information, straight from the source.

Upgrade to a TechNet Plus subscription and add all this:

1.Full-version evaluation software, including Microsoft Office System and Windows Server System™ products, without time restrictions.

2. Free support — two complimentary incidents, plus a discount on other support calls.

3. Unlimited, next-business-day access to reliable answers from the IT community and Microsoft Support Professionals through Managed Newsgroups (English only).

4. Contract-Based Support

Premier SupportGet the flexibility to match support options to your organization and enjoy direct access to Microsoft technical experts at any time, day or night. Premier Support delivers customized options for businesses with complex needs, including dedicated technical professionals to oversee your support, 24x7 problem resolution, and training and workshops that keep your IT staff up to date.

Essential SupportEssential Support offers prepackaged options specifically designed to meet the fundamental support requirements of any business, large or small. Includes account management, problem resolution, and information services.

3. Assisted Incident Support

E-mail SupportGet online incident help via e-mail from a Microsoft Support Professional.

Phone SupportGet incident help over the phone from a Microsoft Support Professional.

Phone Support ContractSave with a discounted 5-Pack Phone Support contract.

Advisory ServicesAdd remotely delivered consultation options from Microsoft Advisory Services for proactive support that goes far beyond routine product maintenance.


Where else can i get help

Where Else Can I Get Help?

  • Free chats and webcasts

  • List of newsgroups

  • Microsoft community sites

  • Community events and columns

www.microsoft.com/sql/community


  • Login