R


Rabeler, Carl (Microsoft SQL Server 2000 Analysis Services Operations Guide), 439

ragged hierarchies, 9

Rank function (MDX), 76, 771-772

ranking

Adventure Works examples, 203-205

Rank function for, 76, 771-772

RDL (Report Definition Language), 596, 603

read DB commit lock, performance and, 438-439

Real Time OLAP connection string property, 657

real-time cubes

average latency scenario, 651-655

defined, 637

long latency scenario, 647-650

multi-national companies and, 637-638

no latency scenario, 655-657

proactive caching overview, 638-642

proactive caching setup, 642-647

uses for, 637-638

recursive calculations, 196

RECURSIVE flag (MDX), 539

Reeves, Laura (The Data Warehouse Lifecycle), 13

reference dimensions

browsing, 162-163

optimizing, 431

reference relationships

browsing reference dimensions, 162-163

defined, 158

establishing, 158-161

referential integrity, 6, 227-228

refreshing data, partitions and, 432

Register Database Assembly dialog

for COM UDFs, 325

debug options, 332

impersonation mode options, 333-334, 387-388

permission set options, 333, 386

for stored procedures, 332-334, 386-388

Registered Servers in SSMS window, 54-55

regression data mining algorithms, 488, 490

relational databases. See also databases

creating a report model from, 629

creating reports on, 597-604

multi-dimensional databases versus, 4, 11

optimizing data sources, 441

relational mining model

analyzing the accuracy of, 500-504

clustering model, 507-512

creating, 491-500

Data Mining Wizard for, 492-496

Discretized content in, 498

DMX queries with, 506-507

multiple models in same structure, 507, 512

predicting values using, 504-507

for targeted mailing type problem, 491-500

Relational OLAP storage mode. See ROLAP storage mode

relationships

aggregation design and, 465-466

between cube dimensions and measure groups, 156-158

data mining, 262-263

between dimensions and measure groups, 259-263

between fact and dimension members, 158

fact relationships, 259-260

between fact tables and measure groups, 164

hierarchy, defining between attributes, 427-430

many-to-many dimensions, 260-262

many-to-one relationships between attributes, 427

names, 105

one-to-many relationships between attributes, 121, 122, 427

outward-facing, 116

reference relationships, 158-161

specifying in the DSV, 97, 98

remote partition. See also partitions

aggregations for, 314-316

building, 310-312

deleting an existing partition, 309-310

Master computer configuration, 306-307

overview, 306

security, 310-311

subordinate computer configuration, 307-309

two computers best for implementing, 306

removing. See deleting or removing

Report actions

properties, 287

reviewing, 288-289

target types, 282

URL string generated by, 288

Report Builder

ad-hoc reports using, 632-635

overview, 629

report model for, 629-632

Report Definition Language (RDL), 596, 603

Report Designer

creating a report on a relational database, 597-604

designing reports based on a UDM, 605-610

overview, 596

RDL created in, 596

Report Wizard, 597

report model

creating from databases, 629

creating from UDM, 630-632

defined, 629

project for, 629

Report Server

credentials for, 625, 626, 627

deploying reports, 623-624

overview, 597

report execution settings, 625-626

report model for, 629-632

web interface to, 623

Report Wizard

for Analysis Services Report, 605-610

for relational database report, 598-603

Reporting Services. See also Analysis Services Report

ad-hoc reports using Report Builder, 629-635

automating report delivery, 628-629

creating a report on a relational database, 597-604

creating reports based on a UDM, 604-624

custom aggregates for reports, 620-623

deploying reports, 623-624

email delivery of reports, 629

extended properties, 619-620

formatting reports, 617-619

integration with Analysis Services 2005, 605

managing reports, 625-629

MDX query builder, 607-608

new features and extended capabilities, 604-605

previewing reports, 603-604, 617, 622-623

Report Definition Language (RDL), 596, 603

Report Designer, 596-597

report execution settings, 625-626

report projects, 597

Report Server, 597

Report Wizard, 597

security settings, 625-628

subscriptions for reports, 629

reports (Excel)

creating Pivot chart reports, 544-546

formatting Pivot table reports, 542-544

Reports folder, 598

RequireClientAuthentication feature, 398

resource bottlenecks, identifying, 446-447

restarting Analysis Services, 368

Restore Database dialog, 390-391, 663-664

restoring databases. See also backup

AMO for, 410-411

SSMS for, 390-391

restricting the cube space

CREATE SUBCUBE statement for, 197-198

EXISTING keyword for, 199-200

EXISTS function for, 198-199

SCOPE statement for, 190-191, 197

SUB-SELECT clause for, 200-201

retail profits, increasing using data mining, 487

rigid aggregations, 466

ROLAP (Relational OLAP) storage mode

Analysis Services support for, 438

cell writeback and, 358, 360

dimension data retrieval and, 228

optimizing partitions, 435-437

overview, 15

partitions and, 312-313, 431

performance and, 438, 447, 638

proactive caching and, 638, 639-641, 655-656

role-playing dimensions, 264

roles. See also access permissions; dimension security

creating with role designer, 667-670

defined, 34

objects, 57

overview, 663

for report users, 627

server and database, 397-398

Visual Totals and, 672

Roles designer

for access permissions for cubes and dimensions, 316-319

Cubes tab, 318, 668

Data Sources tab, 317

Dimension Data tab, Advanced, 669-670

Dimension Data tab, Basic, 669, 670

Dimensions tab, 318-319, 668-669

General tab, 316-317, 667

Membership tab, 317, 667-668

opening, 316

Roles dialog, 397-398

Roles folder, 34

RollupChildren function (MDX), 772-773

Root function (MDX), 208, 773-774

Ross, Margy (The Data Warehouse Lifecycle), 13

Rowset actions, 281

running. See starting



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