O


Object Explorer window, 87–88, 89, 116

objects

linking to cubes, 338–340

managing UDM, 60

OLAP (Online Analytical Processing) systems. See also cubes

about, 44–45

cube structures in, 45–48

data representations in OLTP vs., 49–50

disadvantages of, 52–53

hybrid, 52

multidimensional, 51–52

multidimensional databases in, 48

preprocessed aggregates in, 48–49

relational, 50–51

UDM vs., 53–54

OLAP cubes. See cubes

OLE DB

connections required for UDM, 98, 99

executing SQL statement for each row in data flow, 223–224, 226

sending data flow to database compliant with, 242

using source supporting, 200–202

OLE DB Command transformation, 223–224, 226

OLTP (Online Transaction Processing) systems

about, 27, 44

analyzing available data in, 101

archiving data, 28–29

data representations in OLAP vs., 49–50

limitations of, 28

situations requiring data marts, 97–99

using for business intelligence, 27–29

Online Analytical Processing systems. See OLAP systems

Online Transaction Processing systems. See OLTP systems

opening

Business Intelligence Development Studio windows from View menu, 70–71

solution in Business Intelligence Development Studio, 63–64

OpeningPeriod() function, 453

OPENQUERY() function, 548, 549

operators

MDX, 448–450

Excel range, 387–388, 389

supported by expressions, 248–249

opportunities of business intelligence, 745–746

Options dialog box, 79–82

MDI environment option, 79–80

customizing default file locations, 82

customizing fonts and colors, 80, 81–82

illustrated, 80

Projects and Solutions options, 82

ORDER BY clause, 547

order processing for Maximum Miniatures, 22

organizational pyramid, 16–19

Output window, 72–73




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