I

identifiers in Integrated Services, 247–248

IIF() function, 452

IIS (Internet Information Services)

creating cached web page in, 55–57

group membership changes unrecognized, 648

hosting Reporting Services web services, 563, 564

server location for Reporting Services installations, 566, 567, 568

image format parameters, 697–698

Image Wizard

Choose the Embedded Image page, 604

Select the Image Source page, 603

Import Column transformation, 220

Import/Export Wizard, 252–254

importing data into data marts, 98–99

indexes

match, 218

rebuilding database, 168–169

reorganizing database, 169, 170

infrastructure breakdowns, 10–11

inherited role assignments, 647

InitExpression property, 171–172

input columns, 485

Installation Target page (Analysis Services Deployment Wizard), 330, 332

installing

Integration Services packages, 267–268

Report Designer, 565–568

Integration Services. See also data flow transformations; Maintenance Plan tasks

about, 142

checkpoints, 259–260

configuring deployable packages, 265–267

Control Flow items, 171–194

creating package deployment utility, 267

data flow destinations, 240–245

data flow sources for, 194–202

defining data flows, 154–155

drag-and-drop development with, 147–148

event handlers, 251–252, 253

executing packages, 268

expressions in, 245

functions supported by expressions, 249–251

identifiers, 247–248

Import/Export Wizard, 252–254

installing packages, 267–268

literals, 246–247

logging for packages, 254–256

maintenance tasks for, 162–171

migrating DTS packages from SQL Server 2000, 264–265

operators, 248–249

package debugging, 260–263

package design layout in, 143–144

package structure for, 142–147

populating data mart dimensions, 155–162

populating data mart fact tables, 277–286

programming variables in, 243–245

transactions in packages, 256–259

viewing data flow, 262–263

Internet Information Services. See IIS

Inventory Fact measure group, 304

Inventory Levels By Month report

completed report, 625

layout, 617

preview, 618

with subreport, 626, 627

InventoryFact table, 276–277

IsAncestor() function, 451

IsEmptyO function, 451

IsGeneration() function, 451–452

IsLeaf() function, 452

IsSibling() function, 452

Item(n) function, 453

Itemsets viewer, 514, 516