P


Package Explorer, 146

packages

adding audit columns to, 204–206

backing up databases, 163

batch file processing for, 182, 183

checking database integrity for, 163–165

configuring deployable, 265–267

control and data flow for, 143–144

creating deployment utility for, 267

deploying Integration Services, 265–268

event-driven, 145

executing DTS package for SQL Server 2000, 180–182

executing Integration Services, 268

executing single SQL Server Agent job, 165

installing with deployment utility, 267–268

Integration Services and DTS, 142

logging for, 254–256

Nightly Transfer, 174–175

performing file system functions for, 184–185

running SQL statements or stored procedures, 182, 184

selecting parent or child for processing, 182, 183

sending e-mail messages from, 188–190

sending MSMQ message to different, 186

structure of Integration Services, 142–147

transactions in, 256–259

viewing data flow in Integration Services, 262–263

viewing state during execution, 261–262

page numbers for reports, 607–608

PAGES query dimension, 445–446

ParallelPeriod function, 414–415, 416

parameter management pages, 689, 690

parameters

adding report, 614–616

passing URL report, 687–691

providing defaults for report history snapshots, 654

specifying @Year query, 573

storing values used to create cached report instance, 652

URL format device information, 700

URL report command, 686–687

Parameters tab (Subreport Properties dialog box), 623–624, 626

parent attributes, 313

Parent function, 399, 400

parent-child dimensions, 313

parentheses (), 378

Partition Processing destination, 242

Partition Storage Settings dialog box, 360–363

Partition tab, 353, 370

partitions

creating multiple partitions from single table, 363–366

HOLAP storage options, 362

measure groups and, 352

MOLAP storage options for, 362–363

multiple partitions for measure group, 353–355

ROLAP storage options for, 360, 361–362

storage configurations in Aggregations column, 352, 353

storage options for, 359–363

PDF file printing, 638

PDF format device information parameters, 699

Percentage Sampling transformation, 224–225, 227

performance limitations of OLTP, 28

permissions. See also roles

database access, 404–414

perspectives, 370–371

Perspectives tab, 371

pivot charts, 719, 735–745

adding 3-D columns, 742, 743–744

axis formatting of, 738–739

chart area formatting for, 739–740

data series formatting for, 740, 741

dragging hierarchies and measures to, 738

illustrated, 738

pivot table underlying, 737, 745

selecting data source for, 736

use of MDX queries by, 719

pivot tables, 719, 720–735. See also tables

Accepted Products measure added to, 730, 732,733

adding Time Hierarchy to, 727, 728, 729, 734

connecting data source to, 723

creating external data source for, 720, 722

editing cell labels for, 732, 734

hiding field lists on, 732

layout for, 719

Plant Hierarchy added to, 728, 731

Product hierarchy added to, 728, 730

removing dimensions from, 328, 329

required as source for pivot chart, 737, 745

similarities of CellSet viewer to, 720

use of MDX queries by, 719

Pivot transformations, 226

PivotTable and PivotChart Wizard (Excel)

data fields retrieved for, 725

getting data from data source, 720, 722

opening, 720

options of, 727

selecting data source for analysis, 720, 721

using layout capabilities of, 725–727

PivotTable Options dialog box (Excel), 727

PivotTable toolbar (Excel), 734

POS (point of sale) system, 22

pound sign (#) in Report Model, 661, 662

precedence

Context menu for precedence arrows, 151

precedence constraints, 150, 153–154

setting for tasks, 150–154

Precedence Constraint Editor dialog box, 152, 153–154

predict data columns, 485

predict only data columns, 485

PREDICTION JOIN clause, 546, 547–548, 549

prediction join queries

about, 537

creating, 539–544, 546

illustrated, 541, 542, 543, 544, 546

prediction queries, 547–550

defined, 544

DMX SELECT clause syntax, 545

empty prediction join, 549–550, 551–552

FROM clause syntax for, 546

NATURAL PREDICTION JOIN clause, 549

ORDER BY clause, 547

PREDICTION JOIN clause, 546, 547–548

singleton queries as, 550

WHERE clause, 547

prediction values for Lift Chart

specified, 527–529

unspecified, 526–527

preprocessed aggregates, 48–49

defined, 48

proactive caching of, 55–59

previous year comparisons, 414, 416–417

PrevMember function, 399

primary key table, 123–124

primary keys, 122

printing

client-side, 638–639

HTML, 638

from PDF or TIFF file, 638

reports from Report Manager, 637–639

privileges. See also roles

content manager, 628–629

local administrator, 640–641

Reporting Services tasks, 643

tasks with associated rights in Reporting Services, 642–643

proactive caching, 55–59

problem definition for data mining, 469–470

Process Mining Structure dialog box, 498

Process Progress dialog box, 498, 499

processing Analysis Services database, 323

processing objects in Analysis Services, 178, 179

Profit Chart

about, 520

creating, 530–532

illustrated, 532

Profit Chart Settings dialog box, 531

Project Property Pages dialog box, 324

projects

Business Intelligence Development Studio for deploying, 324–330

creating Analysis Services, 64–66, 67

creating in Visual Studio, 707–708, 711

deploying all contents or single reports of, 631

deploying Analysis Services, 323, 330–338

organization in Visual Studio, 62–63

referencing ADOMDB.NET implementation in, 678

source code management for BI, 63

supported SQL Server Management Studio, 91–92

Projects and Solutions options (Options dialog box), 82

properties. See also Chart Properties dialog box; Table Properties dialog box; and specific properties

adding subproperties to, 590

customizing for report items, 575

setting text properties for reports, 606–607

Properties window

combined in tabbed window, 77–78, 79

using, 68–69

Prospect Analyzer sample application

code retrieving CellSet, 679–683

illustrated, 677

setting reference to assembly, 678–679

Providers and Logs tab (Configure SSIS Logs dialog box), 255

Publisher role, 644




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