|
|
cached report expiration, 650
caching. See also report caching
enabling report, 651
IIS web page, 55–56, 57
proactive, 55–59
report, 648–652
UDM proactive, 55, 56–59
calculated measures
creating, 297–300, 303, 306
definitions stored in cube, 297
viewing definitions in MDX scripts, 299, 300
Calculated Member form, 298, 299
calculated members
creating temporary, 436–439
named sets vs., 437
providing without exposing underlying data, 413
Calculation Tools window, 299
Calculations tab (Cube Design tab), 298
CanGrow property for cells, 578
Cell Data page (Role Design tab), 405–406, 408
cells
about, 580–581
aggregate sets specified in MDX scripts, 385–387
CanGrow property for, 578
CellSet, 676
Current Cell identified with tuple, 397
designating ranges of, 333–334, 335
editing expressions for report detail, 578, 580
editing pivot tables labels for, 732, 734
finding position of comparison and current, 395–396
green triangle in corner of total, 596–597
identifying location of, 377–378
locating in tuples, 379–380
relative navigation of, 395–402
specifying groups in Excel, 387–388, 389
CellSet
pivot tables and viewed, 720
retrieving in Prospect Analyzer, 679–683
structure of, 676
CHAPTERS query dimension, 445–446
characters
character mapping, 206–208
fuzzy grouping for, 214
Chart Properties dialog box
Data tab, 618, 620
General tab, 619
illustrated, 619
Legend tab, 621, 623
modifying fonts with, 617
Preview tab, 622, 625
3D Effect tab, 621, 624
X Axis tab, 619, 621
Y Axis tab, 619, 621, 622
charts, 612–627. See also pivot charts
about, 611–612, 668
creating subreports for, 622–625, 627
including in body of reports, 616–618, 619
Check Database Integrity task, 163–165
CheckpointFilename property, 259
checkpoints, 259–260
CheckpointUsage property, 260
Children function, 399, 400
Choose a Data Source Type page (Data Source Configuration Wizard), 712
Choose Data Source dialog box, 722, 725
Choose the Embedded Image page (Image Wizard), 604
Choose the Table Layout page (Report Wizard), 575
Choose Your Data Connection page (Data Source Configuration Wizard), 712
Choose Your Database Objects page (Data Source Configuration Wizard), 714
classification
about, 463–464
association and segmentation with, 467
Microsoft Clustering algorithm for, 474–476
Microsoft Decision Trees algorithm for, 472–473
Microsoft Naïve Bayes algorithm for, 473–474
Microsoft Neural Network algorithm for, 480–481
Microsoft Sequence Clustering algorithm for, 477–478,517
Classification Matrix
about, 520
illustrated, 533
viewing, 532–533
clickthrough reports (Report Builder), 671
client software
actions with, 352
managing connections to with AdomdConnection, 675
support for KPIs, 346
client-side printing, 638–639
ClosingPeriod function, 453
cluster characteristics viewer, 511, 513
cluster diagram viewer, 509–510, 511
cluster discrimination viewer, 511
cluster profile viewer, 510–511, 512
Codd, E. F., 44
Collection page (Foreach Loop Editor), 175
Column Mapping tab, 520–521, 523, 525
column markers for flat files, 199
columns
adding to Browse window, 329
audit, 204–206
converting data type of, 210
copying existing, 210, 211
data mining data, 484, 485
derived, 212, 214
designating mapping for data mart population, 280,283–284
dimension table attribute, 38
exporting, 212, 215
extracting terms in freeform text, 236–238
fuzzy matching for, 215–216
importing, 220
indicating data type, 490, 491
inserting in fact table, 276
selecting data mining case level, 488, 490
specifying in Slowly Changing Dimension Wizard, 231, 233
specifying usage for data mining models, 490,491
testing mining models with predictable, 521
widening table, 574, 577
word or phrase lookup in data flow, 238, 239
COLUMNS query dimension
creating result with, 427–428, 430
slicer dimension with, 432
using, 445–446
Columns tab (Fuzzy Grouping Transformation Editor dialog box), 215–216
command parameters for URL-rendered reports, 686–687
comment operators in MDX, 448
comparison cells, 395–396
Completing the Wizard page (Report Wizard), 576
Component Properties tab (Advance Editor for DataReader Source dialog box), 195
Conditional Split transformations, 208–210
Configure Data Viewer dialog box, 263
Configure Error Output dialog box, 200, 208
Configure SSIS Logs dialog box, 254–256
Confirm Deployment page (Analysis Services Deployment Wizard), 333, 334
Connect to Server dialog box, 83
Connections tray, 143, 146
containers
defined, 171
For Loop, 171–173
Foreach Loop, 173–175
Sequence, 175–176
Content Manager role
about, 644–645
privileges required for Report Manager exercises, 628–629
Context menu
in Object Explorer window, 116
for precedence arrow, 151
control flow. See also Control Flow items
creating and editing tasks, 148–149, 150
defined, 143
defining event, 144–145
event handlers and, 251–252, 253
setting precedence among tasks, 150–154
storing tasks in connection managers, 149–150
Control Flow Designer tab
defining and specifying control flow tasks using, 148–149
dragging multiple data flow tasks onto, 278, 281,284
for FactLoad.dstx package, 287
illustrated, 143
Integration Services package structure on, 145
Control Flow items, 171–194
about, 180
ActiveX Script task, 177–178
Analysis Services Execute DDL task, 178
Analysis Services Processing task, 178, 179
Bulk Insert task, 179, 180
custom tasks, 194
Data Mining Query task, 180, 181
Execute DTS 2000 Package task, 180–182
Execute Package task, 182, 183
Execute Process task, 182, 183
Execute SQL task, 182, 184
File System task, 184–185
For Loop container, 171–173
Foreach Loop container, 173–175
FTP task, 185–186
items for transferring SQL Server objects, 190
Message Queue task, 186, 187
Script task, 186–188, 189
Send Mail task, 188–190
Sequence container, 175–176
Web Service task, 190–191
within Foreach Loop, 174–175
WMI Data Reader task, 191–192
WMI Event Watcher task, 192–193
XML task, 193–194
Control Flow Toolbox. See also Control Flow items; Maintenance Plan tasks
about, 162
areas of, 162
Control Flow items on, 171
pointer entries in, 163
Copy Column transformation, 210, 211
COUNT aggregate function, 444–445
Cousin function, 401–402
Create Directory for Solution check box (New Project dialog box), 65, 66
Create New Data Source dialog box, 722, 724
crossjoin (*) operator, 450
CROSSJOIN function
NON EMPTY, 441
using in MDX queries, 439–440
CSV report formatting, 694–695
Cube Wizard
creating cube in, 130–135
dimensions created by, 293, 294
identifying fact and dimension tables, 291–292
key attribute created by, 293
opening from Solution Explorer window, 290
previewing MaxMinSales cube in, 135
red asterisk in, 136
selecting measures in, 132
cubes
about, 34
actions added to, 349–352
aggregation design for, 366–368
building OLAP on transactional data, 59
calculated measures definition stored in, 297
creating multiple partitions from single table, 363–366
Cube Wizard for creating, 130–135
default dimension members in tuples, 383–385
defined, 46
defining on top of existing data mart, 286–294
dividing data with cube slice, 485, 494
dragging name of to Query Window SELECT statements, 425
enabling writeback for, 369–370
errors made while creating, 136, 138
executing MDX queries against, 422, 674
identifying cell locations, 377–378
illustrated, 34
KPIs added to, 346–349
linking objects to, 338–340
MaxMinSales, 135
measure groups in, 303, 304, 352–353
measures in, 294
navigational tools needed for, 376–377
perspectives for, 370–371
selecting data mining data columns, 484
setting for OLAP, 403–414
storage options for partitions, 359–363
templates for, 132
translating metadata in, 371–373
use in OLAP structures, 45–48
user-friendly names for hierarchies, 388–389, 390–394
Cubes page (Role Design tab), 405, 407
curly brackets ({ }), 386, 427
CurrentMember function, 397
Customer List with Prediction report, 601, 602, 604, 610, 611
|
|