K

key attribute in dimensions

defined, 121

optimization and, 424-425, 427-429

Key Success Indicators (KSIs). See KPIs (Key Performance Indicators)

KeyColumns property, 130

Kimball, Ralph

The Data Warehouse Lifecycle, 13

The Data Warehouse Toolkit, 135

data warehousing approach of, 12-13

Knight, Brian (Professional SQL Server 2005 Integration Services), 586

KPICurrentTimeMember function (MDX), 207, 746

KPIGoal function (MDX), 207, 274, 747

KPIs (Key Performance Indicators)

creating, 273-276

hidden calculated members for metrics, 278

hierarchical display of, 276

as Key Success Indicators (KSIs), 272

overview, 272

predefined data roles, 272

properties, 277-278

querying using ADOMD.NET, 279-280

viewing, 276-277

KPIStatus function (MDX), 207, 747

KPITrend function (MDX), 207, 747

KPIValue function (MDX), 207, 274-275, 747

KPIWeight function (MDX), 207, 747

KSIs (Key Success Indicators). See KPIs (Key Performance Indicators)