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

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

Go to previous page
Previous
PDF · Mobi · ePub

Index

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

A

ABS math function, about, D.5.1
access control lists, 13.19
accessibility
about, C.1
designing for, C.3
using objects to enhance, C.4
accessing favorites list, 13.11
ACOS math function, about, D.5.2
acting for other users, 1.10, 1.11
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
actions
about, 10.1
about adding, 10.5
about conditionally enabling, 10.10
about inline, 10.7
about named, 10.6
about running, A.6
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.7
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.9, A.17
adding
a list of briefing books to dashboard pages, 4.29.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.29.2
content to dashboards, 4.7.2
dashboard prompts to dashboards and dashboard pages, 6.16, 6.17
favorites to list, 13.10
groups to analyses, 5.12.5
new pages to dashboards, 4.7.1
Oracle BI Publisher reports to dashboard pages, 4.8
prompts to analyses, 2.10
scorecard objects to dashboards, 12.48
views to results of analyses, 3.4
Agent editor, 8.4
agent subscriptions, customizing, 8.14
agents
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.13
creating from KPIs, 11.11
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.29.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
AGGREGATE AT, D.3.1.1
AVG, D.3.1.2
AVGDISTINCT, D.3.1.3
BOTTOMN, D.3.1.4
COUNT, D.3.1.5
COUNT (*), D.3.1.7
COUNTDISTINCT, D.3.1.6
MAX, D.3.1.8
MEDIAN, D.3.1.9
MIN, D.3.1.10
NTILE, D.3.1.11
PERCENTILE, D.3.1.12
RANK, D.3.1.13
STDDEV, D.3.1.14
STDDEV_POP, D.3.1.15
SUM, D.3.1.16
SUMDISTINCT, D.3.1.17
TOPN, D.3.1.18
AGO time series function, about, D.3.3.1
alerts
about, 8.2
accessing and managing, 8.18
subscribing to RSS Feed, 8.19
analyses
about, 2.1
adding actions, 10.14
adding groups, 5.12.5
adding prompts, 2.10
and logical SQL statements, 2.11
and no data results, 2.9.2
applying named filters to, 5.7
creating, 2.6
creating agents from, 2.13
creating using BI Composer, 14.4, 14.5
displaying the results, 2.9
editing, 2.14
editing actions, 10.23
editing using BI Composer, 14.4, 14.6
embedding in dashboards, 2.15
formatting columns, 7.2
generating from KPIs, 11.10
modifying data in table views, A.12
process for constructing, 2.5
saving, 2.12
specifying the criteria, 2.7
using as filters, 5.9
viewing using BI Composer, 14.7
Analysis editor, 2.4
applying
conditional formatting, 7.4
saved customizations, 4.21
applying formats to layers, 3.6.5.8
archiving
about, 13.27
objects, 13.28
ASCII string function, about, D.4.1
ASIN math function, about, D.5.3
assessment mappings, 12.27.1, 12.28, 12.28
assigning
ownership of objects, 13.25
permissions, 13.23
weights in scorecards, 12.29
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

B

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.4, 14.5
editing analyses, 14.4, 14.6
installing and configuring, C.5
viewing analyses, 14.7
BIT_LENGTH string function, about, D.4.2
bookmark links, 4.27.1
BOTTOMN aggregate function, about, D.3.1.4
breadcrumbs
about, A.14
briefing books
about, 4.29
adding a list of to dashboard pages, 4.29.5
adding content to, 4.29.2
downloading, 4.29.4
editing, 4.29.3
using agents to deliver, 4.29.6
business owners, 11.12, 12.24

C

calculated items
about, 5.12
creating, 5.12.3
editing, 5.12.4
nesting, 5.12.6
calculation scripts
for target settings, 11.9
calendar date/time functions
about, D.6
CURRENT_DATE, D.6.1
CURRENT_TIME, D.6.2
CURRENT_TIMESTAMP, D.6.3
DAY_OF_QUARTER, D.6.4
DAYNAME, D.6.5
DAYOFMONTH, D.6.6
DAYOFWEEK, D.6.7
DAYOFYEAR, D.6.8
HOUR, D.6.9
MINUTE, D.6.10
MONTH, D.6.11
MONTH_OF_QUARTER, D.6.12
MONTHNAME, D.6.13
NOW, D.6.14
QUARTER_OF_YEAR, D.6.15
SECOND, D.6.16
TIMESTAMPADD, D.6.17
TIMESTAMPDIFF, D.6.18
WEEK_OF_QUARTER, D.6.19
WEEK_OF_YEAR, D.6.20
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
catalog
See Oracle BI Presentation Catalog
cause & effect maps
about, 12.36
creating, 12.37
opening, 12.45
CEILING math function, about, D.5.6
certification, 1.16
changing
dashboard properties, 4.9
properties of objects, 4.10
changing target values, 11.9, A.17
channels, 3.21.1.3
CHAR string function, about, D.4.3
CHAR_LENGTH string function, about, D.4.4
character literals, about, D.2.6.1
clearing
customizations, 4.23
sorts, 3.10.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.5
column prompts
about, 6.2
and selection steps, 6.11
creating, 6.10
column selector views, editing, 3.6.7
columns
about, 2.2
adding and rearranging in views, 3.6.12.2
and visual indications, 2.2.2
and write back, 3.7.3
code, 2.3
combining using the Set operation, 2.7.6
display, 2.3
double, 2.3
drilling in, 3.9.1
editing the formula, 2.7.5
formatting, 7.2
renamed columns and dashboard prompts, 6.1
types of, 2.2.1
comments, 12.25, 12.26
components of map views, 3.6.5.4
compound layouts, 2.9.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
conditions
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.9.2
contacting business owners, 11.12, 12.24
content
adding to briefing books, 4.29.2
adding to dashboards, 4.7.2
contribution wheel diagrams, 12.32.2
conversion functions
about, D.7
CAST, D.7.1
IFNULL, D.7.2
TO_DATETIME, D.7.3
VALUEOF, D.7.4
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
creating
additional compound layouts, 2.9.1
agents, 8.8
agents from analyses, 2.13
agents from KPIs, 11.11
analyses, 2.6
analyses using BI Composer, 14.4, 14.5
calculation scripts, 11.9
column filters, 5.4
column prompts, 6.10
currency prompts, 6.13
dashboard template pages, 4.25
dashboards, 4.6
image prompts, 6.12
KPI watchlists, 11.16
KPIs, 11.7
links to dashboard pages, 4.27
map views, 3.6.5.6
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.6
custom views
about, 12.43
creating, 12.44
opening, 12.45
customizations
clearing, 4.23
saving, 4.20
customize global header, 1.7
customizing views, 3.19

D

Dashboard builder, 4.3
dashboard pages
about creating links to, 4.27
adding a list of briefing books, 4.29.5
adding actions, 10.15, 10.16, 10.17
adding dashboard prompts, 6.16, 6.17
adding Oracle BI Publisher reports, 4.8
and saved customizations, 4.19
changing properties of objects, 4.10
creating links to, 4.28
deleting, 4.16
deleting objects, 4.15
displaying map views, 3.6.5.10
editing actions, 10.24
modifying data in table views, A.12
publishing, 4.26
using conditions in, 9.9, 9.10, 9.14, 9.15
working with map views, A.9
dashboard prompts
about, 6.1
adding dashboards and dashboard pages, 6.16, 6.17
dashboard template pages
about, 4.24
creating, 4.25
dashboards
about, 4.1
accessing Oracle BI Publisher reports, A.13
adding content, 4.7.2
adding dashboard prompts, 6.16, 6.17
adding new pages, 4.7.1
adding scorecard objects, 12.48
changing properties, 4.9
controlling the look of, 4.4
creating, 4.6
editing, 4.7
embedding analyses, 2.15
opening and using, 4.18
renamed columns and dashboard prompts, 6.1
running actions, A.7
saving, 4.17
data
sorting, 3.10.2
sorting in views, 3.10
working with selections of, 5.3
database functions
about, D.8
EVALUATE, D.8.1
EVALUATE_AGGR, D.8.3
EVALUATE_ANALYTIC, D.8.2
EVALUATE_PREDICATE, D.8.4
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.2.6.3.2
defining
assessment mappings for scorecards, 12.28
detail views, 3.22.2
master views, 3.22.1
sections sliders, 3.6.12.5
DEGREES math function, about, D.5.9
deleting
dashboard pages, 4.16
objects on dashboard pages, 4.15
scorecard objects, 12.47, 12.47
delivery profiles
about, 8.16
configuring, 8.17
designing for accessibility, C.3
detail views
about, 3.21.2
defining, 3.22.2
devices
about, 8.16
configuring, 8.17
dimensions, 11.4
direct database requests, 2.16
disabling agents' schedules, 8.15
display columns, 2.3
displaying
map views on dashboards, 3.6.5.10
results of analyses, 2.9
double columns
about, 2.3
and selections steps, 5.3.4
downloading briefing books, 4.29.4
drilling
configuring, 3.9.2
effects on filters and selection steps, 3.9.3
in columns, 3.9.1
in results, A.5
in views, 3.9
drop targets, 3.6.12.1

E

edit mode in the Scorecard editor, 12.7
editing
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.14
analyses using BI Composer, 14.4, 14.6
briefing books, 4.29.3
column filters, 5.5
column selector views, 3.6.7
dashboards, 4.7
gauges, 3.6.4
graphs, 3.6.2
KPI watchlists, 11.17
KPIs, 11.8
legend views, 3.6.9
map views, 3.6.5, 3.6.5.10
named actions, 10.22
named conditions, 9.12
narrative views, 3.6.6
pivot tables, 3.6.1
prompts, 6.15
saved customizations, 4.22
scorecard objects, 12.46
selection steps, 5.3.2
tables, 3.6.1
view selector views, 3.6.8
views, 3.6
elements of conditions, 9.3
embedding
analyses in dashboards, 2.15
enabling
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
EVALUATE_PREDICATE Function, 5.6
executing named actions, 10.30
EXP math function, about, D.5.10
exporting
reports, KPIs, and analysis prompts data, 13.14
results, A.1
expression literals
character literals, about and expressing, D.2.6
decimal, about and expressing, D.2.6.3.2
integers, about and expressing, D.2.6.3.1
EXTRACTBIT math function, about, D.5.11

F

favorites
about, 13.9
accessing favorites list, 13.11
adding, 13.10
organizing, 13.12
removing, 13.13
filters
about, 5.2
and drilling, 3.9.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.2.6.3.3
FLOOR math function, about, D.5.12
format and layers in map views, 3.6.5.7
formatting
about, 7.1
applying conditional, 7.4
columns in analyses, 7.2
cosmetic, 7.3
custom date and time format strings, 7.6
formulas, editing, 2.7.5
FROM clause syntax, about, D.2.1.5
full-text search
about, 13.5
Oracle Endeca Server integration, 13.5.2
Oracle Secure Enterprise Search integration, 13.5.2
results, 13.7
searching with, 13.6
functions
EVALUATE_PREDICATE, 5.6
functions of map views, 3.6.5.2
funnel graphs, types of, 3.2.2, 3.2.3

G

gauges
defining section sliders for, 3.6.12.5
editing, 3.6.4
types of, 3.2.4
generating analyses from KPIs, 11.10
glob syntax, E
global header, 1.7
graphs
defining section sliders for, 3.6.12.5
editing, 3.6.2
types of, 3.2.1
zooming and scrolling, A.10
GROUP BY clause
syntax, about, D.2.1.7
group objects, 5.3.3
groups
about, 5.12
adding to analyses, 5.12.5
creating, 5.12.3
editing, 5.12.4
nesting, 5.12.6

H

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

I

IFNULL conversion function, about, D.7.2
image prompts
about, 6.3
creating, 6.12
In SQL logical operator, about, D.2.4.1
initiatives
about, 12.22
adding actions to, 10.20
and performance assessment, 12.27
creating, 12.23
editing actions in, 10.27
opening, 12.45
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.2.6.3.1
integrating with Microsoft Office, B.2.1
integration
Oracle Endeca Server, 13.5.2
Oracle Secure Enterprise Search, 13.5.2
interaction of prompts, 6.7
interactions in views, 3.8
Is Null SQL logical operator, about, D.2.4.1

K

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

L

layers
about, 3.6.5.5
and formats, 3.6.5.7
applying formats to, 3.6.5.8
LEFT string function, about, D.4.7
legend views, editing, 3.6.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.11
linking views, 3.22
links
bookmark, 4.27.1
creating to dashboard pages, 4.28
prompted, 4.27.2
list
favorites list, 13.9
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.11
Logical SQL, about, D
LOWER string function, about, D.4.10

M

Maintenance Mode, E
map views
about layers, 3.6.5.5
and applying formats to layers, 3.6.5.8
components of, 3.6.5.4
creating, 3.6.5.6
editing, 3.6.5
editing and displaying on dashboard pages, 3.6.5.10
formats and layers in, 3.6.5.7
functions of, 3.6.5.2
terms used in, 3.6.5.3
working with on dashboard pages, A.9
master detail linking, 3.22
master views
about, 3.21.1
defining, 3.22.1
master-detail linking
about, 3.21
channels, 3.21.1.3
detail views, 3.21.2, 3.22.2
how it works, 3.21.3
master views, 3.21.1, 3.22.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
CEILING, D.5.6
COS, D.5.7
COT, D.5.8
DEGREES, D.5.9
EXTRACTBIT, D.5.11
FLOOR, D.5.12
LOG, D.5.13
LOG10, D.5.14
MOD, D.5.15
PI, D.5.16
POWER, D.5.17
RADIANS, D.5.18
RAND, D.5.19
RANDFROMSEED, D.5.20
ROUND, D.5.21
SIGN, D.5.22
SIN, D.5.23
SQRT, D.5.24
TAN, D.5.25
TRUNCATE, D.5.26
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.7
Microsoft, integrating with, B.2.1
MIN aggregate function, about, D.3.1.10
MINUTE calendar date/time function, about, D.6.10
mission statements
about, 12.15
defining, 12.15, 12.16
opening, 12.45
MOD math function, about, D.5.15
modes
for Scorecard, 12.7
for write back, 3.7.5
modifying target values, 11.9, A.17
modifying the layout of data in views, 3.6.12
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

N

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.6.6
NATURAL_JOIN keyword, using in SELECT_PHYSICAL statements, D.2.2.4
navigating Oracle BI Enterprise Edition, 1.5
navigating with breadcrumbs, A.14
nesting groups and calculated items, 5.12.6
no data results, 2.9.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

O

objectives
about, 12.20
adding actions to, 10.20
and performance assessment, 12.27
creating, 12.21
editing actions in, 10.27
opening, 12.45
objects
accessing properties of, 13.15
archiving, 13.28
assigning ownership to, 13.25
assigning permissions to, 13.23
basic search, 13.6
changing properties of, 4.10
deleting from dashboard pages, 4.15
full-text search, 13.6
inline, 5.1
named, 5.1
ownership of, 13.24
saving, 13.4
taking ownership of, 13.26
tasks for, 13.8
using to enhance accessibility, C.4
OCTET_LENGTH string function, about, D.4.11
opening
dashboards, 4.18
scorecard objects, 12.45
operators, in SQL, D.2.4
Oracle BI Enterprise Edition
and other products, 1.13
getting Help, 1.8
global header, 1.7
Home page, 1.6
introduction to, 1.1
navigating, 1.5
setting preferences for, 1.12
signing in, 1.3
signing out, 1.3
system requirements and certification, 1.16
Oracle BI Presentation Catalog
about, 1.2
basic search, 13.6
full-text search, 13.6
Oracle BI Publisher reports
accessing in dashboards, A.13
adding to dashboard pages, 4.8
Oracle Endeca Server integration, 13.5.2
Oracle Scorecard and Strategy Management
about, 12.1
troubleshooting, 12.49
Oracle Secure Enterprise Search integration, 13.5.2
ORDER BY clause syntax, D.2.1.8
organizing favorites, 13.12
overriding statuses, 11.13, 12.30, 12.31
ownership of objects, 13.24, 13.25, 13.26

P

parent-child hierarchy, 2.2.1
PERCENTILE aggregate function, about, D.3.1.12
performance assessment of initiatives and objectives, 12.27
performance tile, 3.6.10
PERIODROLLING time series function, about, D.3.3.2
permissions
about, 13.17
and access control lists, 13.19
and object assignments, 13.18
assigning, 13.23
availability by object type, 13.21
definitions, 13.20
recommendations for setting, 13.22
perspectives
about, 12.17
creating, 12.18
PI math function, about, D.5.16
pinned dimension values, 11.4
pivot tables, editing, 3.6.1
point of view area, 12.11
point of view controls, 12.12
POSITION string function, about, D.4.12
POWER math function, about, D.5.17
preferences, setting for Oracle BI Enterprise Edition, 1.12
presentation variables, 2.17.3, 2.20
previewing views, 3.17
print options for views, 3.16
printing
options, 3.16
views, 3.15
process for write back, 3.7.2
prompted links, 4.27.2
prompts
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.10
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
properties
accessing object, 13.15
changing dashboard, 4.9
changing object, 4.10
publishing dashboard pages, 4.26

Q

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

R

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.14
referencing variables, 2.18
refreshing the results in views, 3.19
removing
views, 3.18
removing favorites, 13.13
REPEAT string function, about, D.4.13
REPLACE string function, about, D.4.14
repository variables, 2.17.2
results
adding views to, 3.4
drilling in, A.5
exporting and copying, A.1
refreshing in views, 3.19
results of analyses, 2.9, 2.9.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.7
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

S

saved customizations
about, 4.19
applying, 4.21
editing, 4.22
saving
agents, 8.10
analyses, 2.12
customizations, 4.20
dashboards, 4.17
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.12
Scorecard editor
about, 12.3
edit and view modes, 12.7
scorecard objects
about, 12.4
adding to dashboards, 12.48
contacting business owners of, 12.24
deleting, 12.47, 12.47
editing, 12.46
scorecards
about creating, 12.5
and assessment mappings, 12.27.1, 12.28
and assigning weights, 12.29
and comments, 12.25, 12.26
and overriding statuses, 12.30, 12.31
creating, 12.8
defining assessment mappings, 12.28
scrolling in graphs, A.10
searching
about, 13.5
glob syntax, E
results of full-text search, 13.7
the Oracle BI Presentation Catalog, 13.6
SECOND calendar date/time function, about, D.6.16
section sliders, 3.6.12.5, A.8
security, 13.16
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
SELECT_PHYSICAL statement
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.9.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.17.1
Set operation for columns, 2.7.6
setting preferences for Oracle BI Enterprise Edition, 1.12
shortcuts, keyboard, C.2
SIGN math function, about, D.5.22
signing in to Oracle BI Enterprise Edition, 1.3
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.41
creating, 12.42
sorting
clearing, 3.10.3
data in views, 3.10
values, A.3
sorting data, 3.10.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.13, 12.30, 12.31
STDDEV aggregate function, about, D.3.1.14
STDDEV_POP aggregate function, about, D.3.1.15
strategy maps
about, 12.34
creating, 12.35
opening, 12.45
strategy tree diagrams, 12.32.1
strategy trees
about, 12.32
creating, 12.33
opening, 12.45
string functions
about, D.4
ASCII, D.4.1
BIT_LENGTH, D.4.2
CHAR, D.4.3
CHAR_LENGTH, D.4.4
CONCAT, D.4.5
EXP, D.5.10
INSERT, D.4.6
LEFT, D.4.7
LENGTH, D.4.8
LOCATE, D.4.9
LOWER, D.4.10
OCTET_LENGTH, D.4.11
POSITION, D.4.12
REPEAT, D.4.13
REPLACE, D.4.14
RIGHT, D.4.15
SPACE, D.4.16
SUBSTRING, D.4.17
TRIMBOTH, D.4.18
TRIMLEADING, D.4.19
TRIMTRAILING, D.4.20
UPPER, D.4.21
subject areas, 2.2
subscriptions
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.19
system functions
about, D.9
DATABASE, D.9.2
USER, D.9.1
system requirements, 1.16

T

table views, modifying data, A.12
tables
and write back, 3.7.4
editing, 3.6.1
taking ownership of objects, 13.26
TAN math function, about, D.5.25
target settings
adding to KPIs, 11.9
target values
changing, 11.9, A.17
tasks for objects, 13.8
time series functions
about, D.3.3
AGO, D.3.3.1
PERIODROLLING, D.3.3.2
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
types
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

U

unsubscribing from agents, 8.13
upgrading
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
users
acting for, 1.11
interacting with target settings, A.17
users, acting for, 1.10
using dashboards, 4.18

V

VALUEOF conversion function, about, D.7.4
variable prompts
about, 6.3
creating, 6.14
variables
about, 2.17
including and setting in SQL, D.2.7
presentation, 2.17.3, 2.20
referencing, 2.18
repository, 2.17.2
session, 2.17.1
syntax for referencing, 2.19
view mode in the Scorecard editor, 12.7
view selector views, editing, 3.6.8
viewing
analyses using BI Composer, 14.7
metadata information, 2.7.7
summaries of agent settings, 8.9
views
about, 3.1
adding and rearranging columns in, 3.6.12.2
adding to results of analyses, 3.4
and drop targets, 3.6.12.1
and master-detail linking, 3.21
customizing, 3.19
detail, 3.21.2, 3.22.2
drilling in, 3.9
editing, 3.6
editing column selector, 3.6.7
editing gauge, 3.6.4
editing graph, 3.6.2
editing legend, 3.6.9
editing map, 3.6.5
editing narrative, 3.6.6
editing table and pivot table, 3.6.1
editing view selector, 3.6.8
interactions in, 3.8
linking in master-detail relationships, 3.22
master, 3.21.1, 3.22.1
modes for write back, 3.7.5
modifying the layout of data, 3.6.12
opening, 12.45
previewing, 3.17
printing, 3.15
rearranging, 3.14
refreshing the results in, 3.19
saving, 3.12
setting properties for view bodies and drop targets, 3.6.12.3
sorting data in, 3.10
types of, 3.2
working with linked, A.11
views, removing, 3.18
vision statements
about, 12.13
defining, 12.14
opening, 12.45

W

watchlists
about, 12.38
KPI, 11.15
smart, 12.41
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.29
WHERE clause syntax, about, D.2.1.6
write back
adding to columns, 3.7.3
adding to table views, 3.7.4
modes in views, 3.7.5
performing, 3.7
process for, 3.7.2

Y

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

Z

zooming in graphs, A.10