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