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