Index

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

A

ABS, 3.17

Actions menu

group, 3.6

aggregate elements

group level, 3.9

setting properties, 3.9

analysis

See Oracle BI analysis, 1.4

AVG, 3.17

B

backup data source

using for data model, 1.8

bind variables

adding, 2.3, 2.4.13

bursting

setting up, 7.3

bursting definition

defining for CLOB data set, 7.6

C

CEILING, 3.17

CLOB

adding bursting definitions for, 7.6

using as a data source, 2.12

code view, 3.3

CONCAT, 3.17

D

data model

component definitions, 1.2

data model editor

interface overview, 1.7

launching, 1.6

data sets

creating, 2.1

editing, 2.2

guidelines for multiquery data models, 3.1.3

linking, 3.4

supported types, 2.1

what is supported for each type, 1.4

data sources

supported types, 1.4

Database Fetch Size property, 1.8

DATE, 3.17

default data source property, 1.8

diagram view, 3.3

E

element properties

setting, 3.12

element-level links, 3.4.1

deleting, 3.5.1

elements

renaming, 3.16.1

Excel data source files

refreshing local files, 1.8.2.3

F

filters

creating for groups, 3.10

deleting, 3.10

editing, 3.10

find variables

user information, 2.15

FLOOR, 3.17

FORMAT_DATE, 3.17

FORMAT_NUMBER, 3.17

functions

element level, 3.11

global level, 3.15

reference, 3.17

G

global-level functions, 3.15

group filters

creating, 3.10

deleting, 3.10

editing, 3.10

group link

Actions menu, 3.6

group-level links, 3.4.2

creating, 3.6

deleting, 3.6.1

H

HTTP XML feed

creating data set from, 2.13

HTTP XML feed data sets

limitations on structuring, 2.13.1

I

INSTR, 3.17

L

LDAP

creating bind variables from user attributes, 2.15.2.1

using as data source, 2.6

LENGTH, 3.17

links

creating between data sets, 3.4

element-level, 3.4

group-level, 3.4

list of values

adding to data model, 4.4

M

master-detail links, 3.4

MAX, 3.17

MDX query

defining as a data set type, 2.5

Microsoft Excel

creating a data set based on, 2.7

data source from system directory, 2.7.3

deleting an uploaded data source file, 2.7.4.1

refreshing an uploaded data source file, 2.7.4.1

uploading a local file to use as a data source, 2.7.4

MIN, 3.17

multiquery data models

when to use, 3.1.3

N

null elements

setting value for, 3.16.2

NUMBER, 3.17

NVL, 3.17

O

OLAP data sources

limitations, 2.5

querying, 2.5

Oracle BI analysis

creating a data set, 2.8

limitations as data set, 2.8.1

Oracle DB Default Package property, 1.8

output view, 3.3

P

parameters

adding to data model, 4.1

date, 4.2.3

menu, 4.2.2

text, 4.2.1

parent-child groups

moving element between, 3.8

parent-child links, 3.4

PL/SQL

add element, 3.15

PL/SQL filters, 3.10

properties

aggregate elements, 3.9

setting, 1.8

properties pane, 1.7

Q

Query Builder

join conditions, 2.4.11.1

joining objects, 2.4.11.2

supported column types, 2.4.6

using, 2.4

R

renaming elements, 3.16.1

ROUND, 3.17

RSS feed

creating data set from, 2.13

S

Safari browser

limitations when viewing XML, 2.14

sample data

attaching to data model, 1.8.2.1

exporting, 2.14

generating and saving for a data model, 2.14

sorting

apply to group, 3.13

support, 3.13

SQL query

defining as data set, 2.3

editing, 2.4.14

STRING, 3.17

Structure view, 3.3, 3.16

subgroups

creating in data models, 3.7

removing, 3.7

SUBSTRING, 3.17

SUM, 3.17

system variables

including in a data model, 2.15

T

toolbar, 1.7

U

user ID

including in data model, 2.15

user information

including in data model, 2.15

user preferences

including in data model, 2.15

user roles

including in data model, 2.15

V

value if null, 3.16.2

view object

creating a data set from, 2.9

limitations as data set, 2.9.1

W

Web service

defining as data source, 2.10

limitations on structuring, 2.10.3

supported formats, 2.10

X

XML feed

creating data set from over HTTP, 2.13

XML file

using as a data source, 2.11

XML file data sets

limitations on structuring, 2.11.1

XML output

viewing from data model editor, 1.7

XML output options

setting, 1.8.1

XML tag display

setting upper or lower case, 1.8.1