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)



Professional SQL Server Analysis Services 2005 with MDX
Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)
ISBN: 0764579185
EAN: 2147483647
Year: 2004
Pages: 176

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net