Q


qualified identifiers, 247

queries. See also DMX queries; MDX queries; singleton queries

creating for data mining models, 534–544

defining with Query Designer, 558

DMX, 180, 181, 599–600

enabling SQL Notification for named, 364–365

executing DDL, 178

executing in SQL Server Management Studio, 88, 90–91

executing WMI, 191–192

managing with AdomdCommand, 675

MDX report, 590, 591

named, 356–357, 358

OLE DB, 201–202

pivot tables and charts use of MDX, 719

providing calculated members without exposing underlying data, 413

specifying calculations producing nonempty results, 299

types of prediction, 547–550

WMI, 191–192

Query Builder

entering queries in, 571–573

illustrated, 201

stored procedure version of, 613, 614

Query Designer, 558

query dimensions

for MDX SELECT statements, 426–430

AXIS(n), 446–447

CHAPTERS, 445–446

COLUMNS, 427–428, 430, 445–446

errors using too many, 447

PAGES, 445–446

ROWS, 445–446

SECTIONS, 445–446

using two, 428–430

Query window

executing queries in, 88, 90–91

opening MDX, 423–424

saving entries in SQL Server Management Studio, 424




Delivering Business Intelligence with Microsoft SQL Server 2005
Delivering Business Intelligence with Microsoft SQL Server 2005: Utilize Microsofts Data Warehousing, Mining & Reporting Tools to Provide Critical Intelligence to A
ISBN: 0072260904
EAN: 2147483647
Year: 2007
Pages: 112
Authors: Brian Larson

Similar book on Amazon

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