 INDEX
451
cube with dimensions and, 29
CurrentMember function, 235, 245
custom member formulas, BI, 256
date dimension, 29
default members, 226
DefaultMember property, 156
Dimension Data tab, roles, 352
finding previous or next member, 236
leaf members, 221
MDX notation, 222
parent members, 221
PrevMember function, 245
RootMemberIf property, 158
selecting from dimensions, 221
selecting members of dimensions on cube,
30, 31
tuples, MDX, 224
using member key to select member, 222
using member names for annotations, 222
Members function, 234
Membership tab, roles, 350
MembersWithData property, 157
MembersWithDataCaption property, 158
metadata
attributes, dimensions, 21
cube and measure group metadata locations,
55
Metadata tab, Cube Designer, 262
Calculations page, 187

ProcessingMode, 140
specifying storage modes, 142–148
StorageMode property, 141
MOLAP (multidimensional OLAP), 39, 54
data sources, SSAS, 61
scheduling OLAP maintenance, 215
storage, dimensions, 141
using partitions, 356
MOSS (Microsoft Office SharePoint Server) 2007,
420–423
dashboard, 420, 421
Excel Services, 421, 423
InfoPath Forms Server, 420
KPI lists, 420, 421–423
moving averages calculation, 253
MSAS 2008: Xyz counter groups, 338
msmdsrv.exe, 52
changing Config.ini file location, 54
multidimensional analysis
history of OLAP, 7
multidimensional data, 3
multidimensional expressions see MDX
multidimensional OLAP see MOLAP
multisnowflake schema, 120
 N
Naïve Bayes algorithm, 276
Naïve Bayes mining model
Accessory Buyers campaign, 305
named calculations
creating, 110–112

Client Initiated option, 142
Scheduled Polling option, 142
SQL Server option, 141
Notifications tab, storage options
specifying dimension storage modes, 145
 O
Object Details pane, 214
Object Explorer pane, 214
scheduling OLAP maintenance, 217
Object list
Impact Analysis dialog, 211
Process dialog, 209
object model, SSAS, 51
OLAP (Online analytical processing)
actions, 34–35, 265–270
aggregation, types of, 31–32
AMO design warnings, 135
applications of, 5–7
axes, 233
configuring storage for, 38–39
cubes, 15–18
data source connections to Excel, 374–378
dimension table, 18
dimensions, 20–27
fact table, 18
history of, 7–8
hybrid OLAP (HOLAP), 39–54
introduction to, 1
MDX, 36–37
measure groups, 184

OLAP Services
history of OLAP, 8
one-to-many relationships
attribute relationships, dimensions, 151
Currency dimension, 140
relationship types, 180
Online analytical processing see OLAP
operators
unary operators, BI, 255–256
options
processing, Analysis Services, 335–336
Options tab
pivot tables, Excel 2007, 381, 391
OrderBy property, 156
OrderByAttribute property, 156
ordering
attribute ordering, BI, 257
Organization dimension, 137
Output Path property, 197
 INDEX
453
 P
panes, BIDS, 76–79
Properties pane, 80–82
Solution Explorer, 79–80
tearing off, 78
UI for docking panes, 78
Parallel processing, Change Settings dialog, 335
ParallelPeriod function, MDX, 247, 248
trend indicators, KPIs, 264

performance management, SSAS, 352–371
aggregations, 359–367
design, 352–359
scalability, 367–369
SharePoint Server 2010, 369–371
virtualization, 369
Performance Monitor, 337–339
PerformancePoint, 373
PerformancePoint Server (PPS), 423–429
building scorecard in, 425–429
Dashboard Designer, 424, 425
scorecard, 423, 424
period to date calculation, 252
periodic growth calculation, 253
PeriodsToDate function, MDX, 247, 248
persp folder, 57
Perspective collection, SSAS, 51
Perspective Designer, 270, 271
perspectives, 251, 270–272
choosing Standard/Enterprise SSAS, 46
folders for, 57
physical architecture, SSAS, 52–54
changing INI file location, 54
pivot charts, 374, 386–398
adding product categories to, 392
Analyze tab, 388
applying color bar conditional formatting,
397
creating, 387
Design tab, 388

renaming, 381
 INDEX
454
pivot tables (cont.)
setting options, 317
using Excel writeback, 315–319
using MDX to produce, 232
with multiple slicers, 325
PivotTable design ribbon, 382
PivotTable options ribbon, 381
PivotTable Style Options section, 382
PivotTable Styles gallery, 382
polling
Scheduled Polling option, notifications,
142
PowerPivot, 311
connecting with SSMS, 330, 331
entity relationship designer, 323
Excel add-in, 320
Excel writeback, 313–320
from Excel, 320–326
importing tables from SQL Server, 322, 323
Master Data Services, 311–313
pivot table in Excel, 323, 324
pivot table with multiple slicers, 325
support in SQL Server 2008 R2, 311–320
with SharePoint Server 2010, 326–331
PowerPivot Designer, 321, 322
creating relationships, 323
PowerPivot for SharePoint see VertiPaq mode

dimensions, 141, 144
measure groups, 185
Process affected objects option
Change Settings dialog, 336
Process checkbox, roles, 351
Process Clear Structure option
Process Cube dialog, 335
Process Cube dialog
AdventureWorks cube, 333–334
Change Settings button, 335
Process Options drop-down list, 334
Process Data option
Process Cube dialog, 210, 335
Process Default option
Process Cube dialog, 210, 334
Process dialog
BIDS, 208, 209
SSMS, 214
Process Dimension window
creating dimensions, 131
specifying dimension storage modes, 147
Process Full option
Process Cube dialog, 210, 334
Process Incremental option
Process Cube dialog, 334
Process Index option
Process Cube dialog, 210, 334
Process method
processing Analysis Services objects from
AMO, 215

ProcessingMode property
dimensions, 140
measure groups, 185
ProcessingPriority, dimensions, 140
ProClarity, 373, 401
Product dimension, 137
Product Key attribute, 154
Profiler trace, Analysis Services, 337
Profiler, SQL Server, 337
Program Menu Shortcuts option
Adventure Works, 432
project properties see properties, project
project properties dialog, 196, 197
projects
creating, Analysis Services, 82–84
deploying, 195–198
importing database into, 86
New Project dialog, 83, 84
setting up Adventure Works, 431–434
Promotion dimension, 137
specifying storage modes, 142
properties
see also dimension properties
attribute properties, 156
Specify Configuration Properties screen, 200,
201
Properties dialog
Configuration Manager button, 196
Properties pane, 80–82
attribute properties, 156

QueryLogTableName property, 366
 R
RAID
hardware requirements, SSAS, 42
random line, Lift Chart tab
Mining Accuracy Chart view, 298
Rates dimension, 137
recursive data structures, 157
referenced/regular relationships
associating dimensions with measures, 63
relationship types, 180
Related Tables page, 152
relational data models, 97
relational databases, cubes and, 18
relational OLAP see ROLAP
relationship types, 180–181
relationships
associating dimensions with measures, 63
attribute relationships, dimensions, 150–156
creating, PowerPivot Designer, 323
dimensions and measures, 324
flexible relationships, attributes, 151
relating measures and dimensions, 179–181
rigid relationships, attributes, 151