Skip Headers
Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition
11g Release 1 (11.1.1)
E10544-01
  Go To Table Of Contents
Contents
Previous
Previous 		  

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, A.4.1
access control lists, 13.15
accessibility
about, E.1
designing for, E.3
using objects to enhance, E.4
ACOS math function, about, A.4.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
actions
about, 10.1
about adding, 10.5
about conditionally enabling, 10.10
about inline, 10.7
about named, 10.6
about running, C.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, C.5
saving inline to the catalog, 10.28, 10.29
specifying settings for, 10.13
types, 10.3
adding
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
comments in scorecards, 12.45
content to briefing books, 4.24.2
content to dashboards, 4.6.2
dashboard prompts to dashboards and dashboard pages, 6.12, 6.13
groups to analyses, 5.10.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.40
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.12
creating from KPIs, 11.8
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, A.2.1.1
aggregate functions
about, A.2.1, A.2.1, A.2.2
AGGREGATE AT, A.2.1.1
AVG, A.2.1.2
AVGDISTINCT, A.2.1.3
BOTTOMN, A.2.1.4
COUNT, A.2.1.5
COUNT (*), A.2.1.7
COUNTDISTINCT, A.2.1.6
MAX, A.2.1.8
MEDIAN, A.2.1.9
MIN, A.2.1.10
NTILE, A.2.1.11
PERCENTILE, A.2.1.12
RANK, A.2.1.13
STDDEV, A.2.1.14
STDDEV_POP, A.2.1.15
SUM, A.2.1.16
SUMDISTINCT, A.2.1.17
TOPN, A.2.1.18
AGO time series function, about, A.2.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.10.5
adding prompts, 2.9
and logical SQL statements, 2.10
and no data results, 2.8.2
applying named filters to, 5.6
creating, 2.6
creating agents from, 2.12
displaying the results, 2.8
editing, 2.13
editing actions, 10.23
embedding in dashboards, 2.14
formatting columns, 7.2
generating from KPIs, 11.7
modifying data in table views, C.10
process for constructing, 2.5
saving, 2.11
specifying the criteria, 2.7
using as filters, 5.8
Analysis editor, 2.4
applying
conditional formatting, 7.4
saved customizations, 4.16
applying formats to layers, 3.5.4.7
archiving
about, 13.21
objects, 13.22
ASCII string function, about, A.3.1
ASIN math function, about, A.4.3
assessment mappings for scorecards, 12.25
assigning
ownership of objects, 13.20
permissions, 13.19
assigning weights in scorecards, 12.24
ATAN math function, about, A.4.4
ATAN2 math function, about, A.4.5
attribute columns, 2.2.1
AVG aggregate function, about, A.2.1.2
AVGDISTINCT aggregate function, about, A.2.1.3

B

Balanced Scorecard, 12.2
Between SQL logical operator, about, A.1.3.1
BIT_LENGTH string function, about, A.3.2
bookmark links, 4.22.1
BOTTOMN aggregate function, about, A.2.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.9, 12.43

C

calculated items
about, 5.10
creating, 5.10.3
editing, 5.10.4
nesting, 5.10.6
calendar date/time functions
about, A.5
CURRENT_DATE, A.5.1
CURRENT_TIME, A.5.2
CURRENT_TIMESTAMP, A.5.3
DAY_OF_QUARTER, A.5.4
DAYNAME, A.5.5
DAYOFMONTH, A.5.6
DAYOFWEEK, A.5.7
DAYOFYEAR, A.5.8
HOUR, A.5.9
MINUTE, A.5.10
MONTH, A.5.11
MONTH_OF_QUARTER, A.5.12
MONTHNAME, A.5.13
NOW, A.5.14
QUARTER_OF_YEAR, A.5.15
SECOND, A.5.16
TIMESTAMPADD, A.5.17
TIMESTAMPDIFF, A.5.18
WEEK_OF_QUARTER, A.5.19
WEEK_OF_YEAR, A.5.20
YEAR, A.5.21
CASE (If) conditional expression, about, A.1.4.2
CASE (Switch) conditional expression, about, A.1.4.1
CAST conversion function, about, A.6.1
catalog
See Oracle BI Presentation Catalog
cause & effect maps
about, 12.32
creating, 12.33
CEILING math function, about, A.4.6
certification, 1.14
changing
dashboard properties, 4.8
properties of objects, 4.9
channels, 3.18.1.3
CHAR string function, about, A.3.3
CHAR_LENGTH string function, about, A.3.4
character literals, about, A.1.5.1
clearing
customizations, 4.18
sorts, 3.9.4
code columns, 2.3
column filters
combining and grouping, 5.7
creating and editing SQL statements, 5.9
creating or editing, 5.4
column formulas, 2.7.1
column prompts
about, 6.2
and selection steps, 6.8
creating and editing, 6.7
column selector views, editing, 3.5.6
columns
about, 2.2
adding and rearranging in views, 3.5.9.2
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
types of, 2.2.1
comments
about, 12.44
adding in scorecards, 12.45
displaying in scorecards, 12.47
replying in scorecards, 12.46
components of map views, 3.5.4.3
compound layouts, 2.8.1
CONCAT string function, about, A.3.5
conditional expressions
about, A.1.4
CASE (If), about and syntax, A.1.4.2
CASE (Switch), about and syntax, A.1.4, A.1.4.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.8.2
contacting business owners, 11.9, 12.43
content
adding to briefing books, 4.24.2
adding to dashboards, 4.6.2
conversion functions
about, A.6
CAST, A.6.1
IFNULL, A.6.2
TO_DATETIME, A.6.3
VALUEOF, A.6.4
copying results, C.1
COS math function, about, A.4.7
cosmetic formatting, 7.3
COT math function, about, A.4.8
COUNT aggregate function, about, A.2.1.5
COUNT(*) aggregate function, about, A.2.1.7
COUNTDISTINCT aggregate function, about, A.2.1.6
creating
additional compound layouts, 2.8.1
agents, 8.8
agents from analyses, 2.12
agents from KPIs, 11.8
analyses, 2.6
column filters, 5.4
column prompts, 6.7
currency prompts, 6.10
dashboard template pages, 4.20
dashboards, 4.5
image prompts, 6.9
KPI watchlists, 11.13
KPIs, 11.6
links to dashboard pages, 4.22
map views, 3.5.4.5
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.11
currency prompts
about, 6.3
creating or editing, 6.10
CURRENT_DATE calendar date/time function, about, A.5.1
CURRENT_TIME calendar date/time function, about, A.5.2
CURRENT_TIMESTAMP calendar date/time function, about, A.5.3
custom date and time format strings, 7.5
custom views
about, 12.34
creating, 12.35, 12.35
customizations
clearing, 4.18
saving, 4.15
customizing views, 3.16

D

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.12, 6.13
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, 3.5.4.8
editing actions, 10.24
modifying data in table views, C.10
publishing, 4.21
using conditions in, 9.9, 9.10, 9.14, 9.15
working with map views, C.7
dashboard prompts
about, 6.1
adding dashboards and dashboard pages, 6.12, 6.13
dashboard template pages
about, 4.19
creating, 4.20
dashboards
about, 4.1
accessing Oracle BI Publisher reports, C.11
adding content, 4.6.2
adding dashboard prompts, 6.12, 6.13
adding new pages, 4.6.1
adding scorecard objects, 12.40
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
running actions, C.5
saving, 4.12
data
sorting, 3.9.3
sorting in views, 3.9
working with selections of, 5.3
database functions
about, A.7
EVALUATE, A.7.1
EVALUATE_AGGR, A.7.3
EVALUATE_ANALYTIC, A.7.2
EVALUATE_PREDICATE, A.7.4
DATABASE system function, about, A.8.2
DATE data type, changing to, A.6.1
datetime literals, about, A.1.5.2
DAY_OF_QUARTER calendar date/time function, about, A.5.4
DAYNAME calendar date/time function, about, A.5.5
DAYOFMONTH calendar date/time function, about, A.5.6
DAYOFWEEK calendar date/time function, about, A.5.7
DAYOFYEAR calendar date/time function, about, A.5.8
decimal literal, about, A.1.5.3.2
defining
assessment mappings for scorecards, 12.25
detail views, 3.19.2
master views, 3.19.1
sections sliders, 3.5.9.5
DEGREES math function, about, A.4.9
deleting
dashboard pages, 4.11
objects on dashboard pages, 4.10
scorecard objects, 12.39, 12.39
delivery profiles
about, 8.16
configuring, 8.17
designing for accessibility, E.3
detail views
about, 3.18.2
defining, 3.19.2
devices
about, 8.16
configuring, 8.17
dimensions, 11.4
direct database requests, 2.15
disabling agents' schedules, 8.15
display columns, 2.3
displaying
map views on dashboards, 3.5.4.8
results of analyses, 2.8
displaying comments in scorecards, 12.47
double columns
about, 2.3
and selections steps, 5.3.4
downloading briefing books, 4.24.4
drilling
configuring, 3.8.2
effects on filters and selection steps, 3.8.3
in columns, 3.8.1
in results, C.3
in views, 3.8
drop targets, 3.5.9.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.13
briefing books, 4.24.3
column filters, 5.4
column prompts, 6.7
column selector views, 3.5.6
currency prompts, 6.10
dashboards, 4.6
gauges, 3.5.3
graphs, 3.5.2
image prompts, 6.9
KPI watchlists, 11.13
KPIs, 11.6
legend views, 3.5.8
map views, 3.5.4, 3.5.4.8
named actions, 10.22
named conditions, 9.12
narrative views, 3.5.5
pivot tables, 3.5.1
saved customizations, 4.17
scorecard objects, 12.38
selection steps, 5.3.2
tables, 3.5.1
variable prompts, 6.11
view selector views, 3.5.7
views, 3.5
elements of conditions, 9.3
embedding
analyses in dashboards, 2.14
enabling
actions conditionally, 10.10
agents' schedules, 8.15
EVALUATE database function, about, A.7.1
EVALUATE_AGGR database function, about, A.7.3
EVALUATE_ANALYTIC database function, about, A.7.2
EVALUATE_PREDICATE database function, about, A.7.4
EVALUATE_PREDICATE Function, 5.5
executing named actions, 10.30
EXP math function, about, A.4.10
exporting
reports, KPIs, and analysis prompts data, 13.10
results, C.1
expression literals
character literals, about and expressing, A.1.5
decimal, about and expressing, A.1.5.3.2
integers, about and expressing, A.1.5.3.1
EXTRACTBIT math function, about, A.4.11

F

filters
about, 5.2
and drilling, 3.8.3
applying named to analyses, 5.6
combining and grouping column, 5.7
creating and editing SQL statements, 5.9
using saved analyses, 5.8
floating point literal, about, A.1.5.3.3
FLOOR math function, about, A.4.12
format and layers in map views, 3.5.4.6
formatting
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, A.1.1.5
functions
EVALUATE_PREDICATE, 5.5
functions of map views, 3.5.4.1
funnel graphs, types of, 3.2.2

G

gauges
defining section sliders for, 3.5.9.5
editing, 3.5.3
types of, 3.2.3
generating analyses from KPIs, 11.7
global header, 1.7
graphs
defining section sliders for, 3.5.9.5
editing, 3.5.2
types of, 3.2.1
zooming and scrolling, C.8
GROUP BY clause
syntax, about, A.1.1.7
group objects, 5.3.3
groups
about, 5.10
adding to analyses, 5.10.5
creating, 5.10.3
editing, 5.10.4
nesting, 5.10.6

H

hierarchical columns, 2.2.1
Home page, 1.6
HOUR calendar date/time function, about, A.5.9

I

IFNULL conversion function, about, A.6.2
image prompts
about, 6.3
creating or editing, 6.9
In SQL logical operator, about, A.1.3.1
initiatives
about, 12.20
adding actions to, 10.20
and performance assessment, 12.23
creating, 12.21
editing actions in, 10.27
opening, 12.22
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, A.3.6
integers literals, about, A.1.5.3.1
integrating with Microsoft Office, D.1
interaction of prompts, 6.5
interactions in views, 3.7
Is Null SQL logical operator, about, A.1.3.1

K

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

L

layers
about, 3.5.4.4
and formats, 3.5.4.6
applying formats to, 3.5.4.7
LEFT string function, about, A.3.7
legend views, editing, 3.5.8
LENGTH string function, about, A.3.8
level-based hierarchy, 2.2.1
Like SQL logical operator, about, A.1.3.1
linked views, C.9
linking views, 3.19
links
bookmark, 4.22.1
creating to dashboard pages, 4.23
prompted, 4.22.2
literals, in SQL, A.1.5
LOCATE string function, about, A.3.9
LOCATEN string function, about, A.3.10
LOG math function, about, A.4.13
LOG10 math function, about, A.4.14
logical operators, A.1.3.1
logical SQL statements, 2.10
Logical SQL, about, A
LOWER string function, about, A.3.11

M

map views
about layers, 3.5.4.4
and applying formats to layers, 3.5.4.7
components of, 3.5.4.3
creating, 3.5.4.5
editing, 3.5.4
editing and displaying on dashboard pages, 3.5.4.8
formats and layers in, 3.5.4.6
functions of, 3.5.4.1
terms used in, 3.5.4.2
working with on dashboard pages, C.7
master detail linking, 3.19
master views
about, 3.18.1
defining, 3.19.1
master-detail linking
about, 3.18
channels, 3.18.1.3
detail views, 3.18.2, 3.19.2
how it works, 3.18.3
master views, 3.18.1, 3.19.1
math functions
about, A.4
ABS, A.4.1
ACOS, A.4.2
ASIN, A.4.3
ATAN, A.4.4
ATAN2, A.4.5
CEILING, A.4.6
COS, A.4.7
COT, A.4.8
DEGREES, A.4.9
EXTRACTBIT, A.4.11
FLOOR, A.4.12
LOG, A.4.13
LOG10, A.4.14
MOD, A.4.15
PI, A.4.16
POWER, A.4.17
RADIANS, A.4.18
RAND, A.4.19
RANDFROMSEED, A.4.20
ROUND, A.4.21
SIGN, A.4.22
SIN, A.4.23
SQRT, A.4.24
TAN, A.4.25
TRUNCATE, A.4.26
mathematical operators, about, A.1.3.2
MAVG running aggregate function, about, A.2.2.1
MAX aggregate function, about, A.2.1.8
measure columns, 2.2.1
MEDIAN aggregate function, about, A.2.1.9
metadata information, 2.7.3
Microsoft, integrating with, D.1
MIN aggregate function, about, A.2.1.10
MINUTE calendar date/time function, about, A.5.10
mission statements
about, 12.12
defining, 12.12, 12.13
MOD math function, about, A.4.15
modes
for Scorecard, 12.7
for write back, 3.6.5
modifying the layout of data in views, 3.5.9
MONTH calendar date/time function, about, A.5.11
MONTH_OF_QUARTER calendar date/time function, about, A.5.12
MONTHNAME calendar date/time function, about, A.5.13
MSUM running aggregate function, about, A.2.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.6
named objects, 5.1
narrative views, editing, 3.5.5
NATURAL_JOIN keyword, using in SELECT_PHYSICAL statements, A.1.2.4
navigating Oracle BI Enterprise Edition, 1.5
nesting groups and calculated items, 5.10.6
new features, Preface
no data results, 2.8.2
NOW calendar date/time function, about, A.5.14
NTILE aggregate function, about, A.2.1.11
numeric literals, about, A.1.5.3

O

objectives
about, 12.18
adding actions to, 10.20
and performance assessment, 12.23
creating, 12.19
editing actions in, 10.27
opening, 12.22
objects
accessing properties of, 13.11
archiving, 13.22
assigning ownership to, 13.20
assigning permissions to, 13.19
changing properties of, 4.9
deleting from dashboard pages, 4.10
inline, 5.1
named, 5.1
saving, 13.3
searching for, 13.5, 13.8
tasks for, 13.9
using to enhance accessibility, E.4
OCTET_LENGTH string function, about, A.3.12
opening
dashboards, 4.13
initiatives, 12.22
KPIs, 11.5
objectives, 12.22
operators, in SQL, A.1.3
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
new features, Preface
setting preferences for, 1.11
signing in, 1.3
signing out, 1.3
system requirements and certification, 1.14
upgrade considerations, Preface
Oracle BI Presentation Catalog
about, 1.2
searching, 13.5
Oracle BI Presentaton Catalog
searching, 13.8
Oracle BI Publisher reports
accessing in dashboards, C.11
adding to dashboard pages, 4.7
Oracle Scorecard and Strategy Management, 12.1
ORDER BY clause syntax, A.1.1.8
overriding statuses, 11.10, 12.41, 12.42
ownership of objects, 13.20

P

parent-child hierarchy, 2.2.1
PERCENTILE aggregate function, about, A.2.1.12
performance assessment of initiatives and objectives, 12.23
PERIODROLLING time series function, about, A.2.3.2
permissions
about, 13.13
and access control lists, 13.15
and object assignments, 13.14
assigning, 13.19
availability by object type, 13.17
definitions, 13.16
recommendations for setting, 13.18
perspectives
about, 12.14
creating, 12.15
PI math function, about, A.4.16
pinned dimension values, 11.4
pivot tables, editing, 3.5.1
point of view area, 12.26
point of view controls, 12.27
POSITION string function, about, A.3.13
POWER math function, about, A.4.17
preferences, setting for Oracle BI Enterprise Edition, 1.11
presentation variables, 2.16.3, 2.19
previewing views, 3.14
print options for views, 3.13
printing
options, 3.13
views, 3.12
process for write back, 3.6.2
prompted links, 4.22.2
prompts
about column, 6.2
about dashboard, 6.1
about inline, 6.1
adding dashboard prompts to dashboards and dashboard pages, 6.12, 6.13
adding to analyses, 2.9
and selections steps, 6.8
and the order applied, 6.6
creating and editing column, 6.7
creating or editing currency, 6.10
creating or editing image, 6.9
creating or editing variable, 6.11
interaction of, 6.5
types of, 6.3
types of user input options, 6.4
properties
accessing object, 13.11
changing dashboard, 4.8
changing object, 4.9
publishing dashboard pages, 4.21

Q

QUARTER_OF_YEAR calendar date/time function, about, A.5.15

R

RADIANS math function, about, A.4.18
ragged hierarchy, 2.2.1
RAND math function, about, A.4.19
RANDFROMSEED math function, about, A.4.20
RANK aggregate function, about, A.2.1.13
RCOUNT running aggregate function, about, A.2.2.4
rearranging views, 3.11
referencing variables, 2.17
refreshing the results in views, 3.16
removing
views, 3.15
REPEAT string function, about, A.3.14
REPLACE string function, about, A.3.15
replying to comments in scorecards, 12.46
repository variables, 2.16.2
results
adding views to, 3.4
drilling in, C.3
exporting and copying, C.1
refreshing in views, 3.16
results of analyses, 2.8, 2.8.2
RIGHT string function, about, A.3.16
RMAX running aggregate function, about, A.2.2.5
RMIN running aggregate function, about, A.2.2.6
ROUND math function, about, A.4.21
RSS Feed, 8.19
RSUM running aggregate function, about, A.2.2.3
running actions in dashboards, C.5
running aggregate functions
about, A.2.2
MAVG, A.2.2.1
MSUM, A.2.2.2
RCOUNT, A.2.2.4
RMAX, A.2.2.5
RMIN, A.2.2.6
RSUM, A.2.2.3

S

saved customizations
about, 4.14
applying, 4.16
editing, 4.17
saving
agents, 8.10
analyses, 2.11
customizations, 4.15
dashboards, 4.12
inline actions to the catalog, 10.28, 10.29
objects, 13.3
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.40
contacting business owners of, 12.43
deleting, 12.39, 12.39
editing, 12.38
scorecards
about comments, 12.44
about creating, 12.5
about overriding statuses, 12.41
adding comments to, 12.45
creating, 12.8
defining assessment mappings, 12.25
displaying comments in, 12.47
replying to comments in, 12.46
scrolling in graphs, C.8
search functionality, providing to end users, 13.7
searching
about, 13.4
results, 13.6
the Oracle BI Presentaton Catalog, 13.5
searching the Oracle BI Presentaton Catalog, 13.8
SECOND calendar date/time function, about, A.5.16
section sliders, 3.5.9.5, C.6
security, 13.12
SELECT statement
about and basic syntax, A.1.1
conditional expressions, A.1.4
GROUP BY clause syntax, A.1.1.7
mathematical operators, A.1.3.2
ORDER BY clause syntax, A.1.1.8
select list syntax, A.1.1.4
SQL logical operators, A.1.3.1
subquery support, A.1.1.3
usage notes, A.1.1.2
WHERE clause syntax, A.1.1.6
SELECT_PHYSICAL statement
about and basic syntax, A.1.2
aggregate functions not supported in, A.1.2.2
queries supported by, A.1.2.3
usage notes, A.1.2.5
using the NATURAL_JOIN keyword, A.1.2.4
selection steps
about, 5.2
and column prompts, 6.8
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, E.2
siging in to Oracle BI Enterprise Edition, 1.3
SIGN math function, about, A.4.22
signing out of Oracle BI Enterprise Edition, 1.3
SIN math function, about, A.4.23
skip-level hierarchy, 2.2.1
sorting
clearing, 3.9.4
data in views, 3.9
values, C.2
sorting data, 3.9.3
SPACE string function, about, A.3.17
SQL functions
aggregate functions, about, A.2.1
calendar date/time functions, about, A.5
conversion functions, about, A.6
database functions, about, A.7
expressing literals, A.1.5
math functions, about, A.4
running aggregate functions, about, A.2.2
string functions, about, A.3
system functions, about, A.8
time series functions, about, A.2.3
SQL operators, A.1.3
SQL statements, 5.9
SQL syntax and semantics
conditional expressions, A.1.4
FROM clause syntax, about, A.1.1.5
GROUP BY clause syntax, about, A.1.1.7
including and setting variables, A.1.6
ORDER BY clause syntax, about, A.1.1.8
Select list syntax, A.1.1.4
Select statement, about and basic syntax, A.1.1
Select usage notes, A.1.1.2, A.1.1.3
SQL logical operators, A.1.3.1, A.1.3.2
WHERE clause syntax, about, A.1.1.6
SQRT math function, about, A.4.24
status overrides, 11.10, 12.41
STDDEV aggregate function, about, A.2.1.14
STDDEV_POP aggregate function, about, A.2.1.15
strategy maps
about, 12.30
creating, 12.31
strategy trees
about, 12.28
creating, 12.29
string functions
about, A.3
ASCII, A.3.1
BIT_LENGTH, A.3.2
CHAR, A.3.3
CHAR_LENGTH, A.3.4
CONCAT, A.3.5
EXP, A.4.10
INSERT, A.3.6
LEFT, A.3.7
LENGTH, A.3.8
LOCATE, A.3.9
LOCATEN, A.3.10
LOWER, A.3.11
OCTET_LENGTH, A.3.12
POSITION, A.3.13
REPEAT, A.3.14
REPLACE, A.3.15
RIGHT, A.3.16
SPACE, A.3.17
SUBSTRING, A.3.18
TRIMBOTH, A.3.19
TRIMLEADING, A.3.20
TRIMTRAILING, A.3.21
UPPER, A.3.22
subject areas, 2.2
subscriptions
customizing agent, 8.14
to agents, 8.11
SUBSTRING string function, about, A.3.18
SUM aggregate function, about, A.2.1.16
SUMDISTINCT aggregate function, about, A.2.1.17
syntax for referencing variables, 2.18
system functions
about, A.8
DATABASE, A.8.2
USER, A.8.1
system requirements, 1.14

T

table views, modifying data, C.10
tables
and write back, 3.6.4
editing, 3.5.1
TAN math function, about, A.4.25
tasks for objects, 13.9
time series functions
about, A.2.3
AGO, A.2.3.1
PERIODROLLING, A.2.3.2
TODATE, A.2.3.3
TIMESTAMPADD calendar date/time function, about, A.5.17
TIMESTAMPDIFF calendar date/time function, about, A.5.18
TO_DATETIME conversion function, about, A.6.3
TODATE time series function, about, A.2.3.3
TOPN aggregate function, about, A.2.1.18
TRIMBOTH string function, about, A.3.19
TRIMLEADING string function, about, A.3.20
TRIMTRAILING string function, about, A.3.21
TRUNCATE math function, about, A.4.26
types
of actions, 10.3
of funnel graphs, 3.2.2
of gauges, 3.2.3
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
upgrade considerations, Preface
UPPER string function, about, A.3.22
USER system function, about, A.8.1
users
acting for, 1.10
users, acting for, 1.9
using dashboards, 4.13

V

VALUEOF conversion function, about, A.6.4
variable prompts
about, 6.3
creating or editing, 6.11
variables
about, 2.16
including and setting in SQL, A.1.6
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.7
viewing
metadata information, 2.7.3
summaries of agent settings, 8.9
views
about, 3.1
adding and rearranging columns in, 3.5.9.2
adding to results of analyses, 3.4
and drop targets, 3.5.9.1
and master-detail linking, 3.18
customizing, 3.16
detail, 3.18.2, 3.19.2
drilling in, 3.8
editing, 3.5
editing column selector, 3.5.6
editing gauge, 3.5.3
editing graph, 3.5.2
editing legend, 3.5.8
editing map, 3.5.4
editing narrative, 3.5.5
editing table and pivot table, 3.5.1
editing view selector, 3.5.7
interactions in, 3.7
linking in master-detail relationships, 3.19
master, 3.18.1, 3.19.1
modes for write back, 3.6.5
modifying the layout of data, 3.5.9
previewing, 3.14
printing, 3.12
rearranging, 3.11
refreshing the results in, 3.16
saving, 3.10
setting properties for view bodies and drop targets, 3.5.9.3
sorting data in, 3.9
types of, 3.2
working with linked, C.9
views, removing, 3.15
vision statements
about, 12.10
defining, 12.11

W

WEEK_OF_QUARTER calendar date/time function, about, A.5.19
WEEK_OF_YEAR calendar date/time function, about, A.5.20
weights, assigning in scorecards, 12.24
WHERE clause syntax, about, A.1.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

Y

YEAR calendar date/time function, about, A.5.21

Z

zooming in graphs, C.8
  Previous
Previous 
  Go To Table Of Contents
Contents