List of Figures


Chapter 1: Equipping the Organization for Effective Decision Making

Figure 1-1: Three keys to effective decision making
Figure 1-2: Required elements of a goal to be used in effective decision making
Figure 1-3: Measuring progress toward the goal
Figure 1-4: Aboard the Titanic, feedback information was not given to the decision makers in a timely manner.

Chapter 2: Making the Most of What You've Got—Using Business Intelligence

Figure 2-1: Specific goals at each level of the organization
Figure 2-2: Concrete measures at each level of the organization
Figure 2-3: Timing of the foundation and feedback information at each level of the organization
Figure 2-4: Sources for business intelligence at Max Min, Inc.

Chapter 3: Searching for the Source—The Source of Business Intelligence

Figure 3-1: The SalesFact table
Figure 3-2: The star schema
Figure 3-3: Attribute columns in the dimension tables
Figure 3-4: A star schema with hierarchies
Figure 3-5: The snowflake schema

Chapter 4: One-Stop Shopping—The Unified Dimensional Model

Figure 4-1: Total Sales cube
Figure 4-2: Total Sales cube with an aggregation for John's total sales for April
Figure 4-3: Total Sales cube with an aggregation for total sales for all salespersons for April
Figure 4-4: OLAP Architectures
Figure 4-5: Creating a cached web page in Internet Information Services
Figure 4-6: Retrieving a web page from the Internet Information Services Page Cache
Figure 4-7: Updating the Internet Information Services Page Cache when a web page is modified
Figure 4-8: Proactive caching with a Unified Dimensional Model
Figure 4-9: Even the first user receives the requested aggregate from the Proactive Cache.
Figure 4-10: The Proactive Cache is deleted and re-created in response to changes in the data source.

Chapter 5: First Steps—Beginning the Development of Business Intelligence

Figure 5-1: Business Intelligence Development Studio on the Start menu
Figure 5-2: The New Project Toolbar button
Figure 5-3: The New Project dialog box
Figure 5-4: The Business Intelligence Development Studio with an empty Analysis Services project
Figure 5-5: The Solution Explorer window with the View Code and View Designer Toolbar buttons
Figure 5-6: The Properties window with categorized properties
Figure 5-7: Displaying the Toolbox window when it is set to auto hide
Figure 5-8: The View menu
Figure 5-9: Toolbar buttons for opening Business Intelligence Development Studio windows
Figure 5-10: The Task List window
Figure 5-11: The Error List window
Figure 5-12: The Output window
Figure 5-13: The Find Results 1 window
Figure 5-14: The Designer window with the Dimension, Cube, and Data Source View designers open
Figure 5-15: Changing a window's state
Figure 5-16: The Solution Explorer as a floating window
Figure 5-17: The Properties window and the Solution Explorer window combined in a Tabbed window
Figure 5-18: The Solution Explorer window in a tabbed grouping on the Designer window
Figure 5-19: The Options dialog box
Figure 5-20: The Designer window with an MDI interface
Figure 5-21: Fonts and Colors options
Figure 5-22: Projects and Solutions—General options
Figure 5-23: SQL Server Management Studio on the Start menu
Figure 5-24: Connecting to a server on startup
Figure 5-25: The SQL Server Management Studio Default window layout
Figure 5-26: Registering a new server
Figure 5-27: The New Server Registration dialog box
Figure 5-28: Server groups in the Registered Servers window
Figure 5-29: Server types in the Registered Servers window
Figure 5-30: The Object Explorer window
Figure 5-31: The New Query Toolbar button
Figure 5-32: The SQL Server Management Studio with a SQL Server Query window
Figure 5-33: The SQL Server Management Studio with a solution and a project

Chapter 6: Building Foundations—Creating and Populating Data Marts

Figure 6-1: An Analysis Services cube receiving data from a data mart
Figure 6-2: The Unified Dimensional Model eliminates the need for a data mart
Figure 6-3: Situations where UDM cannot be used
Figure 6-4: Designing the measures in a data mart
Figure 6-5: Designing the dimensions and hierarchies in a data mart
Figure 6-6: Designing the attributes in a data mart
Figure 6-7: A star schema
Figure 6-8: A snowflake schema
Figure 6-9: Requested measures for the Manufacturing data mart
Figure 6-10: Finalized measures for the Manufacturing data mart
Figure 6-11: Requested dimensions for the Manufacturing data mart
Figure 6-12: Finalized dimensions and hierarchies for the Manufacturing data mart
Figure 6-13: Finalized attributes for the Manufacturing data mart
Figure 6-14: The Manufacturing data mart schema with measures in a fact table
Figure 6-15: The Manufacturing data mart schema with dimension tables added
Figure 6-16: The Manufacturing data mart schema with hierarchies added
Figure 6-17: The completed Manufacturing data mart schema
Figure 6-18: Building the relational data mart
Figure 6-19: The Database folder Context menu
Figure 6-20: The New Database dialog box
Figure 6-21: The SQL Server Management Studio ready to create a table
Figure 6-22: The tables in the MaxMinManufacturingDM with columns (Part 1)
Figure 6-23: The tables in the MaxMinManufacturingDM with columns (Part 2)
Figure 6-24: Selecting multiple fields to create a compound primary key
Figure 6-25: Entering the Tables and Columns Specifications for a foreign key
Figure 6-26: Activating the field drop-down list in the Tables and Columns dialog box
Figure 6-27: Setting the drop-down lists to <None> in the Tables and Columns dialog box
Figure 6-28: The tables in the MaxMinManufacturingDM with columns and keys (Part 1)
Figure 6-29: The tables in the MaxMinManufacturingDM with columns and keys (Part 2)
Figure 6-30: Building the Sales relational data mart and the Sales Analysis Services cube
Figure 6-31: After selecting measures in the Cube Wizard
Figure 6-32: The MaxMinSales cube preview in the Cube Wizard
Figure 6-33: The Schema Generation Progress dialog box with a successful process completion
Figure 6-34: The Schema Generation Progress dialog box after an error has occurred
Figure 6-35: The Max Min Sales star schema

Chapter 7: Fill'er Up—Using Integration Services for Populating Data Marts

Figure 7-1: The Integration Services package design layout in the Business Intelligence Development Studio
Figure 7-2: The Integration Services package structure Control Flow tab
Figure 7-3: The Integration Services package structure Data Flow Designer tab
Figure 7-4: The Integration Services package structure Event Handlers Designer tab
Figure 7-5: Defining a data flow task in an event handler control flow
Figure 7-6: Creating control flow tasks from the Toolbox
Figure 7-7: Setting the properties of a task using the task's Editor dialog box
Figure 7-8: Making a precedence connection between two tasks
Figure 7-9: The precedence arrow
Figure 7-10: The precedence arrow Context menu
Figure 7-11: A control flow task with a second precedence arrow
Figure 7-12: Using precedence arrows to make a complex sequence of tasks
Figure 7-13: The Precedence Constraint Editor dialog box
Figure 7-14: The Back Up Database Task dialog box
Figure 7-15: The database selection drop-down box
Figure 7-16: The Check Database Integrity Task dialog box
Figure 7-17: The Execute SQL Server Agent Job Task dialog box
Figure 7-18: The Execute T-SQL Statement Task dialog box
Figure 7-19: The History Cleanup Task dialog box
Figure 7-20: The Notify Operator Task dialog box
Figure 7-21: The Rebuild Index Task dialog box
Figure 7-22: The Reorganize Index Task dialog box
Figure 7-23: The Shrink Database Task dialog box
Figure 7-24: The Update Statistics Task dialog box
Figure 7-25: A For Loop container in a control flow
Figure 7-26: The For Loop Editor dialog box
Figure 7-27: The Nightly Transfer package using a Foreach Loop container
Figure 7-28: The Collection page of the Foreach Loop container in the Nightly Transfer package
Figure 7-29: Sequence Container 1 is showing its content. Sequence Container 2 is hiding its content.
Figure 7-30: The Script page of the ActiveX Script Task Editor dialog box
Figure 7-31: The Analysis Services Execute DDL Task Editor dialog box
Figure 7-32: The Analysis Services Processing Task Editor dialog box
Figure 7-33: The Bulk Insert Task Editor dialog box
Figure 7-34: The Mining Model tab of the Data Mining Query Task Editor dialog box
Figure 7-35: The Execute DTS 2000 Package Task Editor dialog box.
Figure 7-36: The Execute Package Task Editor dialog box
Figure 7-37: The Execute Process Task Editor dialog box
Figure 7-38: The Execute SQL Task Editor dialog box
Figure 7-39: The File System Task Editor dialog box
Figure 7-40: The File Transfer Protocol Task Editor dialog box
Figure 7-41: The Message Queue Task Editor dialog box
Figure 7-42: The Script Task Editor dialog box
Figure 7-43: The Script Editing window
Figure 7-44: The Send Mail Task Editor dialog box
Figure 7-45: The Web Service Task Editor dialog box
Figure 7-46: The WMI Data Reader Task Editor dialog box
Figure 7-47: The WMI Event Watcher Task Editor dialog box
Figure 7-48: The XML Task Editor dialog box
Figure 7-49: The Component Properties tab of the Advanced Editor for DataReader Source dialog box
Figure 7-50: The Excel Source Editor dialog box
Figure 7-51: The General page of the Flat File Connection Manager Editor dialog box
Figure 7-52: The Columns page of the Flat File Connection Manager Editor dialog box
Figure 7-53: The Advanced page of the Flat File Connection Manager Editor dialog box
Figure 7-54: The Connection Manager page of the OLE DB Source Editor dialog box
Figure 7-55: The Query Builder
Figure 7-56: The Advanced Editor for the Raw File Source dialog box
Figure 7-57: The XML Source Editor dialog box
Figure 7-58: The Aggregate Transformation Editor dialog box
Figure 7-59: The Audit Transformation Editor dialog box
Figure 7-60: The Character Map Transformation Editor dialog box
Figure 7-61: The Configure Error Output dialog box
Figure 7-62: The Conditional Split Transformation Editor dialog box
Figure 7-63: A Conditional Split transformation in a data flow
Figure 7-64: The Copy Column Transformation Editor dialog box
Figure 7-65: The Data Conversion Transformation Editor dialog box
Figure 7-66: The Mining Model tab of the Data Mining Query Transformation Editor dialog box
Figure 7-67: The Derived Column Transformation Editor dialog box
Figure 7-68: The Export Column Transformation Editor dialog box
Figure 7-69: The Columns tab of the Fuzzy Grouping Transformation Editor dialog box
Figure 7-70: The Advanced tab of the Fuzzy Grouping Transformation Editor dialog box
Figure 7-71: The Reference Table tab of the Fuzzy Lookup Transformation Editor dialog box
Figure 7-72: The Advanced Editor for Import Column dialog box
Figure 7-73: The Advanced tab of the Lookup Transformation Editor dialog box
Figure 7-74: The Merge Transformation Editor dialog box
Figure 7-75: The Merge Join Transformation Editor dialog box
Figure 7-76: The Multicast Transformation Editor dialog box
Figure 7-77: The Advanced Editor for OLE DB Command dialog box
Figure 7-78: The Percentage Sampling Transformation Editor dialog box
Figure 7-79: The Advanced Editor for Pivot dialog box
Figure 7-80: The Advanced Editor for Row Count dialog box
Figure 7-81: The Row Sampling Transformation Editor dialog box
Figure 7-82: The Inputs and Outputs page of the Script Transformation Editor dialog box
Figure 7-83: The Microsoft Visual Studio for Applications dialog box
Figure 7-84: The Select a Dimension Table and Keys page of the Slowly Changing Dimension Wizard
Figure 7-85: The Slowly Changing Dimension Columns page of the Slowly Changing Dimension Wizard
Figure 7-86: The Historical Attribute Options page of the Slowly Changing Dimension Wizard
Figure 7-87: The results of the Slowly Changing Dimension Wizard
Figure 7-88: The Sort Transformation Editor dialog box
Figure 7-89: The Advanced tab of the Term Extraction Transformation Editor dialog box
Figure 7-90: The Term Lookup tab of the Term Lookup Transformation Editor dialog box
Figure 7-91: The Union All Transformation Editor dialog box
Figure 7-92: The Unpivot Transformation Editor dialog box
Figure 7-93: The Variables window
Figure 7-94: The Event Handlers tab
Figure 7-95: The Advanced Editor for Row Count dialog box
Figure 7-96: The Providers and Logs tab of the Configure SSIS Logs dialog box
Figure 7-97: The Details tab of the Configure SSIS Logs dialog box
Figure 7-98: Sample Integration Services package
Figure 7-99: Transactions created when executing the Sample Integration Services package
Figure 7-100: The Set Breakpoints dialog box
Figure 7-101: The Configure Data Viewer dialog box
Figure 7-102: Data Viewer windows

Chapter 8: Cubism—Measures and Dimensions

Figure 8-1: The InventoryFact table
Figure 8-2: The Data Flow tab for the Load DimBatch Data Flow task
Figure 8-3: The Data Flow tab for the Load ManufacturingFact Data Flow task
Figure 8-4: The Data Flow tab for the Load InventoryFact Data Flow task
Figure 8-5: The Control Flow tab for the FactLoad.dtsx package
Figure 8-6: The Data Source View Design tab for the Max Min Manufacturing DM data source view
Figure 8-7: The Business Intelligence Development Studio windows after the Cube Wizard completes
Figure 8-8: Measure groups and dimensions
Figure 8-9: The Calculations tab
Figure 8-10: The Calculated Member form view
Figure 8-11: The Script view
Figure 8-12: Setting the aggregate function for a measure
Figure 8-13: Inventory level is a semiadditive measure.
Figure 8-14: The Max Min Manufacturing DM cube with the Inventory Fact measure group
Figure 8-15: The Dimension Design tab with the Dim Product dimension
Figure 8-16: The modified Dim Time dimension
Figure 8-17: The Dimension Usage tab of the Max Min Manufacturing DM cube
Figure 8-18: The Define Relationship dialog box for a fact dimension
Figure 8-19: An employee table with a self-referential field
Figure 8-20: The state of the salesperson Type 1 SCD in May
Figure 8-21: The state of the salesperson Type 1 SCD after August
Figure 8-22: The state of the salesperson Type 2 SCD in May
Figure 8-23: The state of the salesperson Type 2 SCD after August

Chapter 9: Bells and Whistles—Special Features of OLAP Cubes

Figure 9-1: The Project Property Pages dialog box
Figure 9-2: Deploying an Analysis Services project from the Business Intelligence Development Studio
Figure 9-3: The Browse window in the SQL Server Management Studio
Figure 9-4: Browsing the Max Min Manufacturing DM cube
Figure 9-5: Two levels of rows in the Browse window
Figure 9-6: Adding a column level to the Browse window
Figure 9-7: Two levels of rows and columns in the Browse window
Figure 9-8: Dragging an item off the Pivot table
Figure 9-9: The Specify Source Analysis Services Database page of the Analysis Services Deployment Wizard
Figure 9-10: The Installation Target page of the Analysis Services Deployment Wizard
Figure 9-11: The Specify Options for Partitions and Roles page of the Analysis Services Deployment Wizard
Figure 9-12: The Specify Configuration Properties page of the Analysis Services Deployment Wizard
Figure 9-13: The Select Processing Options page of the Analysis Services Deployment Wizard
Figure 9-14: The Confirm Deployment page of the Analysis Services Deployment Wizard
Figure 9-15: The Deploying Database page of the Analysis Services Deployment Wizard
Figure 9-16: The Deployment Script loaded in a SQL Server Management Stuclio XMLA Query window
Figure 9-17: Creating a linked object
Figure 9-18: The Select Objects page of the Linked Object Wizard
Figure 9-19: A cube definition with linked objects
Figure 9-20: Launching the Business Intelligence Wizard
Figure 9-21: The KPIs tab on the Cube Design tab
Figure 9-22: The Browser View toolbar button
Figure 9-23: The KPI browser with the Percent Rejected KPI for the entire cube
Figure 9-24: The KPI browser with the Percent Rejected KPI for January 1, 2005
Figure 9-25: The Actions tab on the Cube Design tab
Figure 9-26: The Partitions tab on the Cube Design tab
Figure 9-27: A partitioned view
Figure 9-28: A measure group with multiple partitions from multiple relational tables
Figure 9-29: A measure group with multiple partitions from a single relational table
Figure 9-30: Creating a New Named Query
Figure 9-31: The ManufacturingFact 2003 Named Query definition
Figure 9-32: The Manufacturing Fact measure group with three partitions
Figure 9-33: The Storage Settings dialog box
Figure 9-34: The General tab of the Storage Options dialog box
Figure 9-35: The Notifications tab of the Storage Options dialog box
Figure 9-36: The Specify Object Counts page of the Aggregation Design Wizard
Figure 9-37: The Set Aggregation Options page of the Aggregation Design Wizard
Figure 9-38: The Partitions tab with aggregation design completed
Figure 9-39: The Enable Writeback dialog box
Figure 9-40: The Partitions tab with a writeback partition
Figure 9-41: The Perspectives tab
Figure 9-42: The Translations tab
Figure 9-43: The Select Language dialog box

Chapter 10: Writing a New Script—MDX Scripting

Figure 10-1: A simplified Max Min Manufacturing DM cube
Figure 10-2: The Dim Product dimension
Figure 10-3: The path to the Dragon w/Knight product
Figure 10-4: The path to the WWII product type
Figure 10-5: A shortcut path to the WWII product type
Figure 10-6: A more complex version of the Max Min Manufacturing DM cube
Figure 10-7: A tuple with one dimension omitted
Figure 10-8: Another aggregate cell in the Max Min Manufacturing DM cube
Figure 10-9: A multicell set
Figure 10-10: A cell group requiring a set
Figure 10-11: A cell group using a set with ranges
Figure 10-12: The Set Default Member dialog box
Figure 10-13: The Dim Time dimension with revised hierarchy level names
Figure 10-14: The Dim Product dimension with revised hierarchy level names
Figure 10-15: The Dim Machine dimension with revised hierarchy level names
Figure 10-16: The Dim Batch dimension with revised hierarchy level names
Figure 10-17: Comparing measures from two cells using relative location
Figure 10-18: MDX relative position functions within the same hierarchy
Figure 10-19: MDX immediate relative position functions within the same hierarchy
Figure 10-20: MDX distant relative position functions within the same hierarchy
Figure 10-21: The General page of the Role Design tab
Figure 10-22: The Membership page of the Role Design tab
Figure 10-23: The Data Sources page of the Role Design tab
Figure 10-24: The Cubes page of the Role Design tab
Figure 10-25: The Cell Data page of the Role Design tab
Figure 10-26: The Dimensions page of the Role Design tab
Figure 10-27: The Basic tab of the Dimension Data page of the Role Design tab
Figure 10-28: The Advanced tab of the Dimension Data page for the Dim Machine dimension
Figure 10-29: The Advanced tab of the Dimension Data page for the Dim Product dimension
Figure 10-30: The Browser tab using administrative credentials
Figure 10-31: The Security Context dialog box
Figure 10-32: The Browser tab using the Kawaguchi Plant security role
Figure 10-33: The Prey Year Percent Rejected calculated measure
Figure 10-34: The Year-Jo-Date Total Products calculated measure
Figure 10-35: Browsing the calculated members

Chapter 11: Pulling It Out and Building It Up—MDX Queries

Figure 11-1: The SQL Server Management Studio with an MDX Query window
Figure 11-2: The most basic MDX SELECT statement
Figure 11-3: An MDX SELECT statement with a query dimension
Figure 11-4: Creating a result with a COLUMNS query dimension
Figure 11-5: An MDX SELECT statement with two query dimensions
Figure 11-6: Creating a result with two query dimensions
Figure 11-7: Measures dimension members in the COLUMNS query dimension
Figure 11-8: An MDX SELECT statement with a slicer dimension
Figure 11-9: An MDX SELECT statement with a tuple in the slicer dimension
Figure 11-10: Creating a result with a slicer tuple
Figure 11-11: An MDX SELECT statement using the FILTER function
Figure 11-12: An MDX SELECT statement using a named set
Figure 11-13: An MDX SELECT statement using temporary calculated members
Figure 11-14: An MDX SELECT statement using a temporary calculated member of the Measures dimension
Figure 11-15: An MDX SELECT statement using the CROSSJOIN function
Figure 11-16: An MDX SELECT statement using the NON EMPTY keyword
Figure 11-17: An MDX SELECT statement using the TOPCOUNT function
Figure 11-18: An MDX SELECT statement using the BOTTOMCOUNT function
Figure 11-19: An MDX SELECT statement using the TOP COUNT function along with a ROWS query dimension
Figure 11-20: An MDX SELECT statement using SUM and COUNT aggregates
Figure 11-21: An MDX SELECT statement using AXIS(0) and AXIS(1)
Figure 11-22: A front-end Query window error when trying to use three query dimensions

Chapter 12: Panning for Gold—Introduction to Data Mining

Figure 12-1: Topographic information data overload
Figure 12-2: A topographic map
Figure 12-3: Planning a route using a topographic map
Figure 12-4: Data overload leads to confusion
Figure 12-5: Making predictions from the topographic map
Figure 12-6: Classification
Figure 12-7: Regression
Figure 12-8: Segmentation
Figure 12-9: Association
Figure 12-10: Sequence analysis
Figure 12-11: The Microsoft Decision Trees algorithm
Figure 12-12: The Naïve Bayes algorithm
Figure 12-13: The Microsoft Clustering algorithm
Figure 12-14: The Microsoft Association algorithm
Figure 12-15: The Microsoft Sequence Clustering algorithm
Figure 12-16: The Microsoft Time Series algorithm
Figure 12-17: The Microsoft Neural Network algorithm

Chapter 13: Building the Mine—Working with the Data Mining Model

Figure 13-1: The Select the Definition Method page of the Data Mining Wizard
Figure 13-2: The Select the Data Mining Technique page of the Data Mining Wizard
Figure 13-3: The Select the Source Cube Dimension page of the Data Mining Wizard
Figure 13-4: The Select the Case Key page of the Data Mining Wizard
Figure 13-5: The Select Case Level Columns page of the Data Mining Wizard
Figure 13-6: The Specify Mining Model Column Usage page of the Data Mining Wizard
Figure 13-7: The Specify Columns' Content and Data Type page of the Data Mining Wizard
Figure 13-8: The Filter Members dialog box
Figure 13-9: The Slice Source Cube page of the Data Mining Wizard
Figure 13-10: The Completing the Wizard page of the Data Mining Wizard
Figure 13-11: The Mining Structure tab on the Data Mining Design tab
Figure 13-12: Changing the column usage
Figure 13-13: The New Mining Model dialog box
Figure 13-14: The Mining Models tab on the Data Mining Design tab
Figure 13-15: The Process Mining Structure dialog box
Figure 13-16: The Process Progress dialog box
Figure 13-17: The decision tree view for the Microsoft Decision Tree algorithm
Figure 13-18: The decision tree with 0 Children At Home versus 1 or More Children At Home
Figure 13-19: The Dependency Network tab for the Microsoft Decision Tree algorithm
Figure 13-20: The strongest influence in this data mining model
Figure 13-21: The Microsoft Mining Content Viewer
Figure 13-22: The Dependency Network Viewer for the Microsoft Naïve Bayes algorithm
Figure 13-23: The strongest influence in this mining model
Figure 13-24: The Attribute Profiles Viewer for the Microsoft Naïve Bayes algorithm
Figure 13-25: The Attribute Characteristics Viewer for the Microsoft Naïve Bayes algorithm
Figure 13-26: The Attribute Discrimination Viewer for the Microsoft Naïve Bayes algorithm
Figure 13-27: The Cluster Diagram Viewer for the Microsoft Clustering algorithm
Figure 13-28: The Cluster Profiles Viewer for the Microsoft Clustering algorithm
Figure 13-29: The Cluster Characteristics Viewer for the Microsoft Clustering algorithm
Figure 13-30: The Cluster Discrimination Viewer for Microsoft Clustering algorithm
Figure 13-31: The Discrimination Viewer for the Microsoft Neural Network algorithm
Figure 13-32: The Itemsets Viewer for the Microsoft Association algorithm
Figure 13-33: The Rules Viewer for the Microsoft Association algorithm
Figure 13-34: The Dependency Network Viewer for the Microsoft Association algorithm
Figure 13-35: The Chart Viewer for the Microsoft Time Series algorithm

Chapter 14: Spelunking—Exploration Using Data Mining

Figure 14-1: The Column Mapping tab before configuration
Figure 14-2: The Select Mining Structure dialog box
Figure 14-3: The Select Table dialog box
Figure 14-4: Deleting a column mapping
Figure 14-5: the Column Mapping tab after configuration
Figure 14-6: The Lift Chart with no prediction value specified
Figure 14-7: The Lift Chart for the Classification - Children At Home mining model
Figure 14-8: The Lift Chart at 10%
Figure 14-9: The Lift Chart at 20%
Figure 14-10: The Lift Chart at 35%
Figure 14-11: The Profit Chart Settings dialog box
Figure 14-12: The Profit Chart
Figure 14-13: The Classification Matrix
Figure 14-14: The Singleton Query toolbar button
Figure 14-15: The Select Mining Model dialog box
Figure 14-16: Selecting the columns in the singleton query result set
Figure 14-17: The completed singleton query
Figure 14-18: Selecting the result view
Figure 14-19: The singleton query result set in the result view
Figure 14-20: The completed prediction join query
Figure 14-21: The prediction join query result set in the result view
Figure 14-22: The prediction join query with filter criteria
Figure 14-23: The prediction join query result set with filter criteria
Figure 14-24: The save data mining query result dialog box
Figure 14-25: A DMX prediction join query
Figure 14-26: An empty prediction query in the SQL Server Management Studio
Figure 14-27: A singleton query in the SQL Server Management Studio

Chapter 15: On Report—Delivering Business Intelligence with Reporting Services

Figure 15-1: Report structure
Figure 15-2: Report Server functional structure
Figure 15-3: Reporting Services component parts
Figure 15-4: A distributed installation of Reporting Services
Figure 15-5: A web farm installation of Reporting Services
Figure 15-6: The Query Builder screen
Figure 15-7: The Design the Table page of the Report Wizard
Figure 15-8: The Choose the Table Layout page of the Report Wizard
Figure 15-9: The Completing the Wizard page of the Report Wizard
Figure 15-10: The table data region created by the Report Wizard
Figure 15-11: Widening a table column
Figure 15-12: The Textbox Properties dialog box
Figure 15-13: The Manufacturing By Machine Report preview
Figure 15-14: The database field expression for a detail cell
Figure 15-15: The database field expression with an aggregate function for a group header cell
Figure 15-16: The General tab of the Table Properties dialog box
Figure 15-17: The Visibility tab of the Table Properties dialog box
Figure 15-18: The Navigation tab of the Table Properties dialog box
Figure 15-19: The Sorting tab of the Table Properties dialog box
Figure 15-20: The Groups tab of the Table Properties dialog box
Figure 15-21: The Grouping and Sorting Properties dialog box
Figure 15-22: The General tab of the Details Grouping dialog box
Figure 15-23: The Visibility tab of the Details Grouping dialog box
Figure 15-24: The Filters tab of the Table Properties dialog box
Figure 15-25: The Data Output tab of the Table Properties dialog box
Figure 15-26: The MDX Query Builder with the query for the Wholesale Sales By Month Report
Figure 15-27: The report layout for the Wholesale Sales By Month Report
Figure 15-28: The Matrix Properties dialog box
Figure 15-29: The Wholesale Sales By Month Report preview
Figure 15-30: The matrix layout with multiple cells selected
Figure 15-31: The final version of the Wholesale Sales By Month Report
Figure 15-32: The Wholesale Sales By Month Report preview—almost done
Figure 15-33: The Wholesale Sales By Month Report preview—completed
Figure 15-34: The DMX Query Builder
Figure 15-35: The initial field layout for the Customer List With Prediction Report
Figure 15-36: The Customer List With Prediction Report layout with labels added
Figure 15-37: The Select the Image Source page of the Image Wizard
Figure 15-38: The Choose the Embedded Image page of the Image Wizard
Figure 15-39: The Customer List With Prediction Report with the Mythic World Buyer image
Figure 15-40: The Layout tab of the Report Properties dialog box
Figure 15-41: The page number expression for the text box in the page footer
Figure 15-42: The Sorting tab of the List Properties dialog box
Figure 15-43: The Navigation tab of the Textbox Properties dialog box
Figure 15-44: A page of the completed Customer List With Prediction Report
Figure 15-45: A page from the Customer List With Prediction Report print preview
Figure 15-46: The stored procedure version of the Query Builder
Figure 15-47: The Report Parameters dialog box
Figure 15-48: The chart data region with drag-and-drop targets
Figure 15-49: The basic Inventory Levels By Month Report layout
Figure 15-50: The basic Inventory Levels By Month Report preview
Figure 15-51: The General tab of the Chart Properties dialog box
Figure 15-52: The Data tab of the Chart Properties dialog box
Figure 15-53: The Appearance tab of the Edit Chart Value dialog box
Figure 15-54: The X Axis tab of the Chart Properties dialog box
Figure 15-55: The Y Axis tab of the Chart Properties dialog box
Figure 15-56: The Legend tab of the Chart Properties dialog box
Figure 15-57: The 3D Effect tab of the Chart Properties dialog box
Figure 15-58: The completed chart in the Inventory Levels By Month Report
Figure 15-59: The General tab of the Subreport Properties dialog box
Figure 15-60: The Parameters tab of the Subreport Properties dialog box
Figure 15-61: The Inventory Levels By Month Report layout with a subreport
Figure 15-62: The Inventory Levels By Month Report preview with a subreport
Figure 15-63: The Report Manager with no folders defined
Figure 15-64: The MaxMinReports Property Pages dialog box
Figure 15-65: The Upload File page
Figure 15-66: The Reporting Services Error page
Figure 15-67: The New Data Source page
Figure 15-68: RMUpload folder detail view
Figure 15-69: The Security page for the Home folder
Figure 15-70: The New Role Assignment page
Figure 15-71: A linked report
Figure 15-72: The Execution Properties page
Figure 15-73: The Select Report Model Generation Rules page of the Report Model Wizard
Figure 15-74: Entities in the Manufacturing Data Mart Report Model
Figure 15-75: Attributes and roles of the Dim Machine entity in the Manufacturing Data Mart Report Model
Figure 15-76: The Manufacturing Data Mart Report Model deployed to the Report Server
Figure 15-77: The Report Model Properties dialog box in the SQL Server Management Studio
Figure 15-78: The Model Item Security page of the Report Model Properties dialog box
Figure 15-79: Selecting a source of data from a Report Model with four perspectives
Figure 15-80: The Report Builder screen
Figure 15-81: The Define Formula dialog box

Chapter 16: Let's Get Together—Integrating Olap with Your Applications

Figure 16-1: A partial view of the CellSet structure
Figure 16-2: The Prospect Analyzer sample application with a three-dimensional MDX query result viewer
Figure 16-3: The Add Reference dialog box with the entry for the ADOMD.NET client highlighted
Figure 16-4: The References page of the Project Properties tab
Figure 16-5: A URL-rendered report
Figure 16-6: Browsing folder contents using URL access
Figure 16-7: A report parameter passed in the URL
Figure 16-8: The Parameter management page with a hidden parameter
Figure 16-9: The report without a parameter area
Figure 16-10: The Parameter management page with a read-only parameter
Figure 16-11: The parameters are suppressed.
Figure 16-12: The suppressed toolbar
Figure 16-13: The HTML form for requesting a report using an HTTP method
Figure 16-14: The Report Front End form
Figure 16-15: Placing a Report Viewer control on a Windows form
Figure 16-16: Opening the Reportviewer Tasks dialog box
Figure 16-17: The Report Viewer displaying a report with drilldown
Figure 16-18: Creating a new report
Figure 16-19: The Choose a Data Source Type page of the Data Source Configuration Wizard
Figure 16-20: The Choose Your Data Connection page of the Data Source Configuration Wizard
Figure 16-21: The Save the Connection String to the Application Configuration File page of the Data Source Configuration Wizard
Figure 16-22: The Choose Your Database Objects page of the Data Source Configuration Wizard
Figure 16-23: The ProductList Data Source in the Data Sources window
Figure 16-24: Layout of the local report
Figure 16-25: The Product List local report

Chapter 17: Another Point of View—Excel Pivot Tables and Pivot Charts

Figure 17-1: Starting the PivotTable and PivotChart Wizard
Figure 17-2: Step 1 of the PivotTable and PivotChart Wizard
Figure 17-3: Step 2 of the PivotToble and PivotChart Wizard
Figure 17-4: The Choose Data Source dialog box
Figure 17-5: The Create New Data Source dialog box
Figure 17-6: The Multidimensional Connection 9.0 dialog box
Figure 17-7: Selecting a database in the Multidimensional Connection 9.0 dialog box
Figure 17-8: The Create New Data Source dialog box with an Analysis Services database and cube selected
Figure 17-9: The Choose Data Source dialog box with the new data source
Figure 17-10: Step 2 of the PivotTable And PivotChart Wizard with data retrieved
Figure 17-11: Step 3 of the PivotTable and PivotChart Wizard
Figure 17-12: The Layout page of the PivotTable and PivotChart Wizard with an empty layout
Figure 17-13: The Layout page of the PivotTable and PivotChart Wizard with a completed layout
Figure 17-14: The PivotTable Options dialog box
Figure 17-15: The empty PivotTable layout in the Excel spreadsheet
Figure 17-16: Defining the page dimension of the PivotTable
Figure 17-17: Using the drop-down window to select dimension members
Figure 17-18: Selecting 2005Q1 and 2005Q2 for the page dimension
Figure 17-19: The double checkmark, indicating all members selected at the next lower level in the hierarchy
Figure 17-20: The PivotTable layout with Product Types and Product Subtypes
Figure 17-21: The Plant Hierarchy added to the PivotTable layout
Figure 17-22: The Accepted Products measure added to the PivotTable layout
Figure 17-23: Both the Accepted Products and Rejected Products measures in the PivotTable layout
Figure 17-24: The Hide Field List button in the PivotTable toolbar
Figure 17-25: The Accepted Products measure label changed to # Accepted
Figure 17-26: The Field Settings button in the PivotTable toolbar
Figure 17-27: The AutoFormat dialog box
Figure 17-28: The PivotTable with an AutoFormat applied
Figure 17-29: The PivotChart layout
Figure 17-30: A PivotChart
Figure 17-31: The Format Axis dialog box
Figure 17-32: The Format Chart Area dialog box
Figure 17-33: Choosing a color in the Format Data Series dialog box
Figure 17-34: The completed PivotChart with stacked bars
Figure 17-35: The 3-D Column Chart in the Chart Type drop-down window
Figure 17-36: The PivotChart with 3-D columns
Figure 17-37: The PivotChart with a drilldown into the quarters of 2005
Figure 17-38: The PivotChart with a data table
Figure 17-39: The PivotTable underlying the PivotChart




Delivering Business Intelligence with Microsoft SQL Server 2005
Delivering Business Intelligence with Microsoft SQL Server 2005: Utilize Microsofts Data Warehousing, Mining & Reporting Tools to Provide Critical Intelligence to A
ISBN: 0072260904
EAN: 2147483647
Year: 2007
Pages: 112
Authors: Brian Larson

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net