O

Object Explorer window in SQL Server Management Studio, features of, 27–29

object ownership, managing, 16

ODL (Object Definition Language)

enhancements in Analysis Services, 235

relationship to Analysis Services, 221

OLAP (online analytical processing)

relationship to BI, 216

using PIVOT and UNPIVOT relational operators with, 92

OLAP Report Designer

Dimensions pane in, 169–170

Measures pane in, 170

Metadata window in, 169

overview of, 168–169

OLAP storage types, overview of, 217–218

OLE DB, using with Integration Services, 208–209

ON QUEUE clause, using with SQL Server Service Broker application, 135

on-demand report delivery, implementing with Report Server, 171

online and offline modes, using with Business Intelligence Development Studio, 226

online index operations, support for, 12, 59–60

OPENXML, enhancements in, 154–155

optimistic locking, performing, 61

OrderSum table

removing rows from, 94

using PIVOT operator with, 92

orphaned fact table row support, availability in Analysis Services, 221

osql utility, replacement of, 38

OUTPUT DELETED.* clause, explanation of, 94

Output window in Report Designer, features of, 168

OWC (Office Web Component), relationship to Cube Browser, 232