Clarify Worksheet Related Parameters (Doc ID 1133303.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Advanced Forecasting and Demand Modeling - Version 7.3.0 and later
Information in this document applies to any platform.

Goal

 
• 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 numbre 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 combincations that are agreegated to display higher level combinations?
3. Does this count include all the worksheets displyayed 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 incluse displayed combinations on worksheet or combincations that are agreegated to display higher level combinations?

client.uilimitations.warning
The desciption 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 refering 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms