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