Skip Headers
Oracle® Fusion Middleware Data Modeling Guide for Oracle Business Intelligence Publisher
11g Release 1 (11.1.1)

Part Number E22258-02
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  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