T


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




Delivering Business Intelligence with Microsoft SQL Server 2005
Delivering Business Intelligence with Microsoft SQL Server 2005: Utilize Microsofts Data Warehousing, Mining & Reporting Tools to Provide Critical Intelligence to A
ISBN: 0072260904
EAN: 2147483647
Year: 2007
Pages: 112
Authors: Brian Larson

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net