Clarify Worksheet Related Parameters - Addressing Out of Memory Warnings
(Doc ID 1133303.1)
Last updated on DECEMBER 10, 2024
Applies to:
Oracle Demantra Advanced Forecasting and Demand Modeling - Version 7.3.0 and laterInformation in this document applies to any platform.
Goal
Clarify Worksheet Related Parameters - Addressing Out of Memory Warnings
• client.uilimitations.maxcells
the maximum number of cells allowed totally for the client (memory limit per client)
Default value: 300000.
Q: how the above is different than client.uilimitations.maxcells.ws? Does client.uilimitations.maxcells handle number of cells in multiple worksheets?
• client.uilimitations.maxdiskspace
maximum disk space allowed to be used by the LRU Disk Cache in Kb.
Default value: 200000.
Q: how do we determine the value? What is the mechanism?
• max.worksheet.db.weight
the maximum database weight (rows of item/location ratio) allowed to be
Q: this ratio is not clear - please explain with examples.
The client.uilimitations.maxcells ---
1. Does this count ALL combinations*number of series*number of time buckets in the worksheet or for one combination*number of series*number of time buckets that we are browsing through?
2. Does this count incluse displayed combinations on worksheet or combinations that are aggregated to display higher level combinations?
3. Does this count include all the worksheets displayed at one time such as embedded? Or it includes the worksheets that are opened but not displayed (in a different tab)?
The client.uilimitations.maxcells.ws ---
1. Does this count ALL combinations*number of series*number of time buckets in the worksheet or for one combination*number of series*number of time buckets that we are browsing through?
2. Does this count include displayed combinations on worksheet or combinations that are aggregated to display higher level combinations?
client.uilimitations.warning
The description says percentage out of the client.uilimitations.maxxxx parameters to which to display the warning messages upon. For example, if the max combs is 1000 and this value is 80(%), then when trying to load 800 combinations - the warning message will be displayed to the client.
1. By client.uilimitations.maxxxx does it mean client.uilimitations.maxcells or client.uilimitations.maxcells.ws?
2. when it says "max combos" what other parameter is it referring to?
3. From the above example, does this mean when the combinations exceed 800, then the warning will be displayed?
4. client.uilimitations.maxxxx is quantifying cells and we are calculating the combinations based on that value?
5. Is 80% recommended?
6. If the client wants to display 50,000 combinations for 2 years of history, what to setup here?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |