Mastering OLAP Reporting: Meet Business Needs with Matrix Dynamics, Part II - Page 8

March 20, 2006

Verification: Preview the Report to Ascertain Effectiveness

Having added parameterization (with multivalue input capabilities) for Territorial Groups, and making alterations to our report file to meet business requirements for presenting independent matrices based upon the same geographical parameter selection at runtime, we will next perform a quick preview of the report to ascertain the effectiveness of our solution.

1.  Click the Preview tab to execute the RS027_Sales_Reason_Comp_Matrix report.

The report executes, with default parameter selections, and appears as partially shown in Illustration 49.

Click for larger image

Illustration 49: Executed Report, with Default Parameter Selections

We see the report appear, executed by default with "All" parameter values selected for the parameter upon which we are focusing, Sales Territory Group. We can verify this, not only by the three independent matrix data regions that appear in the Preview pane, but also by taking a look at what selections have been made within the parameter picklist.

2.  Click the dropdown selector button to the right of the Sales Territory Group parameter.

The picklist is exposed, as depicted in Illustration 50.

Click for larger image

Illustration 50: The New Parameter Picklist

3.  Uncheck the checkbox for All Sales Territories in the picklist.

4.  Click the checkboxes to the immediate left of the Europe and Pacific Territory Groups to select them, as shown in Illustration 51.

Click for larger image

Illustration 51: Specify Two Territory Groups ...

5.  Click the View Report button to refresh the report.

The report executes and returns one matrix view each for the Europe and Pacific Territory Groups, as depicted in Illustration 52.


Illustration 52: Independent Matrices for the Europe and Pacific Groups

And so, we see that our Report Parameter does, indeed, function correctly with multiple input values. Moreover, the need for the dynamic presentation of a standalone matrix for each of the picklist items we chose for Sales Territory Groups is met when the report executes.

6.  Select File --> Save All from the main menu to save all work to the present.

7.  Select File --> Exit to exit MSSQL Server Business Intelligence Development Studio when ready.

We have corroborated the correct operation of the newly incorporated features. We present the results to the client information consumers, who express satisfaction that the changes do, indeed, meet specifications.

Conclusion ...

In this two-part article, we undertook the examination of a scenario where the dynamic nature of the Reporting Services matrix data region makes it the "object of choice" for enabling us to meet the expressed needs of a hypothetical group of information consumers. Part of the requirement was to replace an existing, but somewhat limited, matrix data region with a more robust matrix data region that returned identical data. In Part One, we began by creating the new matrix data region within the same .rdl file as the pre-existing data region upon which the new data region was to be based. This side-by-side contrast afforded us several advantages in a rapid development scenario, as we "converted" the original data region to a new data region, which would act as the foundation for innovative enhancements. Having both regions in physical parallel, made verification of comparability between the two easy, as we finished the first half of our examination by ensuring that both regions gave us identical results.

In this article, we further evolved the new matrix to meet the less intuitive facets of the business requirements of the information consumers with which we are working. First, we added the requested parameterization (with multivalue input capabilities) that they had requested for territorial groups, using a multivalue parameter. We then made further structural changes to the report, to meet the innovative business requirement for presenting independent matrices, based upon runtime selections within the new Sales Territory Group parameter. Throughout the two parts of our practice session, we discussed the results we sought to obtain within the development techniques that we exploited. Finally, we concluded with a preview of the report to ascertain the effectiveness of our solution.

» See All Articles by Columnist William E. Pearson, III

Discuss this article in the MSSQL Server 2000 Reporting Services Forum.

MSSQL Server Reporting Services
Introducing the Tablix Data Region: Basic Grouping Concepts
Introducing the Tablix Data Region in Reporting Services 2008
100% Stacked Column Chart for Analysis Services Data
XY (Scatter) Chart for Analysis Services Data
Simple Doughnut Chart for Analysis Services Data
Exploded Pie Chart for Analysis Services Data
Stacked Bar Chart for Analysis Services Data
Line Chart for Analysis Services Data
Stacked Column Chart for Analysis Services Data
A More Advanced Pie Chart for Analysis Services Data
Simple Pie Chart for Analysis Services Data
Simple Bar Chart for Analysis Services Data
Simple Column Chart for Analysis Services Data
Introducing Reporting Services Charts for Analysis Services
Mastering OLAP Reports: Parameterized Grouping
Mastering OLAP Reports: Parameterizing Number of "Top" Items with the MDX TopCount() Function, Part II
Mastering OLAP Reports: Parameterizing Number of "Top" Items with the MDX TopCount() Function, Part I
Mastering OLAP Reports: Parameterizing Number of "Look Back" Periods with the MDX LastPeriods() Function, Part II
Mastering OLAP Reports: Parameterizing Number of "Look Back" Periods with the MDX LastPeriods() Function, Part I
Support Parameterization from Analysis Services - Parameter Defaults
Parameterization from Analysis Services - Cascading Picklists
Support Parameterization from Analysis Services
Parameter Support Objects, Pt II: Support OLAP Parameter Defaults with Datasets
Reporting Services: Customize Automatically Created Parameter Support Objects
Snapshot Reports II: SQL Server Management Studio Perspective
Snapshot Reports I: Report Manager Perspective
Report Execution Caching II: Report Manager Perspective
Report Execution Caching I: SQL Server Management Studio Perspective
Report Session Caching in Reporting Services 2005
Black Belt Administration: Reporting Services Configuration Manager
Intelligent Layering: Leverage Conditional Formatting Logic from Analysis Services
Black Belt Administration: Performance Dashboard for Microsoft SQL Server, Part II
Black Belt Administration: Performance Dashboard for Microsoft SQL Server, Part I
Mastering OLAP Reports: Extend Reporting Services with Custom Code
Mastering OLAP Reports: Parameters for Analysis Services Reporting, Pt. II
Black Belt Components: Support Simple Navigation with a Document Map
Mastering OLAP Reports: Parameters for Analysis Services Reporting, Pt. I
Black Belt Components: Interactive Sorts within a Matrix Data Region
BlackBelt Authoring: Conditional Drillthrough to Multiple Reports
Mastering OLAP Reporting: Prototype KPIs in Reporting Services
BlackBelt Administration: Linked Reports in SQL Server Management Studio
BlackBelt Administration: Linked Reports in Report Manager
Mastering OLAP Reporting: Reporting with Analysis Services KPIs
Report Builder: Creating a Report Model
Mastering OLAP Reporting: Meet Business Needs with Matrix Dynamics, Part II
Mastering OLAP Reporting: Meet Business Needs with Matrix Dynamics, Part 1
Mastering OLAP Reporting: Display a Dataset Field in a Report Page Header
Interactive Sorting Within Reporting Services
MSSQL Server Reporting Services: Mastering OLAP Reporting: Multiple Value Selection in a Parameter Picklist
MSSQL Server Reporting Services : Mastering OLAP Reporting: Drilling Through Using MDX
MSSQL Server Reporting Services: Mastering OLAP Reporting: Relationally-Based Picklists for OLAP Reporting
MSSQL Server Reporting Services: Mastering OLAP Reporting: Extending Conditional Formatting: SWITCH and Drilldown Defaults
MSSQL Server Reporting Services: Mastering OLAP Reporting: Percent of Total - Chart Presentation Nuances
MSSQL Server Reporting Services: Mastering OLAP Reporting: Percent of Total - Two Perspectives
MSSQL Server Reporting Services : Mastering OLAP Reporting: Ad Hoc TopCount and BottomCount Parameters
MSSQL Server Reporting Services: Black Belt Components: Ad Hoc Sorting with Parameters
MSSQL Server Reporting Services: Black Belt Administration: "Governor" Capabilities: Report Execution Timeout
MSSQL Server Reporting Services : Black Belt Administration: Execution Log Performance and Audit Reports
MSSQL Server Reporting Services: Black Belt Administration: Prepare the Execution Log for Reporting
MSSQL Server Reporting Services: Black Belt Components: Ad Hoc Conditional Formatting for OLAP Reports
MSSQL Server Reporting Services : Black Belt Components: Manage Nulls in OLAP Reports
MSSQL Server Reporting Services: Reporting Services Basics: Create a Reusable Template Report
MSSQL Server Reporting Services: Master Chart Reports: Track Exchange Rates in a Line Chart
MSSQL Server Reporting Services: Master Chart Reports: Pie Charts in Reporting Services
MSSQL Server Reporting Services: Mastering OLAP Reporting: Cascading Prompts
MSSQL Server Reporting Services: Managing Reporting Services: Data-driven Subscriptions, and External Data Sources for Subscriber Data
MSSQL Server Reporting Services: Managing Reporting Services: Report Execution and Standard Subscriptions
MSSQL Server Reporting Services: Managing Reporting Services: Data Connections and Uploads
MSSQL Server Reporting Services: The Authoring Phase: Overview Part II
MSSQL Server Reporting Services: The Authoring Phase: Overview Part I
MSSQL Server Reporting Services: A New Paradigm for Enterprise Reporting








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers