Index_S

 < Day Day Up > 



S

salespeople, 18–19

Save As

documents, 446

templates, 483

Save As HTML, 446–447

saving documents

options, 447–448

Save As, 446

Save As HTML, 446–447

WebI v. 6.0 options, 710–711

saving refreshed reports, 665–666

Scan and Repair dialog, 296

scheduled documents

document types, 418

status of, 578

viewing document lists, 650

Scheduling tab, BCA (Broadcast Agent), 575–577

Scope of Analysis

multidimensional analysis, 551–553

overview of, 670–671

query creation, 588–589

using with Drill mode, 662–663

Search box, InfoView, 701

Search For box, document lists, 653

Search option, Navigation bar, 652–653

secondary users, segmenting, 40–41

Secondary Y axis, 477–478

Section Cell settings, 679

sections, BusinessObjects reports, 424

secure connections

creating, 318–319

defined, 317

linked universe requirement, 349

security, 280–288

access control and, 170–171

access levels, 291–293, 303

BusinessObjects architecture and, 94–96

centralized or decentralized, 287

company’s organization and, 281–282

Designer offline mode and, 85

domains, 411, 412

overview of, 280–281

resources, 283–284

separating test/production universes in domains, 356–357

universe connections and, 96

universe deployment and, 81

user types and profiles, 284–286

where to create users, 286–288

segmentation. See users, segmenting

@Select function

@Aggregate_Aware and, 225

CODE syntax, 241–243

DECODE syntax, 239

overview of, 206

selecting objects in Designer, 212

SQL Editor and, 207

SELECT statement, 627

self-joins, 142–146

Series tab options, chart formats, 475

server-based processing

MOLAP cubes, 332

relational tables, 335

universe, 335

user objects, 219–220

Set Analyzer, 21

Shading tab, cell formats, 459

shared connections, 317

shared list of values, 198–199

SHOP_FACTS

aggregate awareness, 230

outer joins, 121–123

queries, 227

shortcut joins, 146–147, 195–197

shortcut keys

deleting, 163–164

Designer, 85–87

Supervisor, 289–290

Show button, 164–165

Show Footer, 467

Show Format checkbox, 116

Show Header, 467

Show / Hide Report Map button, 705

Show Prompts Within The Report setting, 677

Show Row Count checkbox, 115–117

single quotes (‘), 233

situation analysis, 53–56

skins, InfoView, 695

Slice and Dice Panel

breaks, 492–496, 500

calculations, 496–500

displaying data in table, 615

Euro calculations, 515–518

filters, 501–504

formulas, 518–531

interface, 488

launching, 20, 488

master/detail reports, 508–512

rankings, 504–508

sorts, 490–491, 500

toolbar buttons, 489–490

variance calculations, 512–515

Snapshot button, 705

Snapshots, 547–548

snowflake schemas, 75–76, 121

Solution Selling methodology, 19

Sort command, InfoView, 706

sort options, queries, 597

sort order, 197–198, 354

sorts

data within reports, 490–491

multiple, 500

querying, 171

WebI and, 673–675

Sparacino, Frank, 17

sponsorship, business, 28, 47

spreadsheets

segmentation based on usage of, 42–43

as source of information, 4

WebI v. 6.0 and, 22

SQL

aliases, 141–142

Automatic Time Hierarchy limitations, 255–256

cautions using, 208–209

combining HTML with, 232–235

dimension objects, 167

integrity checks, 372

multipass, 132, 612–614

operators, 592–593

overcoming limitations of, 518

reading tables with SQL strategies, 103–106

syntax for outer joins, 123

universe and, 337

user objects and, 219–220

user reports and, 339–340

SQL aggregates, 175–176, 187–188

SQL Editor, 206–208

SQL functions, 236–248

@Select function, 206

aggregate measurement and, 536

CASE, 241–244

concatenated, 236

COUNT, 244–246

DECODE, 239–241

RANK, 246–248

time, 236–238

SQL statements

refreshing and regenerating, 568

testing and viewing, 229–232

writing with SQL Editor, 207–208

SQL tab, Universe Parameters, 109–112, 302

SQL Viewer, 391

staff meetings, 63

stakeholders, 43–45

Standard HTML format, 647, 704

standard reports

business goals, 33

IT goals, 27

new document options, 582

styles, 479, 484–485

standard toolbar, 421–422, 565

standardization, 45–46

star schemas

BusinessObjects supporting, 75–76

cardinality detection and display, 121

creating classes and objects from tables with, 107

incompatibility with aggregate table, 227

start page, InfoView, 640–642

status bar, 418, 566

Status, command set, 314–315

stored procedures, 582

Strategies tab, Universe Parameters dialog box, 100–108

database options relating to, 106–108

external strategies, 102–106

overview of, 100–102

strengths, weaknesses, opportunities, and threats (SWOT) analysis, 54–56

stress tests, pilot phase, 388

Structure pane

integrity checks, 373, 375

printing to document universe, 379

Structure Translation, 271

structure view, BusinessObjects, 426

subcategories, InfoView, 694–695, 701–702

subqueries, 627–633

allowing use of SQL, 109

Calculation subquery, 628–633

creating, 627–628

creating in WebI version 6.0, 717–718

Sum calculation, 497

SUM function, SQL, 224

summary aggregate tables, 223–224

Summary tab, Universe Parameters dialog box, 100

Sundance, 22

Supervisor

adding groups, 297–300

adding new users, 288–290

command restrictions, 311–316

connections, 316–319

defined, 47

generalizations, 321

inheritance, 320

password options, 410

quality assurance checklist, 384

response time and, 320

security domains, 81

supervisor role

centralized or decentralized security, 287

controlling access to information, 280

overview of, 47

Supervisor, security

company’s organization and, 281–282

overview of, 280–281

resources, 283–284

user types and profiles, 284–286

where to create users, 286–288

Supervisor, universe properties, 300–311

data restrictions, 303–305

database views vs. row restrictions, 310

parameters, 300–303

row restrictions, 306–309

table mappings, 310–311

Supervisor, user properties, 290–296

disabling and deleting user, 295–296

groups and profiles, 294

object level security, 291–293

password settings, 293

timestamps, 295

user definition, 290–291

SWOT (strengths, weaknesses, opportunities, and threats) analysis, 54–56

synchronization

Calculation subquery options, 630–631

multiple data providers and, 614, 615–616

SYSDATE function, 214–215, 238, 240–241

system load, 340



 < Day Day Up > 



Business Objects(c) The Complete Reference
Cisco Field Manual: Catalyst Switch Configuration
ISBN: 72262656
EAN: 2147483647
Year: 2005
Pages: 206

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net