I

IF statement (MDX), 193-194

.Ignore function (MDX), 740

IgnoreUnrelatedDimensions property, 253-254

Iif function (MDX)

cube security expressions using, 687-688, 689-690

overview, 740-741

Imhoff, Claudia (Corporate Information Factory), 13

impersonation mode options for assemblies, 333-334, 387-388

Import Analysis Services 8.0 project template, 399-400

Import Package dialog (Integration Services), 588

incremental allocation for cell writeback, 363-364

incremental processing, 442-443

indices

rarely used attributes and, 425-426

ROLAP partitions and, 441

infinite recursion, 196

Inmon, Bill

Building the Data Warehouse, 3-4

Corporate Information Factory, 13

data warehouses defined by, 3-4

data warehousing approach of, 12-13

Insert Web Component dialog (Front Page), 555

in-session (what-if) scenarios. See cell writeback

installing

Analysis Services and SQL Server, performance and, 440-441

selecting Adventure Works sample project during, 62

Upgrade Advisor, 24

integration of data warehouses, 4

Integration Services

Analysis Services Processing task, 576-579

ASBackup package, 567-576

automating packages, 587-591

Bulk Insert task, 566

control flow elements, 565-566

creating a project, 566

data flow components, 565, 566

Data Flow task, 566, 579-587

Data Flow Transformations, 566, 579, 580

data mining tasks, 587

debugging, 574-576

Execute DDL task, 567-576

Flat File Source transform, 579-582

loading data into a partition, 579-587

overview, 565-566

Partition Processing transform, 579, 580, 583-587

PartitionProcessing package, 576-579

PipelineDataLoad package, 579-587

processing an Analysis Services object, 576-579

required properties for, 568

Script task, 579

Send Mail task, 566, 572-574

solution explorer window, 567-568

tasks available, 566

toolbox window, 568

uses for, 565

intelligence. See business intelligence

intermediate dimensions, 260-261

Internet Explorer, OWC pivot tables in, 551, 552-553

Internet resources

client tools, 564

CreateWriteBackExampleTables.sql script, 342

on data mining, 484

Microsoft SQL Server 2000 Analysis Services Operations Guide, 439

OLAP Report, 447

Panorama Software, 595

Intersect function (MDX), 741-742

An Introduction to Database Systems (Date), 135

Invocation property, 285

IS operator (MDX), 80, 742-743

IsAggregatable property, 226

IsAncestor function (MDX), 743

IsEmpty function (MDX), 743

IsGeneration function (MDX), 743-744

IsLeaf function (MDX), 744

IsSibling function (MDX), 745

.Item functions (MDX), 745-746