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