L

Lag function, 398

LastChild function, 399, 400

LastSibling function, 399, 400

latency

business intelligence and, 18, 19

data marts and, 31

disadvantage in OLAP systems, 53

UDM's low, 59

launching Report Builder, 666–668

layout

adjusting matrix report, 589–591, 592, 593–595

Integration Services package design, 143–144

pivot table, 719, 725–727

rectangles and borders in report, 601

SQL Server Management Studio default window, 83–85

Layout tab (Report Properties dialog box), 606

layout-led discovery, 14–15

Lead function, 398, 399

Learn By Doing exercises, 109, 131

Legend tab (Chart Properties dialog box), 621, 623

Level function, 451

Lift Chart

about, 520, 525

illustrated, 528, 529, 530, 531

prediction value unspecified, 526–527

specified prediction value, 527–529

Linked Object Wizard, 339–340

linked reports in Report Server, 648, 649

linking objects to cubes, 338–340

list data regions, 597–598

list reports, 598–611

adjusting page size of, 605–607

editing field expressions in, 601–602

embedding images in, 602–604

list data regions and, 597–598

page numbers for, 607–608

rectangles and borders in, 601

setting text properties for, 606–607

literals in Integrated Services, 246–247

Load InventoryFact data flow task, 285, 286

LoadDimBatch data flow task, 278–281

local administrator privileges, 640–641

local reports, 710–716

defining data source for, 711–715

setting up new report link, 711

logging for Integrated Services packages, 254–256

Logical function, 451

logical operators in MDX, 449

long-term goals, 16, 17

Lookup transformation, 220–222

low-latency MOLAP data storage, 362