packages (Integration Services)
ASBackup, 567-576
automating, 587-591
PartitionProcessing, 576-579
PipelineDataLoad, 579-587
Panorama Software
client tools, 564
Reporting Services tools, 595
Parallel command, 373
parallel processing
competition for resources and, 447
controlling amount of parallelism, 443-446
CoordinatorExecutionMode server property and, 444
partitions and, 432
ParallelPeriod function (MDX), 85-86, 766
parameterized queries, SQL injection and, 205-206, 350
.Parent function (MDX), 766-767
Parent-Child hierarchies
adding a member to a dimension and, 347-348
creating, 139-142
custom names for levels, 223-225
custom rollups applied to, 211, 212-217
multiple levels contained in, 141-142
in organizational charts, 119
retrieving children members, 128
unary operators, 218-222
parentheses [()]
enclosing tuples, 68
simple tuples and, 69
PartialSum function
COM UDF version, 323-324
stored procedure version, 327-328
Partition Processing Destination Editor (Integration Services), 583-585, 586
Partition Processing transform (Integration Services), 579, 580, 583-587
Partition Properties page
enabling proactive caching, 644
real-time ROLAP option, 656
Partition Source dialog, 303
Partition Wizard
for creating new partitions, 382-384
for local partitions, 304-305
for remote partitions, 310-312
PartitionProcessing package (Integration Services), 576-579
partitions
administrator privileges needed for building, 302
aggregations and, 432
applying aggregation design to, 456-458
benefits of creating, 432
building aggregations for, 314-316
cell writeback and, 356, 358
creating, 382-384
data duplication and, 304
increasing numbers of, 384
incremental processing for, 442
joining the server role, 302-303
loading data using Integration Services, 579-587
local, 303-305
merging, 384-386, 432-434
need for, 301-302
optimizing, 430, 431-437
overview, 57
parallel processing and, 432
performance and, 430, 431-437, 439-440
proactive caching setup for, 642-647
processing database objects and, 375, 431-437, 439-440
refreshing data and, 432
remote, 305-312
Slice property, 435-437
storage modes and settings, 312-314, 431-432
storage modes and storage settings, 315
by time, 431-432, 433
performance. See also performance optimization
aggregations and, 10
average query response under load, 422-423
defined, 421
importance of, 421
normalization and, 4-5
SQL Profiler for analyzing, 476-480
storage modes and, 438, 447, 638
typical scalability graph for server, 421-422
UDM and, 17
using BIDS for updating dimension data and, 353
XML/A and, 15
performance optimization. See also performance
aggregations and, 441, 448-469
Analysis Services and SQL Server installation for, 440-441
avoiding unnecessary attributes, 425
cube tuning, 430-437
data types and, 440
defining hierarchy relationships between attributes, 427-430
dimension tuning, 424-430
disabling attributes for member properties, 426-427
graphs illustrating, 421-423
identifying resource bottlenecks, 446-447
importance of, 421
key attribute choice, 424-425
main areas for, 423
overview, 480
parallel processing and, 432, 443-446, 447
partitions and, 430, 431-437, 439-440
for processing, 437-447
for queries, 447-472
rarely used attributes and, 425-426
relational data sources and, 441
for scalability, 473-475
UDM design optimization, 424-437
PeriodsToDate function (MDX), 768
permissions. See access permissions
perspectives
browsing in cubes, 176-178
creating for cubes, 173-175
defined, 144, 174
PipelineDataLoad package (Integration Services), 579-587
Pivot Table and Pivot Chart Wizard (Excel), 522-523, 526
Pivot Table Options page (Excel), 542-544
pivot tables (Excel)
analyzing data using, 528-536
automatic grouping of members in, 535
creating against Analysis Services data, 522-528
creating local cubes from, 547-550
creating OWC pivot tables from, 550-554
creating Pivot chart reports, 544-546
custom grouping within, 540-542
dimension hierarchies not distinguishable in, 528
dragging and dropping items for, 528-529, 534-535, 540
drilling down to detailed data, 536-539
end users and, 521
formatting Pivot table reports, 542-544
hierarchies in, 527-528
integration with Analysis Services, 522
MDX queries sent by, 529-533, 535-536, 538-539
overview, 522
Pivot Table Field List, 526-527
Pivot Table window for, 526-527
restricting data analysis using, 532-534
Sales data analysis examples, 529-536
tick marks in, 537-538
viewing multiple measures with, 539-540
pivot tables (OWC)
behavioral options, 554, 556
creating from an existing pivot table, 550-554
displaying the top N members of a hierarchy, 552, 553
dragging and dropping measures and dimensions in, 552
enabling ActiveX controls for, 551-552
hiding levels of a hierarchy, 552, 554
including within a web page, 554-556
overview, 550
plus sign (+)
as arithmetic operator, 79
as set operator, 79
as unary operator, 218, 219, 222
polling query technique for proactive caching, 648-649
porting COM UDFs to .NET, 338
Precedence Constraint Editor (Integration Services), 572, 573
precedence of calculations, 222
Predict function (MDX), 769
preserving hierarchy when sorting
set containing multiple dimensions, 764-765
set containing one dimension, 763-764
previewing reports, 603-604, 617, 622-623
.PrevMember function (MDX), 769, 770
primary keys
defined, 8
specifying in the DSV, 97-98, 99
proactive caching
average latency scenario, 651-655
as background thread, 642
defined, 638
enabling, 644-646
latency, defined, 642, 651
long latency scenario, 647-650
MOLAP storage mode for, 638-642, 644-645, 648, 651-655
no latency scenario, 655-657
overview, 638-642
polling query technique for, 648-649
real-time ROLAP storage mode for, 655-656
setting for a partition, 642-647
SilenceInterval property, 651-654
SilenceOverrideInterval property, 651-654
storage modes and, 638
timed updates with, 649-650
ProactiveCaching property, 165
Process command, 372, 373
Process dialog
for cubes, 375-377
for database objects, 372
for dimensions, 380-381
options available based on launch location, 371
Process Data option, 376, 377, 381
Process Default option, 376, 377, 381
Process Full option, 372, 375-376, 377, 381
Process Incremental option, 376, 377, 442
Process Index option, 376, 377, 381
Process Script Cache option, 376, 377
Process Structure option, 376, 377
Process Update option, 381
ProcessAdd option, 442-443
restricting parallelism, 444-446
starting, 371
Unprocess option, 376, 377
ProcessASObjects namespace, 406
ProcessCube method, 408-409
ProcessDimension method, 408
processing cubes. See also processing database objects
AMO for, 403-409
error handling options, 377-379
hierarchy structure for processed data, 377
measure groups and partitions and, 375
Process Data option, 376, 377
Process Default option, 376, 377
Process Full option, 375-376, 377
Process Incremental option, 376, 377
Process Index option, 376, 377
Process Script Cache option, 376, 377
Process Structure option, 376, 377
Unprocess option, 376, 377
processing database objects. See also processing cubes; processing dimensions
AMO for, 403-409
AnalysisServicesTutorial2005 database, 371-375
commit and, 374-375
creating partitions to speed up, 439-440
dependencies and, 374
identifying resource bottlenecks, 446-447
incremental processing, 442-443
Integration Services for, 576-579
lock chains and, 438-439
optimizing for, 437-447
options for, 372, 375-377
overview, 437-439
parallel processing, 432, 443-446
processing dimensions. See also processing database objects
AMO for, 403-409
order of processing, 381
overview, 379-380
Process Data option, 381
Process Default option, 381
Process Full option, 381
Process Incremental option, 442
Process Index option, 381
Process Update option, 381
ProcessAdd option, 442-443
time required for, 381
Processing server property, 474
ProcessObject method, 406
Proclarity client tools, 564
Professional SQL Server 2005 Integration Services (Knight), 586
projects
creating Analysis Services projects, 32-33
creating Integration Services projects, 566
deploying, 50-52, 152
naming after databases, 399
report model, 629
for reports, 597
properties. See also specific properties
of attributes, 130, 132-133, 426
of calculated measures, 172
changing Analysis Services properties, 369-370
of columns, 103-104
controlling attributes and aggregation design, 467-469
of cube dimensions, 258
of cubes, 165-166
customizing dimensions using, 225-230
data source connection properties, 92
extended, for reports, 619-620
of KPIs, 277-278
of measures, 254-256
member property approach to dimension security, 677-679
ordering dimension members, 224
Properties pane (BIDS), 34, 103-105
of Report actions, 287
server configuration properties, 473-475
sort order for, 130-132
specifying attribute member properties, 122-123
of tables, 105
Properties function (MDX), 128
.Properties function (MDX), 769
Properties pane (BIDS), 34, 103-105
Properties tab of reports, 625-627
.PropertyName function (MDX), 770
Proprietary actions, 281
Publish as Web Page screen (Excel), 550-551
PUMP component, 414-415