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