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, entry

access control lists, entry

accessibility

about, entry

designing for, entry

using objects to enhance, entry

accessing favorites list, entry

ACOS math function, about, entry

acting for other users, entry, entry

action link menus

about, entry

adding to dashboard pages, entry, entry

editing on dashboard pages, entry

action links, entry

about, entry

adding to dashboard pages, entry, entry

editing on dashboard pages, entry

action parameters, entry

actions

about, entry

about adding, entry

about conditionally enabling, entry

about inline, entry

about named, entry

about running, entry

adding to agents, entry

adding to analyses, entry

adding to dashboard pages, entry, entry, entry

adding to initiatives and objectives, entry

adding to KPIs, entry

and displaying information to users, entry

and parameters, entry

creating from existing actions, entry

creating named, entry

editing named, entry

editing on agents, entry

editing on analyses, entry

editing on dashboard pages, entry

editing on initiatives and objectives, entry

editing on KPIs, entry

executing named, entry

running in dashboards, entry

saving inline to the catalog, entry, entry

specifying settings for, entry

types, entry

upgrading from previous releases, entry

actual and target values

changing, entry, entry

adding

a list of briefing books to dashboard pages, entry

actions to agents, entry

actions to analyses, entry

actions to dashboard pages, entry, entry, entry

actions to initiatives and objectives, entry

actions to KPIs, entry

content to briefing books, entry

content to dashboards, entry

dashboard prompts to dashboards and dashboard pages, entry, entry

favorites to list, entry

groups to analyses, entry

new pages to dashboards, entry

Oracle BI Publisher reports to dashboard pages, entry

prompts to analyses, entry

scorecard objects to dashboards, entry

views to results of analyses, entry

Agent editor, entry

agent subscriptions, customizing, entry

agents

about, entry

accessing and managing alerts, entry

adding actions, entry

and alerts, entry

and devices and delivery profiles, entry, entry

and displaying a list of subscriptions, entry

and how they work, entry

controlling access to, entry

creating, entry

creating from analyses, entry

creating from KPIs, entry

customizing subscriptions to, entry

editing actions, entry

saving, entry

subscribing to, entry

unsubscibing from, entry

using conditions in, entry, entry

using customization in, entry

using to deliver briefing books, entry

viewing summaries, entry

agents' schedules, disabling and enabling, entry

AGGREGATE AT aggregate function, about, entry

aggregate functions

about, entry, entry, entry

AGGREGATE AT, entry

AVG, entry

AVGDISTINCT, entry

BOTTOMN, entry

COUNT, entry

COUNT (*), entry

COUNTDISTINCT, entry

MAX, entry

MEDIAN, entry

MIN, entry

NTILE, entry

PERCENTILE, entry

RANK, entry

STDDEV, entry

STDDEV_POP, entry

SUM, entry

SUMDISTINCT, entry

TOPN, entry

AGO time series function, about, entry

alerts

about, entry

accessing and managing, entry

subscribing to RSS Feed, entry

analyses

about, entry

adding actions, entry

adding groups, entry

adding prompts, entry

and logical SQL statements, entry

and no data results, entry

applying named filters to, entry

creating, entry

creating agents from, entry

creating using BI Composer, entry, entry

displaying the results, entry

editing, entry

editing actions, entry

editing using BI Composer, entry, entry

embedding in dashboards, entry

formatting columns, entry

generating from KPIs, entry

modifying data in table views, entry

process for constructing, entry

saving, entry

specifying the criteria, entry

using as filters, entry

viewing using BI Composer, entry

Analysis editor, entry

applying

conditional formatting, entry

saved customizations, entry

applying formats to layers, entry

archiving

about, entry

objects, entry

ASCII string function, about, entry

ASIN math function, about, entry

assessment mappings, entry, entry, entry

assigning

ownership of objects, entry

permissions, entry

weights in scorecards, entry

ATAN math function, about, entry

ATAN2 math function, about, entry

attribute columns, entry

auto-complete for prompts, entry

availability of BI Composer, entry

AVG aggregate function, about, entry

AVGDISTINCT aggregate function, about, entry

B

Balanced Scorecard, entry

basic search

about, entry

Between SQL logical operator, about, entry

BI Composer

about, entry

availability, entry

creating analyses, entry, entry

editing analyses, entry, entry

installing and configuring, entry

viewing analyses, entry

BIT_LENGTH string function, about, entry

bookmark links, entry

BOTTOMN aggregate function, about, entry

breadcrumbs

about, entry

briefing books

about, entry

adding a list of to dashboard pages, entry

adding content to, entry

downloading, entry

editing, entry

using agents to deliver, entry

business owners, entry, entry

C

calculated items

about, entry

creating, entry

editing, entry

nesting, entry

calculation scripts

for target settings, entry

calendar date/time functions

about, entry

CURRENT_DATE, entry

CURRENT_TIME, entry

CURRENT_TIMESTAMP, entry

DAY_OF_QUARTER, entry

DAYNAME, entry

DAYOFMONTH, entry

DAYOFWEEK, entry

DAYOFYEAR, entry

HOUR, entry

MINUTE, entry

MONTH, entry

MONTH_OF_QUARTER, entry

MONTHNAME, entry

NOW, entry

QUARTER_OF_YEAR, entry

SECOND, entry

TIMESTAMPADD, entry

TIMESTAMPDIFF, entry

WEEK_OF_QUARTER, entry

WEEK_OF_YEAR, entry

YEAR, entry

CASE (If) conditional expression, about, entry

CASE (Switch) conditional expression, about, entry

CAST conversion function, about, entry

catalog

See Oracle BI Presentation Catalog

cause & effect maps

about, entry

creating, entry

opening, entry

CEILING math function, about, entry

certification, entry

changing

dashboard properties, entry

properties of objects, entry

changing target values, entry, entry

channels, entry

CHAR string function, about, entry

CHAR_LENGTH string function, about, entry

character literals, about, entry

clearing

customizations, entry

sorts, entry

code columns, entry

column filters

combining and grouping, entry

creating, entry

creating and editing SQL statements, entry

editing, entry

column formulas, entry

column prompts

about, entry

and selection steps, entry

creating, entry

column selector views, editing, entry

columns

about, entry

adding and rearranging in views, entry

and visual indications, entry

and write back, entry

code, entry

combining using the Set operation, entry

display, entry

double, entry

drilling in, entry

editing the formula, entry

formatting, entry

renamed columns and dashboard prompts, entry

types of, entry

comments, entry, entry

components of map views, entry

compound layouts, entry

CONCAT string function, about, entry

conditional expressions

about, entry

CASE (If), about and syntax, entry

CASE (Switch), about and syntax, entry, entry

conditional formatting, entry

conditionally enabling actions, entry

conditions

about, entry

about inline, entry

about named, entry

creating named, entry

editing named, entry

elements of, entry

specifying settings, entry

using, entry

using in agents, entry, entry

using in dashboard pages, entry, entry, entry, entry

configuring drilling, entry

contacting business owners, entry, entry

content

adding to briefing books, entry

adding to dashboards, entry

contribution wheel diagrams, entry

conversion functions

about, entry

CAST, entry

IFNULL, entry

TO_DATETIME, entry

VALUEOF, entry

copying results, entry

COS math function, about, entry

cosmetic formatting, entry

COT math function, about, entry

COUNT aggregate function, about, entry

COUNT(*) aggregate function, about, entry

COUNTDISTINCT aggregate function, about, entry

creating

additional compound layouts, entry

agents, entry

agents from analyses, entry

agents from KPIs, entry

analyses, entry

analyses using BI Composer, entry, entry

calculation scripts, entry

column filters, entry

column prompts, entry

currency prompts, entry

dashboard template pages, entry

dashboards, entry

image prompts, entry

KPI watchlists, entry

KPIs, entry

links to dashboard pages, entry

map views, entry

named actions, entry

named conditions, entry

new actions from existing actions, entry

scorecards, entry

selection steps, entry

variable prompts, entry

currency prompts

about, entry

creating, entry

CURRENT_DATE calendar date/time function, about, entry

CURRENT_TIME calendar date/time function, about, entry

CURRENT_TIMESTAMP calendar date/time function, about, entry

custom date and time format strings, entry

custom views

about, entry

creating, entry

opening, entry

customizations

clearing, entry

saving, entry

customize global header, entry

customizing views, entry

D

Dashboard builder, entry

dashboard pages

about creating links to, entry

adding a list of briefing books, entry

adding actions, entry, entry, entry

adding dashboard prompts, entry, entry

adding Oracle BI Publisher reports, entry

and saved customizations, entry

changing properties of objects, entry

creating links to, entry

deleting, entry

deleting objects, entry

displaying map views, entry

editing actions, entry

modifying data in table views, entry

publishing, entry

using conditions in, entry, entry, entry, entry

working with map views, entry

dashboard prompts

about, entry

adding dashboards and dashboard pages, entry, entry

dashboard template pages

about, entry

creating, entry

dashboards

about, entry

accessing Oracle BI Publisher reports, entry

adding content, entry

adding dashboard prompts, entry, entry

adding new pages, entry

adding scorecard objects, entry

changing properties, entry

controlling the look of, entry

creating, entry

editing, entry

embedding analyses, entry

opening and using, entry

renamed columns and dashboard prompts, entry

running actions, entry

saving, entry

data

sorting, entry

sorting in views, entry

working with selections of, entry

database functions

about, entry

EVALUATE, entry

EVALUATE_AGGR, entry

EVALUATE_ANALYTIC, entry

EVALUATE_PREDICATE, entry

DATABASE system function, about, entry

DATE data type, changing to, entry

datetime literals, about, entry

DAY_OF_QUARTER calendar date/time function, about, entry

DAYNAME calendar date/time function, about, entry

DAYOFMONTH calendar date/time function, about, entry

DAYOFWEEK calendar date/time function, about, entry

DAYOFYEAR calendar date/time function, about, entry

decimal literal, about, entry

defining

assessment mappings for scorecards, entry

detail views, entry

master views, entry

sections sliders, entry

DEGREES math function, about, entry

deleting

dashboard pages, entry

objects on dashboard pages, entry

scorecard objects, entry, entry

delivery profiles

about, entry

configuring, entry

designing for accessibility, entry

detail views

about, entry

defining, entry

devices

about, entry

configuring, entry

dimensions, entry

direct database requests, entry

disabling agents' schedules, entry

display columns, entry

displaying

map views on dashboards, entry

results of analyses, entry

double columns

about, entry

and selections steps, entry

downloading briefing books, entry

drilling

configuring, entry

effects on filters and selection steps, entry

in columns, entry

in results, entry

in views, entry

drop targets, entry

E

edit mode in the Scorecard editor, entry

editing

actions added to agents, entry

actions added to analyses, entry

actions added to initiatives and objectives, entry

actions added to KPIs, entry

actions on dashboard pages, entry

analyses, entry

analyses using BI Composer, entry, entry

briefing books, entry

column filters, entry

column selector views, entry

dashboards, entry

gauges, entry

graphs, entry

KPI watchlists, entry

KPIs, entry

legend views, entry

map views, entry, entry

named actions, entry

named conditions, entry

narrative views, entry

pivot tables, entry

prompts, entry

saved customizations, entry

scorecard objects, entry

selection steps, entry

tables, entry

view selector views, entry

views, entry

elements of conditions, entry

embedding

analyses in dashboards, entry

enabling

actions conditionally, entry

agents' schedules, entry

EVALUATE database function, about, entry

EVALUATE_AGGR database function, about, entry

EVALUATE_ANALYTIC database function, about, entry

EVALUATE_PREDICATE database function, about, entry

EVALUATE_PREDICATE Function, entry

executing named actions, entry

EXP math function, about, entry

exporting

reports, KPIs, and analysis prompts data, entry

results, entry

expression literals

character literals, about and expressing, entry

decimal, about and expressing, entry

integers, about and expressing, entry

EXTRACTBIT math function, about, entry

F

favorites

about, entry

accessing favorites list, entry

adding, entry

organizing, entry

removing, entry

filters

about, entry

and drilling, entry

applying named to analyses, entry

combining and grouping column, entry

creating and editing SQL statements, entry

using saved analyses, entry

floating point literal, about, entry

FLOOR math function, about, entry

format and layers in map views, entry

formatting

about, entry

applying conditional, entry

columns in analyses, entry

cosmetic, entry

custom date and time format strings, entry

formulas,editing, entry

FROM clause syntax, about, entry

full-text search

about, entry

Oracle Endeca Server integration, entry

Oracle Secure Enterprise Search integration, entry

results, entry

searching with, entry

functions

EVALUATE_PREDICATE, entry

functions of map views, entry

funnel graphs, types of, entry, entry

G

gauges

defining section sliders for, entry

editing, entry

types of, entry

generating analyses from KPIs, entry

glob syntax, entry

global header, entry

graphs

defining section sliders for, entry

editing, entry

types of, entry

zooming and scrolling, entry

GROUP BY clause

syntax, about, entry

group objects, entry

groups

about, entry

adding to analyses, entry

creating, entry

editing, entry

nesting, entry

H

hidden dashboards

upgrading from previous releases, entry

hierarchical columns, entry

Home page, entry

HOUR calendar date/time function, about, entry

I

IFNULL conversion function, about, entry

image prompts

about, entry

creating, entry

In SQL logical operator, about, entry

initiatives

about, entry

adding actions to, entry

and performance assessment, entry

creating, entry

editing actions in, entry

opening, entry

inline actions

about, entry

saving to the catalog, entry, entry

inline conditions, entry

inline objects, entry

inline prompts, entry

INSERT string function, about, entry

integers literals, about, entry

integrating with Microsoft Office, entry

integration

Oracle Endeca Server, entry

Oracle Secure Enterprise Search, entry

interaction of prompts, entry

interactions in views, entry

Is Null SQL logical operator, about, entry

K

Key Performance Indicators

See KPIs

keyboard shortcuts, entry

KPI details in scorecards, entry

KPI watchlists

about, entry

creating, entry

editing, entry

opening, entry

KPIs

about, entry

about adding comments, entry

about overriding statuses, entry

about usage of, entry

adding actions, entry

adding target settings, entry

and dimensions, entry

and evaluation, entry

contacting business owners, entry

creating, entry

creating an agent from, entry

editing, entry

editing actions in, entry

generating analyses from, entry

opening, entry

L

layers

about, entry

and formats, entry

applying formats to, entry

LEFT string function, about, entry

legend views, editing, entry

LENGTH string function, about, entry

level-based hierarchy, entry

Like SQL logical operator, about, entry

linked views, entry

linking views, entry

links

bookmark, entry

creating to dashboard pages, entry

prompted, entry

list

favorites list, entry

literals, in SQL, entry

LOCATE string function, about, entry

LOG math function, about, entry

LOG10 math function, about, entry

logical operators, entry

logical SQL statements, entry

Logical SQL, about, entry

LOWER string function, about, entry

M

map views

about layers, entry

and applying formats to layers, entry

components of, entry

creating, entry

editing, entry

editing and displaying on dashboard pages, entry

formats and layers in, entry

functions of, entry

terms used in, entry

working with on dashboard pages, entry

master detail linking, entry

master views

about, entry

defining, entry

master-detail linking

about, entry

channels, entry

detail views, entry, entry

how it works, entry

master views, entry, entry

math functions

about, entry

ABS, entry

ACOS, entry

ASIN, entry

ATAN, entry

ATAN2, entry

CEILING, entry

COS, entry

COT, entry

DEGREES, entry

EXTRACTBIT, entry

FLOOR, entry

LOG, entry

LOG10, entry

MOD, entry

PI, entry

POWER, entry

RADIANS, entry

RAND, entry

RANDFROMSEED, entry

ROUND, entry

SIGN, entry

SIN, entry

SQRT, entry

TAN, entry

TRUNCATE, entry

mathematical operators, about, entry

MAVG running aggregate function, about, entry

MAX aggregate function, about, entry

measure columns, entry

MEDIAN aggregate function, about, entry

metadata information, entry

Microsoft, integrating with, entry

MIN aggregate function, about, entry

MINUTE calendar date/time function, about, entry

mission statements

about, entry

defining, entry, entry

opening, entry

MOD math function, about, entry

modes

for Scorecard, entry

for write back, entry

modifying target values, entry, entry

modifying the layout of data in views, entry

MONTH calendar date/time function, about, entry

MONTH_OF_QUARTER calendar date/time function, about, entry

MONTHNAME calendar date/time function, about, entry

MSUM running aggregate function, about, entry

N

named actions

about, entry

creating, entry

creating from existing actions, entry

editing, entry

executing, entry

named conditions

about, entry

creating, entry

editing, entry

named filters, applying to analyses, entry

named objects, entry

narrative views, editing, entry

NATURAL_JOIN keyword, using in SELECT_PHYSICAL statements, entry

navigating Oracle BI Enterprise Edition, entry

navigating with breadcrumbs, entry

nesting groups and calculated items, entry

no data results, entry

NOW calendar date/time function, about, entry

NTILE aggregate function, about, entry

numeric literals, about, entry

O

objectives

about, entry

adding actions to, entry

and performance assessment, entry

creating, entry

editing actions in, entry

opening, entry

objects

accessing properties of, entry

archiving, entry

assigning ownership to, entry

assigning permissions to, entry

basic search, entry

changing properties of, entry

deleting from dashboard pages, entry

full-text search, entry

inline, entry

named, entry

ownership of, entry

saving, entry

taking ownership of, entry

tasks for, entry

using to enhance accessibility, entry

OCTET_LENGTH string function, about, entry

opening

dashboards, entry

scorecard objects, entry

operators, in SQL, entry

Oracle BI Enterprise Edition

and other products, entry

getting Help, entry

global header, entry

Home page, entry

introduction to, entry

navigating, entry

setting preferences for, entry

signing in, entry

signing out, entry

system requirements and certification, entry

Oracle BI Presentation Catalog

about, entry

basic search, entry

full-text search, entry

Oracle BI Publisher reports

accessing in dashboards, entry

adding to dashboard pages, entry

Oracle Endeca Server integration, entry

Oracle Scorecard and Strategy Management

about, entry

troubleshooting, entry

Oracle Secure Enterprise Search integration, entry

ORDER BY clause syntax, entry

organizing favorites, entry

overriding statuses, entry, entry, entry

ownership of objects, entry, entry, entry

P

parent-child hierarchy, entry

PERCENTILE aggregate function, about, entry

performance assessment of initiatives and objectives, entry

performance tile, entry

PERIODROLLING time series function, about, entry

permissions

about, entry

and access control lists, entry

and object assignments, entry

assigning, entry

availability by object type, entry

definitions, entry

recommendations for setting, entry

perspectives

about, entry

creating, entry

PI math function, about, entry

pinned dimension values, entry

pivot tables, editing, entry

point of view area, entry

point of view controls, entry

POSITION string function, about, entry

POWER math function, about, entry

preferences, setting for Oracle BI Enterprise Edition, entry

presentation variables, entry, entry

previewing views, entry

print options for views, entry

printing

options, entry

views, entry

process for write back, entry

prompted links, entry

prompts

about column, entry

about dashboard, entry

about inline, entry

adding dashboard prompts to dashboards and dashboard pages, entry, entry

adding to analyses, entry

and selections steps, entry

and the order applied, entry

auto-complete, entry

creating column prompt, entry

creating currency prompts, entry

creating image prompt, entry

creating variable prompts, entry

dashboard prompts and renamed columns, entry

editing, entry

interaction of, entry

types of, entry

types of user input options, entry

upgrading from previous releases, entry

properties

accessing object, entry

changing dashboard, entry

changing object, entry

publishing dashboard pages, entry

Q

QUARTER_OF_YEAR calendar date/time function, about, entry

R

RADIANS math function, about, entry

ragged hierarchy, entry

RAND math function, about, entry

RANDFROMSEED math function, about, entry

RANK aggregate function, about, entry

RCOUNT running aggregate function, about, entry

rearranging views, entry

referencing variables, entry

refreshing the results in views, entry

removing

views, entry

removing favorites, entry

REPEAT string function, about, entry

REPLACE string function, about, entry

repository variables, entry

results

adding views to, entry

drilling in, entry

exporting and copying, entry

refreshing in views, entry

results of analyses, entry, entry

RIGHT string function, about, entry

RMAX running aggregate function, about, entry

RMIN running aggregate function, about, entry

ROUND math function, about, entry

RSS Feed, entry

RSUM running aggregate function, about, entry

running actions in dashboards, entry

running aggregate functions

about, entry

MAVG, entry

MSUM, entry

RCOUNT, entry

RMAX, entry

RMIN, entry

RSUM, entry

S

saved customizations

about, entry

applying, entry

editing, entry

saving

agents, entry

analyses, entry

customizations, entry

dashboards, entry

inline actions to the catalog, entry, entry

objects, entry

objects as inline or named, entry

selection steps as a group object, entry

views, entry

Scorecard editor

about, entry

edit and view modes, entry

scorecard objects

about, entry

adding to dashboards, entry

contacting business owners of, entry

deleting, entry, entry

editing, entry

scorecards

about creating, entry

and assessment mappings, entry, entry

and assigning weights, entry

and comments, entry, entry

and overriding statuses, entry, entry

creating, entry

defining assessment mappings, entry

scrolling in graphs, entry

searching

about, entry

glob syntax, entry

results of full-text search, entry

the Oracle BI Presentation Catalog, entry

SECOND calendar date/time function, about, entry

section sliders, entry, entry

security, entry

SELECT statement

about and basic syntax, entry

conditional expressions, entry

GROUP BY clause syntax, entry

mathematical operators, entry

ORDER BY clause syntax, entry

select list syntax, entry

SQL logical operators, entry

subquery support, entry

usage notes, entry

WHERE clause syntax, entry

SELECT_PHYSICAL statement

about and basic syntax, entry

aggregate functions not supported in, entry

queries supported by, entry

usage notes, entry

using the NATURAL_JOIN keyword, entry

selection steps

about, entry

and column prompts, entry

and drilling, entry

editing, entry

saving as a group object, entry

selections of data, working with, entry

selections steps

and double columns, entry

creating, entry

session variables, entry

Set operation for columns, entry

setting preferences for Oracle BI Enterprise Edition, entry

shortcuts, keyboard, entry

siging in to Oracle BI Enterprise Edition, entry

SIGN math function, about, entry

signing out of Oracle BI Enterprise Edition, entry

SIN math function, about, entry

skip-level hierarchy, entry

smart watchlists

about, entry

creating, entry

sorting

clearing, entry

data in views, entry

values, entry

sorting data, entry

SPACE string function, about, entry

SQL functions

aggregate functions, about, entry

calendar date/time functions, about, entry

conversion functions, about, entry

database functions, about, entry

expressing literals, entry

math functions, about, entry

running aggregate functions, about, entry

string functions, about, entry

system functions, about, entry

time series functions, about, entry

SQL operators, entry

SQL statements, entry

SQL syntax and semantics

conditional expressions, entry

FROM clause syntax, about, entry

GROUP BY clause syntax, about, entry

including and setting variables, entry

ORDER BY clause syntax, about, entry

Select list syntax, entry

Select statement, about and basic syntax, entry

Select usage notes, entry, entry

SQL logical operators, entry, entry

WHERE clause syntax, about, entry

SQRT math function, about, entry

status overrides, entry, entry, entry

STDDEV aggregate function, about, entry

STDDEV_POP aggregate function, about, entry

strategy maps

about, entry

creating, entry

opening, entry

strategy tree diagrams, entry

strategy trees

about, entry

creating, entry

opening, entry

string functions

about, entry

ASCII, entry

BIT_LENGTH, entry

CHAR, entry

CHAR_LENGTH, entry

CONCAT, entry

EXP, entry

INSERT, entry

LEFT, entry

LENGTH, entry

LOCATE, entry

LOWER, entry

OCTET_LENGTH, entry

POSITION, entry

REPEAT, entry

REPLACE, entry

RIGHT, entry

SPACE, entry

SUBSTRING, entry

TRIMBOTH, entry

TRIMLEADING, entry

TRIMTRAILING, entry

UPPER, entry

subject areas, entry

subscriptions

customizing agent, entry

to agents, entry

SUBSTRING string function, about, entry

SUM aggregate function, about, entry

SUMDISTINCT aggregate function, about, entry

syntax for referencing variables, entry

system functions

about, entry

DATABASE, entry

USER, entry

system requirements, entry

T

table views, modifying data, entry

tables

and write back, entry

editing, entry

taking ownership of objects, entry

TAN math function, about, entry

target settings

adding to KPIs, entry

target values

changing, entry, entry

tasks for objects, entry

time series functions

about, entry

AGO, entry

PERIODROLLING, entry

TODATE, entry

TIMESTAMPADD calendar date/time function, about, entry

TIMESTAMPDIFF calendar date/time function, about, entry

TO_DATETIME conversion function, about, entry

TODATE time series function, about, entry

TOPN aggregate function, about, entry

TRIMBOTH string function, about, entry

TRIMLEADING string function, about, entry

TRIMTRAILING string function, about, entry

troubleshooting Oracle Scorecard and Strategy Management, entry

TRUNCATE math function, about, entry

types

of actions, entry

of funnel graphs, entry, entry

of gauges, entry

of graphs, entry

of prompts, entry

of user input options for prompts, entry

of views, entry

U

unsubscribing from agents, entry

upgrading

actions from previous releases, entry

hidden dashboards from previous releases, entry

prompts from previous releases, entry

UPPER string function, about, entry

USER system function, about, entry

users

acting for, entry

interacting with target settings, entry

users, acting for, entry

using dashboards, entry

V

VALUEOF conversion function, about, entry

variable prompts

about, entry

creating, entry

variables

about, entry

including and setting in SQL, entry

presentation, entry, entry

referencing, entry

repository, entry

session, entry

syntax for referencing, entry

view mode in the Scorecard editor, entry

view selector views, editing, entry

viewing

analyses using BI Composer, entry

metadata information, entry

summaries of agent settings, entry

views

about, entry

adding and rearranging columns in, entry

adding to results of analyses, entry

and drop targets, entry

and master-detail linking, entry

customizing, entry

detail, entry, entry

drilling in, entry

editing, entry

editing column selector, entry

editing gauge, entry

editing graph, entry

editing legend, entry

editing map, entry

editing narrative, entry

editing table and pivot table, entry

editing view selector, entry

interactions in, entry

linking in master-detail relationships, entry

master, entry, entry

modes for write back, entry

modifying the layout of data, entry

opening, entry

previewing, entry

printing, entry

rearranging, entry

refreshing the results in, entry

saving, entry

setting properties for view bodies and drop targets, entry

sorting data in, entry

types of, entry

working with linked, entry

views, removing, entry

vision statements

about, entry

defining, entry

opening, entry

W

watchlists

about, entry

KPI, entry

smart, entry

WEEK_OF_QUARTER calendar date/time function, about, entry

WEEK_OF_YEAR calendar date/time function, about, entry

weights, assigning in scorecards, entry

WHERE clause syntax, about, entry

write back

adding to columns, entry

adding to table views, entry

modes in views, entry

performing, entry

process for, entry

Y

YEAR calendar date/time function, about, entry

Z

zooming in graphs, entry