Index_C

---

C

Calculation subquery, 628–633

level of calculation, 630

overview of, 628–629

synchronizing calculation, 630–633

calculations, 496–500

AVERAGES/MAXIMUMS, 496–500

MOLAP cubes and, 329–330

multiple, 500

Slice and Dice options, 497

universes and, 335–336

user reports and, 339

WebI and, 673–675

Calculations dialog box, 498

Candidate Context dialog, 126–127

cardinalities

Database options on Strategies tab, 107

inserting new context, 126

integrity checks, 373, 375

overview of, 120–121

CASE function, SQL, 241–244

case-sensitivity

document lists searches, 653

SQL, 208

Supervisor Passwords settings, 293

username, 290

Categories tab

Broadcast Agent, 574

WebI version 6.0, 703–704

categories, WebI, 651–652, 701–702

Cell format pull-down menu, 454–460

Alignment tab, 456–457

Appearance tab, 459–460

Border tab, 458

Font tab, 457

Number tab, 454–456

Shading tab, 459

cells

BusinessObjects reports, 424–426

formatting from pull-down menu, 454–460

formatting toolbar, 453–454

settings, 680

Centered checkbox, 116

centralized security, 287

character object type format, 167, 454

Chart AutoFormat dialog box, 472–473

Chart Format dialog box, 472

Appearance tab, 472–479

General tab, 474–475

Labels tab (Data Labels dialog box), 475–477

Pivot tab, 479

Secondary Y axis, 477–478

Series tab, 475

Chart toolbar, 470–471

charts, 438–440

compared with tables, 438

components, 471

formats, 472–479

inserting, 439–440

overview of, 438

pop-up menu, 472

settings, 680

Charts block type, 659

Check All, Integrity Check dialog box, 373, 376

Check Cardinalities, Integrity Check dialog box, 373, 375

Check For Context, Integrity Check dialog box, 374, 375–376

Check For Loops, Integrity Check dialog box, 373, 375

Check Integrity command, 372

Check Universe Structure, Integrity Check dialog box, 373, 375

classes

Audit universe, 398–399

creating from tables, 107

deleting, 163–164

function of, 150

hiding, 164–165

inserting measures, 173–175

linked universes and, 348

modifying details or attributes, 172–173

modifying dimension objects, 165–172

naming conventions, 157–160, 350

object, 151–155

projection aggregates and, 175–177

Quick Design Wizard, 89–91

renaming, 161–163

universe design and, 74

Universe pane showing, 150–151

Clear key, 163–164

client/server computing

as enabler for BI, 8–9

impact of Internet on, 11

clock settings, 300

Close button, WebI, 705

Closed Accounting Month prompt, 237–238

Codd, E. F., 16

code, adding descriptions to, 189–194

Cognos, 15, 19

color, WebI settings, 677

ColSort parameter, 155–156

column headings, 464–466

formatting, 465–466

long column names, 464–465

renaming, 158

Columns option, tables, 467–468

command restrictions, Supervisor, 311–316, 321

commas (,), @Prompt function, 217

Comments section, Universe Parameters Summary tab, 100

Common Warehouse Metamodel (CWM), 367, 368

communication specialist role, 49

Compact mode

creating documents, 667

universe display options, 648–649

viewing document lists, 651

company newsletters, 62

competition, BusinessObjects vs., 54

Complex Condition Wizard, 599–601, 628

complex conditions

adding to queries, 590–591

defined, 590

operands, 594

complex filters, 501–504

complex joins, 135–138

complex operands, 109

composite keys, 135–138

compression ratio, of aggregate tables, 220

computer-based training, 64

computer literacy, 40

Compuware QALoad, 388

CONCAT function, 234, 236

concatenation

calculations based on, 529–530

HTML commands with SQL data, 233–234

SQL, 236

conditions

adding to queries, 589–591

checking integrity of, 373

displaying, 150

editing/creating document in WebI with, 671–673

nested, 621–623

overview of, 209–215

placing on measure objects, 619–621

predefined, 594–595

printing to document universe, 379

queries and, 171, 714–718

Confidential security access level, 291–293

Connection dialog box

Advanced tab, 98

Custom tab, 100

connections

creating and testing, 318–319

types of, 316–317

universe, 94, 96–100

Console, 578

CONSTRAINED value, 217

contexts, 125–135

adding aggregates to measures, 226

aggregate tables and, 227

cardinality detection and, 121

defined, 523

drill by and, 543

dynamic, 526–527

extended syntax and, 525–526

input/output, 524

integrity checks, 374, 375–376

isolated joins and, 129–132

keywords, 525

loop detection/resolution, 125–128

modifying, 128–129

multiple, 110

operators, 524

overview of, 78–79

printing to document universe, 379, 381

SQL using, 110

tips for, 527

using, 132–133

Controlled security access level, 291–293

Controls tab, Universe Parameters, 108–109, 301–302

Corporate Categories, 702

Corporate Documents

customizing page contents, 640

document lists in, 650, 652, 698–700

document types, 418

InfoView and, 694

report access and, 29

republishing refreshed reports to, 665–666

uploading, 654

costs

business goals and, 31–32

BusinessObjects vs. OLTP, 28

cost-based optimizers, 119

location of intelligence and, 219–220, 343

marketing strategy and, 58–59

measuring success by, 34–37

security philosophy and, 280–281

universe connections, 98–99

Count All calculations, 497

Count calculation, 497

COUNT function, SQL

@Aggregate_Aware and, 224

distinct counts and, 245–246

measure objects and, 152

overview of, 244

what to count, 244

Couturier, Hervé, 19

Create and Edit Documents option, 644–645

Create Documents, 667

Create New Group button, 297

crosstabs

creating, 510–512

overview of, 440–443

cumulative aggregates, 530–531

cumulative to-date object, 241–243

currency formats, 455–456

Current Month-To-Date object, 241–242

Current Period object, 239–240

Current Quarter Sales object, 242

Current Week-To-Date object, 241–242

Current Year-To-Date Sales object, 241–243

custom hierarchies

creating, 256–258

linked universes and, 348

Custom tab, Connection dialog box, 100

customer segments, 53

customers. See also users

class/object naming and, 157–159

loyalty of, 18–19

customization, list of values, 348

CWM (Common Warehouse Metamodel), 367, 368

CWMI. See XMI (XML Metadata Interchange)

---