Index_O

---

O

object IDs, 158–160

object-level security, 291–293

object restrictions, 303, 304–305

objectives, marketing plan, 53

object.lov query, 183–184, 186

objects

Audit universe, 398–399

building intelligence in universe, 337

creating, 107

deleting, 163–164

details or attributes, 172–173

dimensions, 165–172

external strategies, 101, 102–106

formats, 178

function of, 150

hiding, 164–165

inserting measures, 173–175

integrity checks, 373, 377

linked universes and, 348

multiple data providers and, 616–617

naming conventions, 157–160

ordering, 155–157

printing to document universe, 379

projection aggregates, 175–177

prompts in reports vs., 219–220

quality assurance checklist, 382

Quick Design Wizard and, 89–91

renaming, 161–163

sort order in linked universes, 354

types, 151–155, 167–169, 217

universe design and, 74

Universe pane showing, 150–151

user-defined, 633–634

objects, advanced

base objects and @Select function, 206

building intelligence in universe, 337

cautions using SQL, 208–209

condition objects, 209–215

HTML links, 232–235

interactive objects, 215–220

quality assurance checklist, 383

SQL Editor, 206–208

SQL functions. See SQL functions

time conditions, 214–215

Objects tab, Universe Parameters, 304

ODBC, ColSort parameter, 156

offline login, 291

offline mode, 84–85, 412–413

OLAP (On Line Analytical Processing), 599–609, 680–689

as data provider, 582

defining source information for UDS Map, 267

drill through, 327, 687–689

filtering by members and values, 684–686

Hyperion Essbase as data source, 604–609

Microsoft Analysis Services as data source, 599–604

overview of, 15–16, 680–684

Rank, 686–689

OLAP Panel

Hyperion Essbase, 605–608

Microsoft Analysis Services, 601

OLAP@Work, 21, 327

OLTP (On-Line Transaction Processing)

BusinessObjects against, 28–29

Data Integrator and, 15

using indexed fields in, 189

On Line Analytical Processing. See OLAP (On Line Analytical Processing)

On-Line Transaction Processing. See OLTP (On-Line Transaction Processing)

online mode, vs. offline mode, 412–413

operands, 593–594

operators

allowing use of SQL, 109

BOTH and EXCEPT, 626

concatenating fields with, 237

contexts, 524

join, 120

nested conditions and OR, 621–623

query creation, 591–593

Query Filters, 714

SQL vs. Query Panel, 592–593

UNION, INTERSECT and MINUS, 623–626

optimizers

order of joins and tables using, 119

row count information and, 117

OR operator, 621–623

Oracle

ColSort parameter, 156

concatenation operator, 237

ManagerO and, 385

syntax for outer joins, 123

Oracle Discoverer, 15, 16

Oracle Express

BI market and, 15

competing with Business Objects, 19

OLAP and, 16

Oracle Warehouse Builder, 15

order, object, 155–157

Orientation/Across option, tables, 468

outer joins, 121–124

Outline view, master/detail reports, 509–510

output contexts, 524

Owens & Minor

charges to customers, 59

industry journals promoting, 62

measuring success, 35–36

OWNER=N strategy, 102

---