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