accounts dimensions
adding
joins by inspection in minischema
aggregate storage
alias sets
bindings
aliases
Integration Services catalog migration
applications
arranging tables in minischema work area
associating drill-through reports with Essbase models
Attribute Calculations Dimension
attribute calculations member names format
attribute calculations overview
attributes
differences in handling between Essbase Studio and Integration Services
bindings
creating in alias sets by inspection
creating manually in alias sets
calculation solve order
calendar hierarchies
catalog. See catalog database
catalog database
server.properties file, use of
catalog export
exporting the entire catalog database
exporting the selected catalog elements
catalog import
importing the catalog XML file
catalog migration. See Integration Services catalog migration
clearing cube deployment history
column data type
column ordering for drill-through reports
columns
names in first row
relational source for metadata elements
represented by metadata elements
viewing in Data Source Navigator
viewing properties
Common Platform Language. See CPL
configuring
Essbase Studio server startup file
Connection Wizard
connections. See data source connections
consolidation of children members
copying
CPL
expression
expressions
SQL functions
creating
bindings in alias sets by inspection
bindings in alias sets manually
for Oracle BI EE sources in Connection Wizard
data source connections
for Performance Management Architect sources
dimensions
for Oracle BI EE sources in Connection Wizard
Essbaes models
for Oracle BI EE sources in Connection Wizard
Essbase models
metadata elements
for Performance Management Architect sources in Connection Wizard
for relational sources in Connection Wizard
for text file sources in Connection Wizard
metadata elements from objects
rules file during cube deployment
cube deployment
data source setting information
deleting
incremental load
selecting dimensions and members
model properties
providing information, (1), (2)
rejected records, setting during cube deployment
streaming mode option in Cube Deployment Wizard
cube linkage
preliminary steps for individual cubes
cube schemas
creating an Essbase model in Cube Schema Wizard
creating Essbase models from existing
hierarchies
specifying the accounts dimension
custom data load settings
customizing
data load bindings in cube schemas
data load mappings in cube schemas
data load options for cube deployment
data load SQL
data source connections
creating
cube schema for Oracle BI EE sources
dimensions for Oracle BI EE sources
Essbase model for Oracle BI EE sources
for Performance Management Architect sources
metadata elements for Performance Management Architect sources
metadata elements for relational sources
metadata elements for text file sources
minischema for relational sources
for Performance Management Architect sources
populating a minischema
selecting
minischema option for text file sources
skipping a minischema
user-defined tables
viewing
properties of source tables and columns
statement of user-defined table
Data Source Navigator
data sources
data storage method
databases
defining
connection parameters for Essbase
data load bindings in cube schemas
data load mappings in cube schemas
data source connection parameters
for Performance Management Architect sources
drill-through report type for relational sources
Template SQL for drill-through reports
delayed key binding columns in hierarchies
deleting
data source connections, (1), (2)
data source connections, tables from
tables from data source connections
deleting members during cube deployment
derived text measures
dimension
creating
dimension elements
creating
editing
dimensions
user-defined attributes, assigning
Drill-through Report Properties dialog box
drill-through reports
associating with Essbase models
customizing for relational source
Drill-through Report Properties dialog box
example, testing the advanced option
example, testing the delayed option
intersection levels, specifying
report type, defining for relational source
row governors, defining for relational sources
Sample FDM URL Template, (1), (2)
Sample OBI EE URL Template, (1), (2)
specifying filters for relational sources
testing for relational sources
duplicate member names
duplicate member settings, moving
dynamic calc
editing
accounts, dimension properties
data source connection properties
minischemas
Essbase model preferences, setting
Essbase model properties
Essbase models
associating drill-through reports
attributes
calculation member name format
columns
creating from existing cube schemas
dimensions
duplicate member names, enabling
duplicate member settings, moving
formulas
members
skip option
time balance
variance reporting method
Essbase Server
about updating references after rehosting
updating references after rehosting
Essbase Studio
server. See Essbase Studio server
Essbase Studio Console
reconnecting to Essbase Studio Server
Essbase Studio Server
commands
reconnecting from Essbase Studio Console
Essbase Studio server startup file
Essbase Studio server startup file, configuring
Essbase, creating connections to
example drill-through testing for advanced option element
example drill-through testing for delayed option element
example drill-through testing scenarios
Excel files as data source
exporting
fact table
creating
facts
FDM URL drill-through report target, (1), (2)
filters
introspection
specifying in drill-through reports for relational sources
find and search
finding. See also searching
flat file sources
formulas
hierarchies
calendar
determining structure of Essbase models
examples
multichain with attribute dimensions
manufacturing calendar, creating
multichain with attribute dimensions
importing
incremental update
existing relational data source
existing text file data source
independent dimension bindings
integer constant (CPL expression)
Integration Services catalog migration
intersection levels
specifying in drill-through reports
introspection
performing on existing data source
selecting
laying out tables in minischema work area
limitations
accessing Essbase Studio Server
adding physical table to minischema
drill-through reports, (1), (2)
transforming members from text file sources
lineage
work area
linked value attributes in hierarchies
load options for cube deployment
logging
manufacturing calendar hierarchies
maximizing the minischema work area
MaxL script, saving cube deployment options as
measure hierarchies
measures
members
aggregate storage with label only option
consolidation methods for children
history table for varying attributes
names, changing and reformatting
placing actual members before shared members
setting attribute calculations member names format
varying attributes and history table
metadata elements
for Performance Management Architect sources
metadata folders
Metadata Navigator
migrating
migration. See Integration Services catalog migration
minimizing the minischema work area
Minischema Work Area. See Work Area
arranging tables in minischema work area
setting general properties for
creating for relational sources in Connection Wizard
editing
laying out tables in minischema work area
metadata elements, creating from minischema objects
modeling text file sources in Connection Wizard
options
for relational sources in Connection Wizard
for text file sources in Connection Wizard
populating
for relational sources in Connection Wizard
for text file sources in Connection Wizard
selecting option for text file sources
selecting options in Connection Wizard
skipping
for relational sources in Connection Wizard
for text file sources in Connection Wizard
model resync
modeling text file data sources
modifying. See editing
multichain hierarchies with attribute dimensions
multichain hierarchies with shared members. See alternate hierarchies
OBI EE. See also Oracle BI EE
OBI EE URL drill-through report target, (1), (2)
OLAP
use with multidimensional databases
opening
operators
Oracle BI EE
creating a cube schema in Connection Wizard
creating an Essbase model in Connection Wizard
creating dimensions in Connection Wizard
Oracle Diagnostic Logging (ODL)
Oracle users
parent-child hierarchies. See recursive hierarchies
Performance Management Architect sources
creating metadata elements for
defining connection parameters for
permissions
preferences
prefixes
previewing
sample data for dimension elements
properties
editing data source connection
rebuilding Essbase models, guidelines for
reconnecting to Essbase Studio Server
records rejected during cube deployment, setting
refreshing
rehosting
about updating references to Essbase Server
updating references to EPM System products
updating references to Essbase Server
reinit command
rejected records, setting during cube deployment
relational source columns, viewing properties
relational source tables, viewing properties
relational sources
creating
defining connection parameters for
renaming
restricted characters in names
reversing position of shared and actual members
sample data
viewing for dimension elements
Sample FDM URL Template for drill-through reports, (1), (2)
Sample OBI EE URL Template for drill-through reports, (1), (2)
Sample URL Template for drill-through reports, (1), (2)
saving
dimension
user-defined attributes in dimensions
scheduling options for cube deployment
schema. See minischemas
scraping. See introspection.
search rules
searching. See also finding
server properties file. See server.properties
server.essbase.disableDistinct
server.essbase.disableDistinct, IBM DB2 limitation, (1), (2)
server.essbase.streamingCubeBuilding
server.essbase.uniqueMemberFromCaptionBinding
server.properties
<data-source-type>.pool.maxsize
examples
list of configurable properties
server.essbase.disableDistinct
server.essbase.streamingCubeBuilding
server.essbase.uniqueMemberFromCaptionBinding
setting
settings
rejected records during cube deployment
shared member handling, (1), (2)
shared members, placing actual members before
skip option
sorting
dimension elements in alias sets
source tables and columns, viewing properties
specifying
column ordering for drill-through reports
drill-through report filters for relational sources
intersection levels in drill-through reports
member properties in Essbase models
row governors for relational sources
SQL functions. See CPL SQL functions
streaming mode
setting in Cube Deployment Wizard
string constant (CPL expression)
suffixes
support
tables
adding a subset in Connection Wizard
creating metadata elements from
removing from minischema, (1), (2)
selecting relational tables in Connection Wizard
user-defined, viewing properties
user-defined, viewing statements
Template SQL, defining for drill-through reports
testing
drill-through reports for relational sources
drill-through reports, advanced option example
drill-through reports, delayed option example
drill-through reports, example scenarios
text file source columns, viewing properties
text file source files, viewing properties
text file sources
columns, viewing properties of
creating metadata elements for
defining connection parameters for
source files, viewing properties of
three level database (CPL expression)
time balance
time hierarchies built from DATE element
time zone configuration issue
Essbase Studio server startup file
two level database (CPL expression)
two pass calculation
UMC. See updating cube linkage
upgrading
data source connection properties, post-migration
Essbase connection properties, post-migration
URL drill-through report target, (1), (2)
user-defined attributes
user-defined source columns, viewing properties
user-defined tables
variance reporting method
varying attributes
independent dimension bindings, defining
independent dimension bindings, limitations
redefining after export/import
viewing
maximizing the minischema work area
minimizing the minischema work area
minischemas
sample data for dimension elements
virtual memory