table cells. See cells
table data region
creating in Report Wizard, 574, 577
in Report Designer, 569
Table Properties dialog box, 587, 588
Data Output tab, 588
Filters tab, 587
General tab, 581, 582
Groups tab, 582, 584
Navigation tab, 582, 583
Sorting tab, 582, 584
Visibility tab, 581, 583, 585
table reports
about, 668
creating with Report Model, 658–660
tables. See also dimension tables; fact tables; pivot tables
about cells in, 580–581
correcting errors in, 119
inserting records from data flow in SQL Server, 242–243
MaxMinManufacturingDM, 120–121, 127–128
saving for data mart database, 542
self-referential fields and parent-child dimension, 313
Tables and Columns dialog box, 124, 125
Task List window, 71–72
templates for cube, 132
Term Extraction transformation, 236–238
Term Lookup transformation, 238, 239
Test button (New Server Registration dialog box), 86
text
extracting terms in freeform text columns, 236–238
formatting report, 606–607
fuzzy grouping for characters, 214
looking up words or phrases in data flow column, 238, 239
text files
inserting data from text file to table or view, 179, 180
sending data flow to, 241–242
using CSV text files in data mart, 274
working with data in, 197–200
Textbox Properties dialog box, 575, 576, 578
3-D columns for pivot charts, 742, 743–744
3-D Effect tab (Chart Properties dialog box), 621, 624
TIFF file printing, 638
time
defining periods for dimensions and hierarchies, 133
distinguishing year's quarters and months, 384
populating time dimension, 136
time-related dimensions, 113
Toolbox window, 69–70
tools for Visual Studio, 63
TOPCOUNT function in MDX SELECT statements, 441–444
topographic mapping, 458–462
transactional data, 27
Transact-SQL. See T-SQL
Transfer Database task, 190
Transfer Error Messages task, 190
Transfer Jobs task, 190
Transfer Logins task, 190
Transfer Master Stored Procedures task, 190
Transfer SQL Server Objects task, 190
translations
about, 371–372
creating, 372–373
Translations tab
about, 371
illustrated, 372
T-SQL
expressions, 289–290
SELECT statements, 423
transactions created with Integration Services package, 256–259
tuples
creating with basic MDX SELECT statements, 425–426
default dimension members in, 383–385
defined, 378
identifying Current Cell with, 397
locating cells in, 379–380
slicer dimension, 432, 433
Type 1 SCD, 315–316
Type 2 SCD, 316–318
Type 3 SCD, 318–319