P


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



Professional SQL Server Analysis Services 2005 with MDX
Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)
ISBN: 0764579185
EAN: 2147483647
Year: 2004
Pages: 176

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