54/54
Index
A
Abort recovery option
link
Abs function
link
accumulatedOrUpdate parameter
link link
active combination
link
active_forecasts_versions parameter
link link
Activity Browser
configuring
link
introduction
link
ACV data
link link
add_zero_combos_to_mdp parameter
link
AdditionalConnectionsExpression parameter
link
administration
data cleanup script
link
Administrative Utilities
link
Aggregated Base Level option
link
aggregated data, importing
link link
aggregation
backwards versus forwards
link
by base level
link
by item
link link
by promotion or by sales
link
by unlinked level
link
during forecasting
link
how controlled
link
introduction
link link
kinds of levels
link
SQL functions
link
aggri_98, aggri_99 data fields
link
alert phase of workflow step
link
align_sales_data_levels_in_loading parameter
link link link
ampersand, in Demantra Spectrum
link
Analytical Engine
and promotion status
link
and simulation within a workflow
link
batch or simulation
link
configuration settings
link
DP and PE modes
link
forecast tree
link
forecast versions
link
forecasting and coefficients
link
forecasting models and engine flow
link
overview
link
registering
link
running
workflow
link
running before using Promotion Optimization
link
use of promotion status
link
ANALYZE_SCHEMA procedure
link
API_ADD_ORA_DEM_LEVEL_FILTERS
link
API_CONFIG_SETTLEMENT procedure
link
API_CREATE_ORA_DEM_USER
link
API_MODIFY_INTEG_SERIES_ATTR
link
API_MODIFY_INTEG_SERIES_FDATE
link
API_MODIFY_INTEG_SERIES_RDATE
link
API_NOTIFY_APS_INTEGRATION
link
applet
installing
link link link link
version
link
Application Server
link
Application Server queue
link
Application upgrade
link
application_root parameter
link
applicationDateFormat parameter
link link
applicationDateTimeFormat parameter
link link
APPPROC_CDP_LAUNCH_MGMT_VIEWS procedure
link
APPPROC_REBUILD_CONTEXT_CACHES procedure
link
APPPROC_SET_POPULATION_DATES procedure
link
ApprovalProcessScope parameter
link
AppServerLocation parameter
link
AppServerURL parameter
link link
APS
configuration file
link
introduction
link
APS queue
link
APS.bat
and license
link
arguments
link
APSMode parameter
link link
Ask recovery option
link
associating
indicators with series
link link
levels and units of measure
link
levels and worksheets (for Open With)
link
series and series groups
link
series and users
link
units and levels
link
users and groups
link
associating levels and worksheets (for Open With)
link
asynchronous workflows
link
attribute
adding to level
link
and method execution
link
automatically creating as level
link
creating drop-down list
link
creating lookup level as attribute
link link
creating with the Data Model Wizard
link
displaying when method is completed
link
exporting value
link link
filtering drop-down list
link
introduction
link
making editable by users
link
passing to method
link
prompting user for value
link
specifying as input to workflow
link link
specifying default value
link
using within method
link link
attribute, population
adding to a level
link
loading
link
passing to method
link link
presentation styles in methods
link
specifying presentation style
link
table where stored
link
using to filter condition step
link
using to filter exception step
link
audit trail
and parameter changes
link link
clearing old data
link
specifying length
link
audit_history_length parameter
link link link
AuditMailAddress parameter
link link
autogenerated ID
link
automating data transfers
link
AutoRunMode parameter
link link
Avg()
link
axes of a worksheet
introduction
link
B
BAL
upgrade
link
BAL Explorer
link
copying objects from schema to folder
link
creating folders
link
deleting folders
link
deleting object from folder
link
deleting schema connection
link
editing schema connection
link
including upgrade SQL in log file
link
migrating objects
link
rebuilding a schema repository
link
renaming folders
link
screen elements
link
setting global upgrade preferences
link
starting manually
link
troubleshooting
link
upgrading objects in folder
link
upgrading schemas
link
viewing log files
link
viewing transactions
link
Bal Explorer
creating schema connection
link
creating schema connection based on another schema connection
link
BAL repository
link
batch file
for loading sales, item, or location data
link
running from within workflow
link
to export data
link
to import data
link
to import supplementary data
link
batch run
compared to simulation run
link
starting from a workflow
link
bce_log_parm parameter
link
BIIO_IMP_PROMO_DATA staging table
link
BIIO_Population staging table
link
BIIO_Promotion staging table
link
BLE
CDP specific enhancements to existing Demantra functionality
link
configuring BLE as part of the update mechanism
link
deploying BLE cluster
link
BLE Step
and other Demantra processing steps
link
reference
link
ble_enable_worksheet_calculations
link
BLEThreadPoolSize parameter
link link
BLEtime-out parameter
link
BLETimeOut parameter
link
branch_data table
link link link link
branch_data_items table
introduction
link link
specifying whether to use
link
using
link
brokers
link
building BAL repository
link
buildNumber parameter
link
Business Application Language
link
Business Logic Engine (BLE)
and client expressions
link link link
and workflows
link
CDP specific enhancements to existing Demantra functionality
link
introduction
link
threading mechanism
link
workflow step
link
Business Logic Engine (BLE) cluster
deploying
link
Business Modeler
associating units with levels
link
configuration settings
link
configuring components
link
configuring exchange rates
link
configuring import for supplementary data
link
configuring indexes
link
configuring integration interfaces
link
configuring levels
link
configuring methods
link
configuring parameters
link
configuring series
link
configuring time units
link
configuring units
link
configuring update-lock expressions
link
Data Model Wizard
link
introduction
link
refreshing
link
starting
link
viewing series dependencies
link
when to use
link link link link
Buydown series
link
C
cache
Java
clearing
link
specifying size
link
level members
modifying cache properties
link
specifying policies
link
series aggregated by items
link
series data aggregated by item
link
Tomcat, clearing
link link
worksheet
refreshing in the background
link
worksheets
enabling globally
link link
Cache Manager
link
CACHE_CAPACITY
link
CACHE_IS_LAZY
link
CACHE_LOAD_EXTRA_FROM
link
CACHE_LOAD_EXTRA_WHERE
link
CACHE_TYPE
link
caching
worksheet
link
calendar months
link
cannot connect to database
link
cannot connect to server
link
cascade mode for filter, enabling
link
Case function
link
casual user
link
causal factors
and demand and forecast
link
and promotion attributes
link
overview
link
specifying in the Data Model Wizard
link
when to configure
link link link
Chaining Management
launching from within Collaborator
link
CHAINING procedure
link
ChangedDataIndicator parameter
link
characters to avoid
link link
charsetEncoding parameter
link
Check Finish After option
link
Check Finish Every option
link
check request level
link link link
check requests
link
CHECK_REORG procedure
link
check_validity_installation parameter
link
child
link
claim
introduction
link
origin of
link
CLEAN_ENGINE_PROFILES procedure
link
CLEAN_LOG_TABLES procedure
link link
client expression
allowed operators
link
and export
link link
dependencies on other series
link
functions used in
link
introduction
link
introduction to editor
link
literal negative values
link
syntax
link link
used as an update-lock expression
link
used for series summary
link
used with server expression
link link
verifying all
link
weighted average
link
when evaluated
link
client.enableOpenNoteWithDoubleClick parameter
link
client.JREMaxMemory parameter
link
client.lookAndFeel parameter
link
client.MaxCombsLoadChunkSize parameter
link
client.worksheet.privateAccessType parameter
link
code field
and extra FROM and extra WHERE
link
and integration
link
for dropdown-type series
link
specifying
link link
specifying in Data Model Wizard
link
viewing for members
link
Collaboration Services
link
collaborator.searchURL parameter
link link
collaborator.supportURL parameter
link link
color expression
link link
dependencies on other series
link
ColorCodingLevel parameter
link link
colors in worksheet table
link
combination
and delta
link
and matrix series
link
delta field
link link link
displaying data for
link
importing new
link
inserting new forecast records
link
introduction
link
maximum number to display in graph
link
P1, P2, and so on
link link link
selecting which to display
link
combination level
introduction
link
combination series
where stored (if stored)
link
company.name parameter
link link link link
component
creating or modifying
link
deleting
link
engine profiles, specifying
link
indexes and exchange rates
specifying
link
viewing
link
introduction
link link
levels, specifying
link
owner
link
restarting server after changing
link
series
adding
link
viewing
link
series indicators, specifying
link
units
specifying
link
viewing
link
users, specifying
link
worksheet-level associations
link
Component Configuration Wizard
link
COMPUTE_STD_ERR procedure
link
condition
detecting
link link
flagging with color
link link link
Condition Step
and other logic steps
link
reference
link
conditional functions
Case
link
If
link
configure to order levels
link
configuring
new product launch
link
Configuring Promotion Population Entry
link
connection handles
deleting link
link
introduction
link
linking
link
constraint optimization
link
Constraint Profit Optimizer
creating profile
link
deleting profile
link
introduction
link
running profile
link
constructor methods
link link
consumption_demand data field
link
Container Step
and other logic steps
link
reference
link
content
defaults for content wizard
link
parameters related to
link
setting security
link
Continue recovery option
link
CopyPasteIntersect parameter
link
Count()
link
CPI (Consumer Price Index)
link
CPO Engine
link
Create Member Step
link link
CREATE_OPT_STRUCT procedure
link
CREATE_PE_STRUCT procedure
link
crosstab layout
link
CTL file
link link
CurrentRow function
link
custom methods
link link
Custom Step
and other external functions
link
reference
link
D
dashboard
customizing graphics
link
data
how calculated
link
how stored
link
importing or exporting automatically
link
loading
link
types of data allowed in series
link
data loading
data needs
link
overview of tools
link
data model
choosing sources
link
deleting
link
importing or exporting
link link
loading data into
link
opening
link
saving with new name
link
selecting number and format of sources
link
specifying format of source files
link
Data Model Wizard
link
data profile
link link link
data-dependent time unit
link
database
cannot connect to
link
creating table
link
maintaining tables
link
maintenance tasks
link
recompiling functions and procedures
link
using a different database without reinstalling
link
database server
link
DatabaseEncoding parameter
link
date format
imported data
link
date functions
Day
link
Month
link
Today
link
Year
link
date series
link
date/time format
for new dates
link
parameters
link
Day function
link
db_exception_log table
link
DBConnectionTimeout parameter
link link
DBDateFormat parameter
link link link
DBHintProport_SalesMinSalesDate parameter
link
DBIdleTimeOut parameter
link link
dbms_connect parameter
link
dbms_type parameter
link
DBName parameter
link link link
DBPassword parameter
link link
DBPort parameter
link link
DBType parameter
link link
DBUser parameter
link link
dead combination
link
Debug parameter
link
DebugMode parameter
link
Decode()
link
deduction
introduction
link
deductions
origin
link
def_delta parameter
link
default
attribute values for manually created member
link link
combinations in worksheet
link
delays in workflow processing
link
Demantra graphics (Web products)
link link
general level indicators for series
link
index or exchange rate
link
links in Demantra Local Application
link
methods
link link
pane configuration in Demantra Local Application
link
parent members for manually created member
link link
right-click options
link
series in new worksheet
link
unit of measure
link
worksheet associated with a level
link link
DefaultContentSecurityAccess parameter
link
DefaultLevelSecurityAccess parameter
link
defining rolling data profile groups
link
delete access, security for
link
Delete Member Step
link link
DELETE_FORE_COL procedure
link
DELETE_INVALID_GL_POPULATION procedure
link
delta value for item-location combination
link link
delta, delta_d, delta_w data fields
link
demand
and causal factors
link
useful series
link
Demand Planner Web
introduction to user interface
link
demand variability process
link
Demantra
enhancements for Consumption-Driven Planning
link
solution components
link
Demantra Local Application
and workflow
link
browser window title
link
cannot launch desktop from
link
configuring
link link
configuring content security
link
configuring links
link
configuring login page
link
configuring menus
link
customizing graphics
link link
error in My Tasks
link
how configurable
link
parameters
link
parameters related to
link
specifying menu permissions
link
title of home page
link
workflow and My Tasks
link
Demantra Local Application Administrator
configuring default layout of Collaborator
link
configuring menu permissions in Collaborator
link link link link
configuring menus in Collaborator
link
configuring pane security in Collaborator
link
logging on
link link
overview
link
description field
link link
destructor methods
link link
dir.onlineHelp parameter
link link
direct customers
link
display style for population attributes
examples
link
specifying
link
Distributed Engine
introduction
link
do_aggri data field
link
do_fore data field
link
DOL
URL
link
using
link
wrong link
link
DOL Services
link
double-click for notes, disabling
link
dp.exe
link
dropdown security
link
ds.ini
link
DSM
configuring
link
configuring matching
link
configuring promotions
link
configuring write-offs
link
customer relationships
link
data flow
link
loading data
link
overview
link
parameters
link
setting up database structures
link
DSMAllShipDateDifference parameter
link link link
DSMOICheckProduct parameter
link
DSMOIPercentDifference parameter
link link link
DSMOIShipDateDifference parameter
link link link
DSMPEOIAmountSeries parameter
link link
DSMPEShipDateSeries parameter
link link
DSMPromotionBudgetSeries parameter
link link
DSMWriteOffThreshold parameter
link link
dying_time data field
link
dying_time parameter
link link
Dynamic Open Link
URL
link
wrong link
link
dynamic_hint_enabled parameter
link
dynamic_hint_factor parameter
link
dynamic_hint_max_parallel_db_machine parameter
link
dynamic_hint_threshold parameter
link
DYNAMIC_SYNC procedure
link link
E
Edit Member Step
link link
edit methods
link link
edit-lock expression
and other features that control editability
link
creating
link
dependencies on other series
link
introduction
link
email
creating link for webmaster
link
Demantra administrator
reconfiguring
link
in automated workflow
link link link link
not received, possible cause
link
specifying for users
link
Email Step
and other interactive steps
link
reference
link
embedded worksheets
backend configuration
link
introduction
link
empty columns
saving setting
link
empty rows
saving setting
link
empty time bucket, referencing
link
ENABLE_DEBUG
link
ENABLE_STATISTICS
link
EnableIncrementalLoading parameter
link
EnableOpenNoteWithDoubleClick parameter
link
EnableWorksheetCaching parameter
link
enabling calendar month support
link
encryption.exe
link
engine output threshold
description
link
engine profile
including in a component
link
introduction
link
EngineManager.exe
link
enhancements for Consumption-Driven Planning
link
EP_LOAD_ITEMS procedure
link
EP_LOAD_LOCATIONS Procedure
link
EP_LOAD_MAIN procedure
link link
EP_LOAD_MDP_LEVEL Procedure
link
EP_LOAD_SALES Procedure
link
Error in process execution
link
error log
data loading
link
for procedures
link
integration
link
error on page or error loading tasks
link
error tables for integration
link
error while running Worksheet Window
link
event
default settings
link
Excel
data exported to as text
link
wrong link to Demantra Spectrum
link
Exception Step
and other interactive steps
link
and other logic steps
link
reference
link
exceptions
and other filters
link
and promotion series
link
flagging series for use in
link
in data profile
link
introduction
link
using in a workflow
link
using in workflow
link
exchange rate
and monetary unit
link
configuring
link
editing values
link
in integration
link
including in a component
link link
used in component
link
Executable Step
and other external functions
link
reference
link
EXECUTE_PROFILES procedure
link link
executeStep function
link
execution.shell parameter
link link
Exp function
link
expiration time
link
expired license
link
expired session
link
export
exporting a data model
link
setting up
link
within automated workflow
link
EXPOSE_PROMOTIONS procedure
link link
extending Demantra
link
Extra From
for a drop-down attribute
link
for a level
link
for a series drop-down
link
for a server expression
link
extra SQL
link link link
Extra Where
for a drop-down attribute
link
for a level
link
for a series dropdown
link
for a server expression
link
F
Fail-To-Execute
in Container Step
link
in Exception Step
link
filter
and Open With menu
link link
and other performance tips
link
appearance to user
link
at user level
link link link
cascade versus non-cascade mode, per user
link
controlling order of levels in
link
creating filtered levels
link
data displayed in
link
in a worksheet
link
in data profile for import or export
link
passing to method
link link
using autogenerated ID as code field
link
using in definition of drop-down list for attribute
link
using in definition of drop-down list for series
link
using in definition of series
link link
FIRSTDAYINWEEK parameter
link link
forecast tree
and the engine
link
configuring
link
used by Analytical Engine
link
forecast versions
link
ForecastFirstRow function
link
format.dates.longFormat parameter
link link
format.dates.shortFormat parameter
link link
Fpos function
link
Fsum function
link
G
Gantt chart
introduction
link
general level
adding a population attribute
link
and series indicators
link
configuring Activity Browser
link
exporting
link
flagging as analytical
link
importing
link
introduction
link
specifying presentation style for population
link
specifying series indicators
link link
General Levels
Proport
link
general levels
CDP specific enhancements to existing Demantra functionality
link
launch management
link
general.copyright parameter
link
general.homepage.title parameter
link link
general.title.text parameter
link link
general.userList.tasks parameter
link
general.userList.whoisonline parameter
link link link
general.userList.worksheets parameter
link
Get_Max_Date()
link
GetRow function
link
GL Data Preservation
link
gl synchronization
overview
link
glob_prop
link
glob_prop data field
link
graph
controlling available series
link
hiding or displaying
link
introduction
link link
parameters for controlling
link
Graph.MaxLabelWidth parameter
link link
graphics, customizing
link link
group
access to Workflow Editor/Manager
link
adding users to
link
creating
link
deleting
link
introduction
link
overview
link
selecting users for
link
users in
link
group expressions
link
Group Step
and other interactive steps
link
reference
link
GUI Services
link
H
hierarchy
adding level
link
controlling order of levels in display
link
data model
link
introduction
link
hint message
level
link
series
link link link
hist_glob_prop
link
hist_glob_prop data field
link
hist_glob_prop parameter
link
historical data
link
https
link
hung session
ending
link
I
If function
link
illegal characters
link link
images, customizing
link link
import
aggregated data
link
data other than series or levels
link
importing a data model
link
series data, at any level
link
setting up
link
within automated workflow
link
ImportBlockSize parameter
link link
ImportFromExcelBulkUploadDefault parameter
link
IncludeSummaryExportToFile
link
incremental loading, enabling
link
index (financial)
and monetary unit
link
and worksheet
link
configuring
link
editing values
link
in integration
link
including in a component
link
introduction
link
restarting server after changing
link
used in component
link
index (table)
rebuilding
link
where stored
link
index adviser
link
indexspace parameter
link link
indicators for notes, promotions, or general levels
link
indirect customers
link
initial_param parameter
link link
input data
allowed formats
link
introduction
link
joining
link
Inputs table
used for time aggregations
link link link
used for time units
link
INSERT_UNITS procedure
link link link
InsertDateTimeFormat parameter
link link link link
Insertmissingvalues parameter
link link
integration
checking progress of
link
data needs
link
introduction
link
overview of options
link
overview of tools
link
reference for interfaces
link
integration interface
defining
link
deleting
link
executing from DOS
link link
executing from workflow
link link
introduction
link
restarting server after modifying
link
Integration Tool (standalone)
link link
Internal error
check database and network connections
link
internationalization
link
is_fictive data field
link
Is_Modified function
link
is_self data field
link
item-location combination
displaying data for
link
introduction
link
item-type levels
introduction
link
item_id data field
link link link
item_node field
link
items table
link
J
J2EE application server
link
Java
including in workflow
link
using as method
link
Java applet
version
link
Java out of memory
link
join, defining
link
JREMaxMemory parameter
link
L
languages
link
launch management
link
general levels
link
layout, Demantra Local Application
configuring for all users
link
layout, worksheet
and summary rows
link
examples
link
saving changes
link
tips
link
legend
of content pane, maximum number of entries
link
showing by default
link
showing by default in desktop
link
Legend.MaxLegendItemWidth parameter
link link
level
adding attributes
link
adding right-click option
link link
associating with worksheets (for Open With)
link link
attributes
link
caching members
link
configuring
link
default member
link
default member, specifying
link
deleting
link
disabling
link
exporting members and attributes
link
filtering
link
importing or exporting
link
including in component
link
introduction
link
joining to another table
link
predefined default member, renaming or hiding
link
predefined default members
link
restarting server after changing
link
specifying security at component level
link
specifying units of measure
link
where and when created
link
level profile
link
level series
link
level_id field
link
license
expired
link
License.ExpirationMessage parameter
link
link between steps
creating
link
deleting
link
LinkedDataAutoCopy parameter
link
links in Demantra Local Application
adding to menus
link
configuring
link link
live combination
link
Load_data.bat
link
LoadDataStop parameter
link link
loading translations
link
Loading Veh $ series
link
loc_node field
link
location data, input file
link
location table
link
location-type level
introduction
link
location_id data field
link link link
LockTimeout parameter
link link
log file
for loading data
link
integration
link
log for procedure errors
link
log.history parameter
link link link
logconf.lcf
link link
logging off
if session hangs
link
logging on
link link
login page, configuring
link
lookup level
creating as attribute
link link
Lower()
link
LRU caching
link
Ltrim()
link
M
mail parameter
link link
mail-password parameter
link
mail-username parameter
link
mail.outgoing.server parameter
link
mail.server parameter
link link
mail.strings.from.system parameter
link link link
mail.strings.internalerror.message parameter
link link link
mail.strings.internalerror.subject parameter
link link link
mail.strings.processfailuresubject parameter
link link link
mail.strings.processterminated parameter
link link
mail.strings.recovery parameter
link link link
mail.strings.taskfailuresubject parameter
link link link
mail.strings.taskstimedoutsubject parameter
link link link
mail.strings.timeout.group parameter
link link link
mail.strings.timeout.user parameter
link link link
mail_recipient parameter
link
mailAddress parameter
link link
mailProtocol parameter
link
ManualRefreshAsDefault parameter
link
matrix series
introduction
link
MatrixCombs parameter
link
mature_age parameter
link
Max()
link
max_fore_sales_date parameter
link
max_initial_members parameter
link
max_records_for_commit parameter
link link
max_sales_date parameter
link
MaxAvailableFilterMembers
link
MaxBackgroundLoad parameter
link
MaxCombsLoadChunkSize parameter
link
MaxDBConnections parameter
link link
MaxSaleVal parameter
link
MaxUpdateThreads parameter
link link
MDP_ADD procedure
link link link
mdp_matrix table
and combination levels
link
and combination series
link
fields in
link
member
adding right-click option
link link
introduction
link
Member Management
launching from within Collaborator
link
number of members shown at once
link
member security
link
Members Browser
comparison to selection lists
link
menu
Demantra Local Application
configuring
link
configuring menu permissions
link
right-click
configuring
link link link
configuring Open with menu
link
menu, right-click
configuring Open with menu
link
removing options
link
Message Step
link
method
action when complete
link
creating
link
default methods
link
deleting
link
input dialog box
link link
output dialog box
link link
overview
link link link
passing arguments to
link link link link
restarting server after changing
link
thread pool
link
when to define
link
migrating objects
link
standard upgrade folder
link
Min()
link
min_fore_sales_date parameter
link
min_sales_date parameter
link
MinDBConnections parameter
link link
missing_all_sources data field
link
missing_some_sources data field
link
mix_max_members parameter
link
Mod function
link
MODEL_PATH parameter
link
models
and engine flow
link
modulus
link
Month function
link
multiple language support
link
My Tasks
and workflow
link
configuring user access
link
default availability and location
link
errors on
link
introduction
link
origin of tasks in
link
refreshing
link
My Worksheets
configuring user access
link
default availability and location
link
N
naming series
link
navBarContentProvider.addNewContentLink.Text parameter
link link
navBarContentProvider.interpriseContent.text parameter
link
negative values within client expression
link
negative values within server expression
link
new product introduction (NPI)
link
new product launch
link
new store introduction
link
new_member data field
link
next_param parameter
link link
No suitable driver
link
non-cascade mode for filter, enabling
link
NormalizeResults parameter
link
note
access at group level
link
configuring indicators in worksheet table
link
controlling double-click access
link
notifications, missed
link
NpiUseWsFilter parameter
link
numeric functions
Abs
link
Exp
link
Mod
link
Pi
link
Rand
link
Round
link
Sqrt
link
Truncate
link
Nvl()
link
O
object error message
link
OBS_ERROR_STD data field
link
off-invoice settlement
introduction
link
origin
link
offline
cannot access offline worksheets
link
Open With menu
associating levels and worksheets
link link
customizing
link
errors
link
OpenFileAfterExport parameter
link
OpenWithContext parameter
link link
opti_level_item parameter
link
opti_level_location parameter
link
Oracle
monitoring sessions
link
terminating sessions
link
XDB user and port collision
link
oracle_optimization_mode parameter
link
outlier data field
link link
P
P1 value for item-location combination
link link link
P1, P2, ..., P12 data fields
link
page cannot be displayed
link
parameters
APS queue
link
configuring
link
database
link
date/time formats
link
Demantra Local Application
link
email
link
for database procedures
link
for default promotion start and span
link
for Demantra Spectrum executables
link
for optimization step
link
for programs run from Demantra Local Application
link
graphs
link
in Integration Queue
link
in methods
link link link link
integration and import
link
logs and old data
link
passing to Java
link
Promotions Effectiveness
link
Settlement Management
link
solution basics
link
solution branding
link
specifying for Java class
link
threading
link
workflow
link
worksheets
link
parent
link
partial chaining indicators
link
parts_factor_source parameter
link
password
permission needed for changing
link
policy
link
Paste Member Step
link
PATH environment variable
link
Pause option
link
Pay Type series
link
pct_increase_for_analyze parameter
link link
PD1, PD2, ... PD7 data fields
link link
performance
suggestions on fixing
link
tips for worksheet design
link
permission level
specifying for user
link
permission level
customizing
link
introduction
link
specifying for user
link
specifying menu items for
link
phase_in_out parameter
link
Pi function
link
pivot table
link
Planning Applications menu
customizing
link
Platform Server
link
Platform upgrade
link
Please handle recovery
link
POP_ALL_MATCH_PROPOSAL procedure
link link
POP_OI_MATCH_PROPOSAL procedure
link link
population attribute
adding to level
link
loading
link
passing to method
link link
presentation style in methods
link
specifying presentation style
link
table where stored
link
using to filter condition step
link
using to filter exception step
link
Population Attribute Step
link
Population Date Levels parameter
link
portalVersion parameter
link
ports, changing
link
post_effect data field
link
power user
link
pre_effect data field
link
PRE_LOGON procedure
link
predefined default member
introduction
link
renaming or hiding
link
prediction status
field where stored
link
reference
link
used by constraint profit optimization
link
when computed
link
prediction_status data field
link
prepare_data procedure
link
presentation style for population attributes
link
specifying
link
procedures
link
error log
link
recompiling
link
running from within a workflow
link
to load data into data model
link
when to wrap
link
wrapping
link
process log
link
profile
for constraint optimization
creating
link
deleting
link
introduction
link
running
link
for engine parameters
link
adding to component
link
for integration
creating
link
executing from workflow
link
introduction
link
for loading supplementary data
link
for rolling data
executing
link
introduction
link
program group
defining
link link
deleting
link
PromoDefaultSpan
link
PromoDefaultSpan parameter
link link link
PromoDefaultStart
link
PromoDefaultStart parameter
link link link
promotion
color coding
link
configuring indicators in worksheet table
link
configuring the Activity Browser
link
copy/paste operations
link
default date settings
link
default settings
link
Promotion Calendar
tables
link
promotion level
link
Promotion Optimization
configuring
link
methods
link
overview of setup
link
setting up without the installer
link
promotion series
introduction
link
specifying how to preserve during copy/paste
link link link
where stored (if stored)
link
promotion table
link
promotion_data table
fields in
link
promotion_data table
and promotion series
link
promotion_id field
link
promotion_status_lookup table
link
Promotions Effectiveness
parameters
link
Promotions Effectiveness
adding population attributes to general level
link
configuring Activity Browser
link
introduction to user interface
link
level series
link link
proof of performance
introduction
link
prop_changes data field
link
Proport
General Levels
link
proport
and integration
link
calling from mdp_add procedure
link
during import
link
overview
link link
parallelization
link
specifying reference series
link
summary of parameters
link
used by engine
link
when using engine profiles
link
proport parallelization
link
PROPORT procedure
link
proport_missing
link
proport_missing parameter
link
proport_spread parameter
link
proport_threshold parameter
link
ProportParallelJobs parameter
link
ProportRunsInCycle parameter
link
ProportTableLabel parameter
link
PW1, PW2, ..., PW6 data fields
link link
Q
quantity_form
link
query
link link
Query.MaxCombinations parameter
link link
Query.MaxSeries parameter
link link
Query.TopBottom.MaxCombinations parameter
link
QueryMechanisimTimeOut parameter
link link
QueryRunMaximumThreadUser parameter
link
quote marks, in Demantra Spectrum
link
R
Rand function
link
random numbers
link
REBUILD_INDEXES procedure
link link
Rebuild_Sales_Table parameter
link link link
REBUILD_SCHEMA procedure
link
REBUILD_TABLES procedure
link link link link link
ReceiveCollaborationMessages parameter
link
recompiling database
link
recovery
link
recovery options, workflow
link
Refresh Population Step
link
and other Demantra processing steps
link
refreshing
link
RefreshTimer parameter
link
regime_change field
link
reloading data automatically
link
REORG procedure
link
REPLACE_APOSTROPHE_LEVELS procedure
link
RestartOnFailureInterval parameter
link
retailer
changing default profile
link
list price
link
shipments
link
Retry recovery option
link
right-click menu
configuring
link link link
configuring Open With menu
link link
rolling average demand
link
rolling data
configuring series for use in
link
creating profiles
link
executing profiles
link link
overview
link
rolling data profile groups
link
rolling data profile groups
link
rolling data profiles
CDP specific enhancements to existing Demantra functionality
link
rolling_profiles table
link
Round function
link
Round()
link
row functions
CurrentRow
link
ForecastFirstRow
link
GetRow
link
RowCount
link
RowCount function
link
Rtrim()
link
Run_full_matrix_proport parameter
link link link link
RunInsertUnits parameter
link
RunProportInMdp_add parameter
link link link
S
Safe_Division()
link
SafeguardSimLock parameter
link
safety stock
inventory level, based on service level
link
procedure for computing
link
Sale Price series
link
sales data
link
sales data, input file
link link
sales series
introduction
link
where stored (if stored)
link
sales_data table
and branch_data synonym
link
and sales series
link
fields in
link
inserting records
link
rebuilding
link
sales_data_engine table/view
tablespace for
link
sales_data_engine_index_space parameter
link link
sales_data_engine_space parameter
link link
Scheduler
procedures
link
recommended scheduling
link
scheduling
database procedures
recommendations
link
workflow instances
link
schema (database)
analyzing
link
rebuilding
link
schema (workflow)
creating
link
deleting
link
schema group (workflow)
creating
link
deleting
link
sdata5, sdata6, and so on
link
security
dropdown
link
security changes, missed
link
security model
link
SecurityFromSystem parameter
link
Selection Step
and other interactive steps
link
and other logic steps
link
reference
link
selection task
adding to workflow
link
series
available to user
link
color expression
link link
configuration as drop-down
link
configuring data in
link
configuring server expression
link
configuring table display
link
creating
link
data in
link
dependencies among
link
edit-lock expression
link link
exporting data at any level
link
including in a component
link
indicators for notes or promotions
link
making available for specific user
link
restarting server after changing
link
specifying general information
link
where and when created
link
server expression
allowed operators
link
and unit token
link
as source for rolling data
link
configuring
link
Demantra tokens in
link
filtering source data
link link
functions used in
link
introduction
link
introduction to editor
link
literal negative values
link
referring to forecast version
link
referring to other tables
link link
syntax
link link
used with client expression
link link
verifying all
link
when evaluated
link
server, cannot connect to
link
server.generalurl parameter
link link link
Server.SessionExpiration parameter
link link
ServerName parameter
link link link
service parts forecasting levels
link
session
expiration time
link
limit per user
link
lock timeout period
link
session, Oracle
monitoring
link
terminating
link
set_rb parameter
link
setParameters function
link
settlement level
link link link
Settlement Management
configuring
link
configuring matching
link
configuring promotions
link
configuring write-offs
link
customer relationships
link
data flow
link
loading data
link
overview
link
parameters
link link
setting up database structures
link
SettlementLocationExtension parameter
link link
SettlementProductExtension parameter
link link
settlements
default settings
link
introduction
link
trade versus non-trade
link
shipment_demand data field
link
show_legend parameter
link
SimMaxSize parameter
link
SimNotification parameter
link
SIMPLE caching
link
simple time unit
link
simulation
adding to workflow
link
and workflow engine
link
compared to batch run
link
controlling maximum size
link
related parameters
link
tablespace for
link
simulation notification, missed
link
Simulation Step
and other Demantra processing steps
link
reference
link
simulationindexspace parameter
link link
simulationspace parameter
link link
SimWarnSize parameter
link
Slotting $ series
link
solution components
link
sorting
saving sort order
link
sortMemberbycodeinFilter
link
source tables
link
special characters (to avoid)
link link
SPF_Default_Profile
link
SPF_Enable_Worksheet_Calculations
link link
SPF_History_Periods
link
SplitDataMaxQueues
link
SplitDataTimeout
link
splitting
during forecasting
link
during import
link
overview
link link
specifying reference series
link
SQL procedures, compiling
link
Sqrt function
link
square root
link
staging table
for item data
link
for location data
link
for promotion data
link
for promotion populations
link
for promotions
link
for sales data
link
staging tables
and error tables
link
for data and level integration
link
for data import
specifying name
link
specifying order of levels
link
structure
link
for Data Model wizard
introduction
link
joining
link
specifying how to use fields
link
specifying structure
link
for level import
creating
link
structure of main table
link
structure of population table
link
Stand-Alone Integration Tool
and license
link
using
link
Standalone Integration Tool
using
link
START_OR_END_WEEK parameter
link
starting
Business Modeler
link
workflow instance
link
StartUpdateQueue parameter
link link
status of promotion
configuring
link
step
adding
link
common properties
link
connecting to another step
link
connection handles
link
deleting
link
editing
link
overview of kinds
link
reference for types
link
Stored Procedure Step
and other Demantra processing steps
link
reference
link
string series
link
sub tabs of worksheet
overview
link link
SubStr()
link
Sum()
link
summaries
link
summary row
and levels on x-axis
link
computing average in
link
computing maximum in
link
computing minimum in
link
computing row count in
link
computing sum in
link
computing weighted average in
link
configuring for series
link
dependencies on other series
link
determining relative level
link
introduction and examples
link
synchro field
link
synchronization
between views
link
synchronous workflows
link
syndicated data
in TPMO
link
sysadmin user
link
sysadmin_email_address parameter
link
sysadmin_password parameter
link
sysadmin_username parameter
link
Sysdate()
link
System Manager permission
and delete access
link
system parameter
ble_enable_worksheet_calculations
link
System Parameters
database performance
link
SystemStatus parameter
link
T
T_SRC_ITEM_TMPL staging table
link
T_SRC_LOC_TMPL staging table
link
T_SRC_SALES_TMPL staging table
link
tables
creating
link
editing
link
maintaining
link
tablespace parameter
link link
tablespaces
used by Demantra Spectrum
link
task
and workflow
link
introduction
link link
selection tasks
link
specifying
link
timeout
link
task.default.option parameter
link
task.message.length parameter
link
task.message.taskadded parameter
link
tasklist.showTimeoutTasks parameter
link
tasks timed out in workflow
link
templates for data models
link
temporary tables, cleaning up
link
threading parameters
link
threadpool.attributesUpdate.per_comb parameter
link
threadpool.attributesUpdate.size parameter
link
threadpool.attributesUpdate.timeout parameter
link
threadpool.copy_paste.per_process parameter
link link
threadpool.copy_paste.size parameter
link link
threadpool.copy_paste.time-out parameter
link
threadpool.copy_paste.timeout parameter
link
threadpool.default.size parameter
link
threadpool.default.timeout parameter
link
threadpool.level_method.block parameter
link link
threadpool.level_method.size parameter
link link
threadpool.level_method.time-out parameter
link
threadpool.level_method.timeout parameter
link
threadpool.query_run.size parameter
link link
threadpool.query_run.time-out parameter
link
threadpool.query_run.timeout parameter
link
threadpool.update.size parameter
link link
threadpool.update.time-out parameter
link
threadpool.update.timeout parameter
link
time aggregation
and time units
link link
creating
link
introduction
link
time aggregations
creating
link
time bucket
introduction
link
referencing if empty
link
time resolution
base
if changed
link
setting
link
specifying
link
used during import
link
time unit
link link
and time aggregations
link
and time axis
link link
conceptual example
link
creating
link
deleting
link
rules in Demantra
link
simple versus data-dependent
link link
time zones
link
timeout
in BLE Step
link
in Container Step
link
in workflow
link
Timeout>Alert Time option
link
Timeout>Timer option
link
timeunit parameter
link
timeunit parametertimeunitTimeresolution parameter
link
Tnsname parameter
link
To_char()
link
To_date()
link
To_number()
link
Today function
link
Tomcat
clearing cache
link
non-default port
link
port
link
starting
link
writing log to a file
link
Tools and Applications menu
customizing
link
traffic lighting
link
Transfer Step
and other Demantra processing steps
link
reference
link
translation utility
link
treatment period was finished
link
trend damp period
link
Truncate function
link
U
units of measure
associating with aggregation levels
link
configuring
link
in worksheets
link
including in a component
link
introduction
link
restarting server after changing
link
where and when created
link
Update Data Step
link
update mechanism
link
update-lock expression
configuring
link
update_dead_comb
link
update_units_by_items parameter
link link
UpdateQueueTimeout parameter
link link
UpdateThreadtime-out parameter
link
UpdateThreadTimeout parameter
link
upgrade options
link
UPGRADE_TO_SHAPE_MODELLING procedure
link
Upgrading Schemas
link
upk
configuring
link
Upper()
link
URLs
link link
changing
link
Use autogenerated ID as code for filter
link
UseDateRangeMatrix
link
useGLExceptions parameter
link
UseItemsAggri parameter
link link link
user
access to levels
link
access to series
link link link
access to worksheets
link
adding to groups
link link
copying
link
creating
link
filter mode (cascade vs non-cascade)
link
filtering data
link
forcing logout
link
overview
link link
restarting server after changing
link
specifying modules
link
User Access Control Step
reference
link
user does not receive email
link
user is already active
link
User Step
and other interactive steps
link
reference
link
UserListContentProvider.commontitle parameter
link link
UserTitleContentProvider.TimeToSleep parameter
link link
V
validating packages
link
verifying all expressions
link
vertical formula
definition and details
link link
precedence in recalculation
link
view
and worksheet
link
x-axis and y-axis
link
virtual directory
parameter where saved
link
VisibleUserName
link
W
Wait Until Step
and other logic steps
link
reference
link
Web Platform Server
link
Web server
configuration file
link
introduction
link
launching workflows when starting
link
threading
link
using Tomcat
link
Whoxd5 s Online
controlling user access
link
customizing
link
default availability and location
link
width of series, configuring
link
workflow
available steps
link
email addresses used in
link
introduction
link
length of history
link
parameters
link
responding to external events
link
schema
creating
link
examples
link
running an integration interface
link link link
using as method
link
when called by method
link link
schema group
creating
link
deleting
link
schema instances
launching at Web server start
link
scheduling
link
starting
link
stopping
link
update data workflow
link
where and when created
link
Workflow Editor/Manager
login access
link link
scheduling workflow instances
link
starting workflow instances
link
stopping workflow instances
link
using
link
viewing process log
link
viewing workflow status
link
Workflow Engine
link
Workflow internal error
link
Workflow process has failed
link
workflow recovery
link
Workflow Services
link
workflow.group parameter
link link link
workflows
web services
link
worksheet
changing access
link
changing owner
link
configuration
adding right-click options to
link link link
adding to Open With menu
link link
indicators for notes and promotions
link
overview
link
use of units and indexes
link
using colors to flag conditions
link
data in
link link
deleting
link
design
filtering
link
tips
link
elements of
link
evaluating client expressions in batch mode
link
how aggregated and organized
link
introduction
link
loading data automatically
link
object error message when opening
link
offline, cannot access
link
ownership and security
link
reloading data automatically
link
saving definition
link
table
link
viewing all worksheets
link
views in
link
when to define
link link
x-axis and y-axis
link
Worksheet Cache Step
and other Demantra processing steps
link
reference
link
worksheet caching
link
Worksheet Manager
link
worksheet step
reference
link
worksheet.private_access_type parameter
link
WorksheetBeanContentProvider. memberCombinationsLimit parameter
link
WorksheetDefaultDateChoiceMethod parameter
link link
WorksheetDefaultSpan parameter
link link
wrap30.bat
link
X
x-axis
introduction
link
XDB database user
link
Y
y-axis
introduction
link
Year function
link
young combination
link
Z
Z_Val function
link
zero forecast
and prediction status
link
requesting
link
zero length column error
link