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-rcndered 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




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