| < Day Day Up > |
|
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 > |
|