E


Edit Chart Value dialog box, 618, 620

Edit Expression dialog box, 578, 580, 581

editing

cell expressions for report detail, 578, 580

editing tools for Visual Studio, 63

expressions in list reports, 601–602

pivot tables cell labels, 732, 734

tasks for control flow, 148–149, 150

effective decisions

defined, 5–6

making, 6–11

e-mail delivery option for subscriptions, 654, 656

embedding images in reports, 602–604

empty prediction join, 549–550, 551–552

Enable Writeback dialog box, 369

enabling

drill down data for reports, 573, 575, 591

report caching, 651

SQL Notification for named queries, 364–365

writeback, 369–370

encoded URLs, 684

entities in Report Builder, 668, 669

Error List window, 72

errors

correcting table, 119

executing report through URL access, 684

made creating cubes, 136, 138

splitting data flows, 209

uploading reports in Report Manager, 632, 634

using too many query dimensions, 447

ETL (Extract, Transform, and Load) process, 32

EvalExpression property, 171–172

event handlers

control flow, 251–252, 253

defined, 145

Event Handlers Designer tab (Business Intelligence Development Studio), 143

events

defined, 145

event handlers for control flow, 251–252, 253

Variable Value Changed, 252

Excel. See also pivot charts; pivot tables; PivotTable and PivotChart Wizard

device information parameters for, 695

features for BI use, 745

pivot charts, 719, 735–745

pivot tables, 719, 720–735

PivotTable and PivotChart Wizard layout capabilities, 725–727

sending data flow to spreadsheet file, 241

similarities of CellSet viewer to pivot table, 720

using source data from, 196

except (-) operator, 450

Execute DTS 2000 Package task, 180–182

Execute Package task, 182, 183

Execute Process task, 182, 183

Execute SQL Server Agent Job task, 165, 166

Execute SQL task, 182, 184

Execute T-SQL Statement task, 165–166, 167

Execution Properties page (Reporting Services), 651, 652

execution snapshots in Report Server, 653

Export Column transformations, 212, 215

expressions

case sensitivity of MDX, 378

creating derived column from, 212, 214

defining calculated measures with, 297

editing in list reports, 601–602

editing in report cells, 578, 580

errors entering MDX scripting, 383

functions supported by, 249–251

Integrated Services, 245

language used in data source view for, 289–290

operators supported by, 248–249

page number, 607–608

shortcuts for MDX script, 380–382

syntax for MDX tuples in, 378

in Visual Basic.NET for Reporting Services, 579

Extensible Markup Language. See XML

Extract, Transform, and Load (ETL) process, 32




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

Similar book on Amazon

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