Index 775
Type 1 SCD, 315–316
Type 2 SCD, 316–318
Type 3 SCD, 318–319
U
UDM (Unified Dimensional Model)
building OLAP on transactional data, 59
data marts and, 96–99
data sources for, 54
data views in, 54–55
defined, 53
ease of creation and maintenance, 60
low latency of, 59
proactive caching of preprocessed aggregates,
55–59
providing OLE DB connections for, 99
source control in, 60
structure of, 53–54
XML object definitions in, 59
union (+) operator, 450
Union All transformation, 238, 240
Unpivot transformation, 238, 241
Update Statistics task, 170–171
Upload File page (Reporting Services), 633
uploading reports in Report Manager, 632, 634
upper-level management
decisions made by, 17–18
use of KPIs, 17, 18
URLs (Uniform Resource Locators)
encoded, 684
launching Report Builder from, 666–667
pulling web images for reports with, 603
URL format device information
parameters, 700
URL-rendered reports
basic report execution, 683–686
browsing folder contents, 687
command parameters for, 686–687
CSV formatting parameters, 694–695
Excel formatting parameters, 695
executing reports with URL access, 683
HTML formatting parameters, 696–697
illustrated, 685
image formatting parameters, 697–698
MHTML formatting parameters, 698
parameter management pages, 689, 690
passing parameters as part of URL, 687–691
PDF formatting parameters, 699
specifying rendering format for, 691–700
URL access using HTTP Post and Get
methods, 700–701, 702
XML formatting parameters, 699–700
Usage-Based Optimization Wizard, 369
V
validation for data mining, 470–471
Variable Value Changed event, 252
variables
displayed in Package Explorer, 146
programming in Integrated Services, 243–245
representing with identifiers, 247
Variables window, 244
VBScript scripts, 177–178
View menu
illustrated, 71
opening Business Intelligence Development
Studio windows from, 70–71
Visibility tab
Details Grouping dialog box, 586
Table Properties dialog box, 581, 583, 585
Visual Basic.NET, 579
Visual FoxPro, 23
Visual Studio 2005
creating projects in, 707–708, 711
editing and debugging tools in, 63
features of Report Designer, 657
project organization in, 62–63
Report Viewer control in, 707
source code management for BI projects, 63
W
web applications. See Report Manager web
application
web farms for Reporting Services, 567–568
web images, 603
Web Service task, 190–191
web services. See also Report Server web service
accessing reports with, 701–702
creating web form for report, 703–706
creating web references for ASP.NET project
and Reporting Services, 702–703
managing Reporting Services through, 707
requests for reports from, 560
WHERE clause, 221, 547
Wholesale Sales By Month report, 591, 592, 593,
597, 598
Get Delivering Business Intelligence with Microsoft SQL Server 2005 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
