Skip Headers
Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition
11g Release 1 (11.1.1)

Part Number E10544-04
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
PDF · Mobi · ePub


A  B  C  D  E  F  G  H  I  K  L  M  N  O  P  Q  R  S  T  U  V  W  Y  Z 


ABS math function, about, D.5.1
access control lists, 13.21
about, C.1
designing for, C.3
using objects to enhance, C.4
accessing favorites list, 13.13
ACOS math function, about, D.5.2
acting for other users, 1.9, 1.10
action link menus
about, 10.2
adding to dashboard pages, 10.15, 10.17
editing on dashboard pages, 10.24
action links, 10.23
about, 10.2
adding to dashboard pages, 10.15, 10.16
editing on dashboard pages, 10.24
action parameters, 10.9
about, 10.1
about adding, 10.5
about conditionally enabling, 10.10
about inline, 10.7
about named, 10.6
about running, A.4
adding to agents, 10.18
adding to analyses, 10.14
adding to dashboard pages, 10.15, 10.16, 10.17
adding to initiatives and objectives, 10.20
adding to KPIs, 10.19
and displaying information to users, 10.11
and parameters, 10.9
creating from existing actions, 10.21
creating named, 10.12
editing named, 10.22
editing on agents, 10.25
editing on analyses, 10.23
editing on dashboard pages, 10.24
editing on initiatives and objectives, 10.27
editing on KPIs, 10.26
executing named, 10.30
running in dashboards, A.5
saving inline to the catalog, 10.28, 10.29
specifying settings for, 10.13
types, 10.3
upgrading from previous releases, 10.8
actual and target values
changing, 11.5, A.13
a list of briefing books to dashboard pages, 4.24.5
actions to agents, 10.18
actions to analyses, 10.14
actions to dashboard pages, 10.15, 10.16, 10.17
actions to initiatives and objectives, 10.20
actions to KPIs, 10.19
content to briefing books, 4.24.2
content to dashboards, 4.6.2
dashboard prompts to dashboards and dashboard pages, 6.16, 6.17
favorites to list, 13.12
groups to analyses, 5.11.5
new pages to dashboards, 4.6.1
Oracle BI Publisher reports to dashboard pages, 4.7
prompts to analyses, 2.9
scorecard objects to dashboards, 12.43
views to results of analyses, 3.4
Agent editor, 8.4
agent subscriptions, customizing, 8.14
about, 8.1
accessing and managing alerts, 8.18
adding actions, 10.18
and alerts, 8.2
and devices and delivery profiles, 8.16, 8.17
and displaying a list of subscriptions, 8.12
and how they work, 8.3
controlling access to, 8.5
creating, 8.8
creating from analyses, 2.12
creating from KPIs, 11.9
customizing subscriptions to, 8.14
editing actions, 10.25
saving, 8.10
subscribing to, 8.11
unsubscibing from, 8.13
using conditions in, 9.8, 9.13
using customization in, 8.7
using to deliver briefing books, 4.24.6
viewing summaries, 8.9
agents' schedules, disabling and enabling, 8.15
AGGREGATE AT aggregate function, about, D.3.1.1
aggregate functions
about, D.3.1, D.3.1, D.3.2
AVG, D.3.1.2
BOTTOMN, D.3.1.4
COUNT, D.3.1.5
COUNT (*), D.3.1.7
MAX, D.3.1.8
MEDIAN, D.3.1.9
MIN, D.3.1.10
NTILE, D.3.1.11
RANK, D.3.1.13
STDDEV, D.3.1.14
STDDEV_POP, D.3.1.15
SUM, D.3.1.16
TOPN, D.3.1.18
AGO time series function, about, D.3.3.1
about, 8.2
accessing and managing, 8.18
subscribing to RSS Feed, 8.19
about, 2.1
adding actions, 10.14
adding groups, 5.11.5
adding prompts, 2.9
and logical SQL statements, 2.10
and no data results, 2.8.2
applying named filters to, 5.7
creating, 2.6
creating agents from, 2.12
creating using BI Composer, 14.3, 14.4
displaying the results, 2.8
editing, 2.13
editing actions, 10.23
editing using BI Composer, 14.3, 14.5
embedding in dashboards, 2.14
formatting columns, 7.2
generating from KPIs, 11.8
modifying data in table views, A.10
process for constructing, 2.5
saving, 2.11
specifying the criteria, 2.7
using as filters, 5.9
viewing using BI Composer, 14.6
Analysis editor, 2.4
conditional formatting, 7.4
saved customizations, 4.16
applying formats to layers,
about, 13.29
objects, 13.30
ASCII string function, about, D.4.1
ASIN math function, about, D.5.3
assessment mappings, 12.21.1, 12.22, 12.22
ownership of objects, 13.27
permissions, 13.25
weights in scorecards, 12.23
ATAN math function, about, D.5.4
ATAN2 math function, about, D.5.5
attribute columns, 2.2.1
auto-complete for prompts, 6.9
availability of BI Composer, 14.2
AVG aggregate function, about, D.3.1.2
AVGDISTINCT aggregate function, about, D.3.1.3


Balanced Scorecard, 12.2
basic search
about, 13.5
Between SQL logical operator, about, D.2.4.1
BI Composer
about, 14.1
availability, 14.2
creating analyses, 14.3, 14.4
editing analyses, 14.3, 14.5
installing and configuring, C.5
viewing analyses, 14.6
BIT_LENGTH string function, about, D.4.2
bookmark links, 4.22.1
BOTTOMN aggregate function, about, D.3.1.4
briefing books
about, 4.24
adding a list of to dashboard pages, 4.24.5
adding content to, 4.24.2
downloading, 4.24.4
editing, 4.24.3
using agents to deliver, 4.24.6
business owners, 11.10, 12.46


calculated items
about, 5.11
creating, 5.11.3
editing, 5.11.4
nesting, 5.11.6
calculation scripts
for target settings, 11.5
calendar date/time functions
about, D.6
HOUR, D.6.9
MINUTE, D.6.10
MONTH, D.6.11
NOW, D.6.14
SECOND, D.6.16
YEAR, D.6.21
CASE (If) conditional expression, about, D.2.5.2
CASE (Switch) conditional expression, about, D.2.5.1
CAST conversion function, about, D.7.1
See Oracle BI Presentation Catalog
cause & effect maps
about, 12.30
creating, 12.31
opening, 12.39
CEILING math function, about, D.5.6
certification, 1.14
dashboard properties, 4.8
properties of objects, 4.9
changing target values, 11.5, A.13
CHAR string function, about, D.4.3
CHAR_LENGTH string function, about, D.4.4
character literals, about, D.2.6.1
customizations, 4.18
sorts, 3.9.3
code columns, 2.3
column filters
combining and grouping, 5.8
creating, 5.4
creating and editing SQL statements, 5.10
editing, 5.5
column formulas, 2.7.1
column prompts
about, 6.2
and selection steps, 6.11
creating, 6.10
column selector views, editing, 3.5.7
about, 2.2
adding and rearranging in views,
and visual indications, 2.2.2
and write back, 3.6.3
code, 2.3
combining using the Set operation, 2.7.2
display, 2.3
double, 2.3
drilling in, 3.8.1
editing the formula, 2.7.1
formatting, 7.2
renamed columns and dashboard prompts, 6.1
types of, 2.2.1
comments, 12.47, 12.48
components of map views,
compound layouts, 2.8.1
CONCAT string function, about, D.4.5
conditional expressions
about, D.2.5
CASE (If), about and syntax, D.2.5.2
CASE (Switch), about and syntax, D.2.5, D.2.5.1
conditional formatting, 7.4
conditionally enabling actions, 10.10
about, 9.1
about inline, 9.5
about named, 9.4
creating named, 9.7
editing named, 9.12
elements of, 9.3
specifying settings, 9.11
using, 9.2
using in agents, 9.8, 9.13
using in dashboard pages, 9.9, 9.10, 9.14, 9.15
configuring drilling, 3.8.2
contacting business owners, 11.10, 12.46
adding to briefing books, 4.24.2
adding to dashboards, 4.6.2
contribution wheel diagrams, 12.26.2
conversion functions
about, D.7
CAST, D.7.1
copying results, A.1
COS math function, about, D.5.7
cosmetic formatting, 7.3
COT math function, about, D.5.8
COUNT aggregate function, about, D.3.1.5
COUNT(*) aggregate function, about, D.3.1.7
COUNTDISTINCT aggregate function, about, D.3.1.6
additional compound layouts, 2.8.1
agents, 8.8
agents from analyses, 2.12
agents from KPIs, 11.9
analyses, 2.6
analyses using BI Composer, 14.3, 14.4
calculation scripts, 11.5
column filters, 5.4
column prompts, 6.10
currency prompts, 6.13
dashboard template pages, 4.20
dashboards, 4.5
image prompts, 6.12
KPI watchlists, 11.14
KPIs, 11.6
links to dashboard pages, 4.22
map views,
named actions, 10.12
named conditions, 9.7
new actions from existing actions, 10.21
scorecards, 12.8
selection steps, 5.3.1
variable prompts, 6.14
currency prompts
about, 6.3
creating, 6.13
CURRENT_DATE calendar date/time function, about, D.6.1
CURRENT_TIME calendar date/time function, about, D.6.2
CURRENT_TIMESTAMP calendar date/time function, about, D.6.3
custom date and time format strings, 7.5
custom views
about, 12.32
creating, 12.33
opening, 12.39
clearing, 4.18
saving, 4.15
customize global header, 1.7
customizing views, 3.17


Dashboard builder, 4.3
dashboard pages
about creating links to, 4.22
adding a list of briefing books, 4.24.5
adding actions, 10.15, 10.16, 10.17
adding dashboard prompts, 6.16, 6.17
adding Oracle BI Publisher reports, 4.7
and saved customizations, 4.14
changing properties of objects, 4.9
creating links to, 4.23
deleting, 4.11
deleting objects, 4.10
displaying map views,
editing actions, 10.24
modifying data in table views, A.10
publishing, 4.21
using conditions in, 9.9, 9.10, 9.14, 9.15
working with map views, A.7
dashboard prompts
about, 6.1
adding dashboards and dashboard pages, 6.16, 6.17
dashboard template pages
about, 4.19
creating, 4.20
about, 4.1
accessing Oracle BI Publisher reports, A.11
adding content, 4.6.2
adding dashboard prompts, 6.16, 6.17
adding new pages, 4.6.1
adding scorecard objects, 12.43
changing properties, 4.8
controlling the look of, 4.4
creating, 4.5
editing, 4.6
embedding analyses, 2.14
opening and using, 4.13
renamed columns and dashboard prompts, 6.1
running actions, A.5
saving, 4.12
sorting, 3.9.2
sorting in views, 3.9
working with selections of, 5.3
database functions
about, D.8
DATABASE system function, about, D.9.2
DATE data type, changing to, D.7.1
datetime literals, about, D.2.6.2
DAY_OF_QUARTER calendar date/time function, about, D.6.4
DAYNAME calendar date/time function, about, D.6.5
DAYOFMONTH calendar date/time function, about, D.6.6
DAYOFWEEK calendar date/time function, about, D.6.7
DAYOFYEAR calendar date/time function, about, D.6.8
decimal literal, about, D.
assessment mappings for scorecards, 12.22
detail views, 3.20.2
master views, 3.20.1
sections sliders,
DEGREES math function, about, D.5.9
dashboard pages, 4.11
objects on dashboard pages, 4.10
scorecard objects, 12.42, 12.42
delivery profiles
about, 8.16
configuring, 8.17
designing for accessibility, C.3
detail views
about, 3.19.2
defining, 3.20.2
about, 8.16
configuring, 8.17
dimensions, 11.4
direct database requests, 2.15
disabling agents' schedules, 8.15
display columns, 2.3
map views on dashboards,
results of analyses, 2.8
double columns
about, 2.3
and selections steps, 5.3.4
downloading briefing books, 4.24.4
configuring, 3.8.2
effects on filters and selection steps, 3.8.3
in columns, 3.8.1
in results, A.3
in views, 3.8
drop targets,


edit mode in the Scorecard editor, 12.7
actions added to agents, 10.25
actions added to analyses, 10.23
actions added to initiatives and objectives, 10.27
actions added to KPIs, 10.26
actions on dashboard pages, 10.24
analyses, 2.13
analyses using BI Composer, 14.3, 14.5
briefing books, 4.24.3
column filters, 5.5
column selector views, 3.5.7
dashboards, 4.6
gauges, 3.5.4
graphs, 3.5.2
KPI watchlists, 11.15
KPIs, 11.7
legend views, 3.5.9
map views, 3.5.5,
named actions, 10.22
named conditions, 9.12
narrative views, 3.5.6
pivot tables, 3.5.1
prompts, 6.15
saved customizations, 4.17
scorecard objects, 12.41
selection steps, 5.3.2
tables, 3.5.1
view selector views, 3.5.8
views, 3.5
elements of conditions, 9.3
analyses in dashboards, 2.14
actions conditionally, 10.10
agents' schedules, 8.15
EVALUATE database function, about, D.8.1
EVALUATE_AGGR database function, about, D.8.3
EVALUATE_ANALYTIC database function, about, D.8.2
EVALUATE_PREDICATE database function, about, D.8.4
executing named actions, 10.30
EXP math function, about, D.5.10
reports, KPIs, and analysis prompts data, 13.16
results, A.1
expression literals
character literals, about and expressing, D.2.6
decimal, about and expressing, D.
integers, about and expressing, D.
EXTRACTBIT math function, about, D.5.11


about, 13.11
accessing favorites list, 13.13
adding, 13.12
organizing, 13.14
removing, 13.15
about, 5.2
and drilling, 3.8.3
applying named to analyses, 5.7
combining and grouping column, 5.8
creating and editing SQL statements, 5.10
using saved analyses, 5.9
floating point literal, about, D.
FLOOR math function, about, D.5.12
format and layers in map views,
about, 7.1
applying conditional, 7.4
columns in analyses, 7.2
cosmetic, 7.3
custom date and time format strings, 7.5
formulas,editing, 2.7.1
FROM clause syntax, about, D.2.1.5
full-text search
about, 13.5
fully integrated, 13.5.2
partially integrated, 13.5.2
providing partially integrated search, 13.8
results, 13.7
searching with, 13.6
searching with partially integrated, 13.9
fully integrated search
about, 13.5.2
results, 13.7
searching with, 13.6
functions of map views,
funnel graphs, types of, 3.2.2, 3.2.3


defining section sliders for,
editing, 3.5.4
types of, 3.2.4
generating analyses from KPIs, 11.8
glob syntax, E
global header, 1.7
defining section sliders for,
editing, 3.5.2
types of, 3.2.1
zooming and scrolling, A.8
GROUP BY clause
syntax, about, D.2.1.7
group objects, 5.3.3
about, 5.11
adding to analyses, 5.11.5
creating, 5.11.3
editing, 5.11.4
nesting, 5.11.6


hidden dashboards
upgrading from previous releases, 13.3
hierarchical columns, 2.2.1
Home page, 1.6
HOUR calendar date/time function, about, D.6.9


IFNULL conversion function, about, D.7.2
image prompts
about, 6.3
creating, 6.12
In SQL logical operator, about, D.2.4.1
about, 12.19
adding actions to, 10.20
and performance assessment, 12.21
creating, 12.20
editing actions in, 10.27
opening, 12.39
inline actions
about, 10.7
saving to the catalog, 10.28, 10.29
inline conditions, 9.5
inline objects, 5.1
inline prompts, 6.1
INSERT string function, about, D.4.6
integers literals, about, D.
integrating with Microsoft Office, B.1
interaction of prompts, 6.7
interactions in views, 3.7
Is Null SQL logical operator, about, D.2.4.1


Key Performance Indicators
See KPIs
keyboard shortcuts, C.2
KPI details in scorecards, 12.38
KPI watchlists
about, 11.13
creating, 11.14
editing, 11.15
opening, 12.39
about, 11.1
about adding comments, 11.12
about overriding statuses, 11.11
about usage of, 11.3
adding actions, 10.19
adding target settings, 11.5
and dimensions, 11.4
and evaluation, 11.2
contacting business owners, 11.10
creating, 11.6
creating an agent from, 11.9
editing, 11.7
editing actions in, 10.26
generating analyses from, 11.8
opening, 12.39


and formats,
applying formats to,
LEFT string function, about, D.4.7
legend views, editing, 3.5.9
LENGTH string function, about, D.4.8
level-based hierarchy, 2.2.1
Like SQL logical operator, about, D.2.4.1
linked views, A.9
linking views, 3.20
bookmark, 4.22.1
creating to dashboard pages, 4.23
prompted, 4.22.2
favorites list, 13.11
literals, in SQL, D.2.6
LOCATE string function, about, D.4.9
LOG math function, about, D.5.13
LOG10 math function, about, D.5.14
logical operators, D.2.4.1
logical SQL statements, 2.10
Logical SQL, about, D
LOWER string function, about, D.4.10


map views
about layers,
and applying formats to layers,
components of,
editing, 3.5.5
editing and displaying on dashboard pages,
formats and layers in,
functions of,
terms used in,
working with on dashboard pages, A.7
master detail linking, 3.20
master views
about, 3.19.1
defining, 3.20.1
master-detail linking
about, 3.19
detail views, 3.19.2, 3.20.2
how it works, 3.19.3
master views, 3.19.1, 3.20.1
math functions
about, D.5
ABS, D.5.1
ACOS, D.5.2
ASIN, D.5.3
ATAN, D.5.4
ATAN2, D.5.5
COS, D.5.7
COT, D.5.8
FLOOR, D.5.12
LOG, D.5.13
LOG10, D.5.14
MOD, D.5.15
PI, D.5.16
POWER, D.5.17
RAND, D.5.19
ROUND, D.5.21
SIGN, D.5.22
SIN, D.5.23
SQRT, D.5.24
TAN, D.5.25
mathematical operators, about, D.2.4.2
MAVG running aggregate function, about, D.3.2.1
MAX aggregate function, about, D.3.1.8
measure columns, 2.2.1
MEDIAN aggregate function, about, D.3.1.9
metadata information, 2.7.3
Microsoft, integrating with, B.1
MIN aggregate function, about, D.3.1.10
MINUTE calendar date/time function, about, D.6.10
mission statements
about, 12.12
defining, 12.12, 12.13
opening, 12.39
MOD math function, about, D.5.15
for Scorecard, 12.7
for write back, 3.6.5
modifying target values, 11.5, A.13
modifying the layout of data in views, 3.5.10
MONTH calendar date/time function, about, D.6.11
MONTH_OF_QUARTER calendar date/time function, about, D.6.12
MONTHNAME calendar date/time function, about, D.6.13
MSUM running aggregate function, about, D.3.2.2


named actions
about, 10.6
creating, 10.12
creating from existing actions, 10.21
editing, 10.22
executing, 10.30
named conditions
about, 9.4
creating, 9.7
editing, 9.12
named filters, applying to analyses, 5.7
named objects, 5.1
narrative views, editing, 3.5.6
NATURAL_JOIN keyword, using in SELECT_PHYSICAL statements, D.2.2.4
navigating Oracle BI Enterprise Edition, 1.5
nesting groups and calculated items, 5.11.6
no data results, 2.8.2
NOW calendar date/time function, about, D.6.14
NTILE aggregate function, about, D.3.1.11
numeric literals, about, D.2.6.3


about, 12.17
adding actions to, 10.20
and performance assessment, 12.21
creating, 12.18
editing actions in, 10.27
opening, 12.39
accessing properties of, 13.17
archiving, 13.30
assigning ownership to, 13.27
assigning permissions to, 13.25
basic search, 13.6
changing properties of, 4.9
deleting from dashboard pages, 4.10
fully integrated full-text search, 13.6
inline, 5.1
named, 5.1
ownership of, 13.26
partially integrated full-text search, 13.9
saving, 13.4
taking ownership of, 13.28
tasks for, 13.10
using to enhance accessibility, C.4
OCTET_LENGTH string function, about, D.4.11
dashboards, 4.13
scorecard objects, 12.39
operators, in SQL, D.2.4
Oracle BI Enterprise Edition
and other products, 1.12
getting Help, 1.8
global header, 1.7
Home page, 1.6
introduction to, 1.1
navigating, 1.5
setting preferences for, 1.11
signing in, 1.3
signing out, 1.3
system requirements and certification, 1.14
Oracle BI Presentation Catalog
about, 1.2
basic search, 13.6
fully integrated full-text search, 13.6
partially integrated full-text search, 13.9
Oracle BI Publisher reports
accessing in dashboards, A.11
adding to dashboard pages, 4.7
Oracle Scorecard and Strategy Management
about, 12.1
troubleshooting, 12.49
ORDER BY clause syntax, D.2.1.8
organizing favorites, 13.14
overriding statuses, 11.11, 12.44, 12.45
ownership of objects, 13.26, 13.27, 13.28


parent-child hierarchy, 2.2.1
partially integrated search
about, 13.5.2
providing to users, 13.8
searching with, 13.9
PERCENTILE aggregate function, about, D.3.1.12
performance assessment of initiatives and objectives, 12.21
PERIODROLLING time series function, about, D.3.3.2
about, 13.19
and access control lists, 13.21
and object assignments, 13.20
assigning, 13.25
availability by object type, 13.23
definitions, 13.22
recommendations for setting, 13.24
about, 12.14
creating, 12.15
PI math function, about, D.5.16
pinned dimension values, 11.4
pivot tables, editing, 3.5.1
point of view area, 12.24
point of view controls, 12.25
POSITION string function, about, D.4.12
POWER math function, about, D.5.17
preferences, setting for Oracle BI Enterprise Edition, 1.11
presentation variables, 2.16.3, 2.19
previewing views, 3.15
print options for views, 3.14
options, 3.14
views, 3.13
process for write back, 3.6.2
prompted links, 4.22.2
about column, 6.2
about dashboard, 6.1
about inline, 6.1
adding dashboard prompts to dashboards and dashboard pages, 6.16, 6.17
adding to analyses, 2.9
and selections steps, 6.11
and the order applied, 6.8
auto-complete, 6.9
creating column prompt, 6.10
creating currency prompts, 6.13
creating image prompt, 6.12
creating variable prompts, 6.14
dashboard prompts and renamed columns, 6.1
editing, 6.15
interaction of, 6.7
types of, 6.3
types of user input options, 6.4
upgrading from previous releases, 6.5
accessing object, 13.17
changing dashboard, 4.8
changing object, 4.9
publishing dashboard pages, 4.21


QUARTER_OF_YEAR calendar date/time function, about, D.6.15


RADIANS math function, about, D.5.18
ragged hierarchy, 2.2.1
RAND math function, about, D.5.19
RANDFROMSEED math function, about, D.5.20
RANK aggregate function, about, D.3.1.13
RCOUNT running aggregate function, about, D.3.2.4
rearranging views, 3.12
referencing variables, 2.17
refreshing the results in views, 3.17
views, 3.16
removing favorites, 13.15
REPEAT string function, about, D.4.13
REPLACE string function, about, D.4.14
repository variables, 2.16.2
adding views to, 3.4
drilling in, A.3
exporting and copying, A.1
refreshing in views, 3.17
results of analyses, 2.8, 2.8.2
RIGHT string function, about, D.4.15
RMAX running aggregate function, about, D.3.2.5
RMIN running aggregate function, about, D.3.2.6
ROUND math function, about, D.5.21
RSS Feed, 8.19
RSUM running aggregate function, about, D.3.2.3
running actions in dashboards, A.5
running aggregate functions
about, D.3.2
MAVG, D.3.2.1
MSUM, D.3.2.2
RCOUNT, D.3.2.4
RMAX, D.3.2.5
RMIN, D.3.2.6
RSUM, D.3.2.3


saved customizations
about, 4.14
applying, 4.16
editing, 4.17
agents, 8.10
analyses, 2.11
customizations, 4.15
dashboards, 4.12
inline actions to the catalog, 10.28, 10.29
objects, 13.4
objects as inline or named, 5.1
selection steps as a group object, 5.3.3
views, 3.10
Scorecard editor
about, 12.3
edit and view modes, 12.7
scorecard objects
about, 12.4
adding to dashboards, 12.43
contacting business owners of, 12.46
deleting, 12.42, 12.42
editing, 12.41
about creating, 12.5
and assessment mappings, 12.21.1, 12.22
and assigning weights, 12.23
and comments, 12.47, 12.48
and overriding statuses, 12.44, 12.45
creating, 12.8
defining assessment mappings, 12.22
scrolling in graphs, A.8
search functionality
providing partially integrated full-text search, 13.8
about, 13.5
glob syntax, E
results of full-text search, 13.7
the Oracle BI Presentation Catalog, 13.6, 13.9
SECOND calendar date/time function, about, D.6.16
section sliders,, A.6
security, 13.18
SELECT statement
about and basic syntax, D.2.1
conditional expressions, D.2.5
GROUP BY clause syntax, D.2.1.7
mathematical operators, D.2.4.2
ORDER BY clause syntax, D.2.1.8
select list syntax, D.2.1.4
SQL logical operators, D.2.4.1
subquery support, D.2.1.3
usage notes, D.2.1.2
WHERE clause syntax, D.2.1.6
about and basic syntax, D.2.2
aggregate functions not supported in, D.2.2.2
queries supported by, D.2.2.3
usage notes, D.2.2.5
using the NATURAL_JOIN keyword, D.2.2.4
selection steps
about, 5.2
and column prompts, 6.11
and drilling, 3.8.3
editing, 5.3.2
saving as a group object, 5.3.3
selections of data, working with, 5.3
selections steps
and double columns, 5.3.4
creating, 5.3.1
session variables, 2.16.1
Set operation for columns, 2.7.2
setting preferences for Oracle BI Enterprise Edition, 1.11
shortcuts, keyboard, C.2
siging in to Oracle BI Enterprise Edition, 1.3
SIGN math function, about, D.5.22
signing out of Oracle BI Enterprise Edition, 1.3
SIN math function, about, D.5.23
skip-level hierarchy, 2.2.1
smart watchlists
about, 12.35
creating, 12.36
clearing, 3.9.3
data in views, 3.9
values, A.2
sorting data, 3.9.2
SPACE string function, about, D.4.16
SQL functions
aggregate functions, about, D.3.1
calendar date/time functions, about, D.6
conversion functions, about, D.7
database functions, about, D.8
expressing literals, D.2.6
math functions, about, D.5
running aggregate functions, about, D.3.2
string functions, about, D.4
system functions, about, D.9
time series functions, about, D.3.3
SQL operators, D.2.4
SQL statements, 5.10
SQL syntax and semantics
conditional expressions, D.2.5
FROM clause syntax, about, D.2.1.5
GROUP BY clause syntax, about, D.2.1.7
including and setting variables, D.2.7
ORDER BY clause syntax, about, D.2.1.8
Select list syntax, D.2.1.4
Select statement, about and basic syntax, D.2.1
Select usage notes, D.2.1.2, D.2.1.3
SQL logical operators, D.2.4.1, D.2.4.2
WHERE clause syntax, about, D.2.1.6
SQRT math function, about, D.5.24
status overrides, 11.11, 12.44, 12.45
STDDEV aggregate function, about, D.3.1.14
STDDEV_POP aggregate function, about, D.3.1.15
strategy maps
about, 12.28
creating, 12.29
opening, 12.39
strategy tree diagrams, 12.26.1
strategy trees
about, 12.26
creating, 12.27
opening, 12.39
string functions
about, D.4
ASCII, D.4.1
CHAR, D.4.3
EXP, D.5.10
LEFT, D.4.7
LOWER, D.4.10
REPEAT, D.4.13
RIGHT, D.4.15
SPACE, D.4.16
UPPER, D.4.21
subject areas, 2.2
customizing agent, 8.14
to agents, 8.11
SUBSTRING string function, about, D.4.17
SUM aggregate function, about, D.3.1.16
SUMDISTINCT aggregate function, about, D.3.1.17
syntax for referencing variables, 2.18
system functions
about, D.9
USER, D.9.1
system requirements, 1.14


table views, modifying data, A.10
and write back, 3.6.4
editing, 3.5.1
taking ownership of objects, 13.28
TAN math function, about, D.5.25
target settings
adding to KPIs, 11.5
target values
changing, 11.5, A.13
tasks for objects, 13.10
time series functions
about, D.3.3
AGO, D.3.3.1
TODATE, D.3.3.3
TIMESTAMPADD calendar date/time function, about, D.6.17
TIMESTAMPDIFF calendar date/time function, about, D.6.18
TO_DATETIME conversion function, about, D.7.3
TODATE time series function, about, D.3.3.3
TOPN aggregate function, about, D.3.1.18
TRIMBOTH string function, about, D.4.18
TRIMLEADING string function, about, D.4.19
TRIMTRAILING string function, about, D.4.20
troubleshooting Oracle Scorecard and Strategy Management, 12.49
TRUNCATE math function, about, D.5.26
of actions, 10.3
of funnel graphs, 3.2.2, 3.2.3
of gauges, 3.2.4
of graphs, 3.2.1
of prompts, 6.3
of user input options for prompts, 6.4
of views, 3.2


unsubscribing from agents, 8.13
actions from previous releases, 10.8
hidden dashboards from previous releases, 13.3
prompts from previous releases, 6.5
UPPER string function, about, D.4.21
USER system function, about, D.9.1
acting for, 1.10
interacting with target settings, A.13
users, acting for, 1.9
using dashboards, 4.13


VALUEOF conversion function, about, D.7.4
variable prompts
about, 6.3
creating, 6.14
about, 2.16
including and setting in SQL, D.2.7
presentation, 2.16.3, 2.19
referencing, 2.17
repository, 2.16.2
session, 2.16.1
syntax for referencing, 2.18
view mode in the Scorecard editor, 12.7
view selector views, editing, 3.5.8
analyses using BI Composer, 14.6
metadata information, 2.7.3
summaries of agent settings, 8.9
about, 3.1
adding and rearranging columns in,
adding to results of analyses, 3.4
and drop targets,
and master-detail linking, 3.19
customizing, 3.17
detail, 3.19.2, 3.20.2
drilling in, 3.8
editing, 3.5
editing column selector, 3.5.7
editing gauge, 3.5.4
editing graph, 3.5.2
editing legend, 3.5.9
editing map, 3.5.5
editing narrative, 3.5.6
editing table and pivot table, 3.5.1
editing view selector, 3.5.8
interactions in, 3.7
linking in master-detail relationships, 3.20
master, 3.19.1, 3.20.1
modes for write back, 3.6.5
modifying the layout of data, 3.5.10
opening, 12.39
previewing, 3.15
printing, 3.13
rearranging, 3.12
refreshing the results in, 3.17
saving, 3.10
setting properties for view bodies and drop targets,
sorting data in, 3.9
types of, 3.2
working with linked, A.9
views, removing, 3.16
vision statements
about, 12.10
defining, 12.11
opening, 12.39


about, 12.34
KPI, 11.13
smart, 12.35
WEEK_OF_QUARTER calendar date/time function, about, D.6.19
WEEK_OF_YEAR calendar date/time function, about, D.6.20
weights, assigning in scorecards, 12.23
WHERE clause syntax, about, D.2.1.6
write back
adding to columns, 3.6.3
adding to table views, 3.6.4
modes in views, 3.6.5
performing, 3.6
process for, 3.6.2


YEAR calendar date/time function, about, D.6.21


zooming in graphs, A.8