Specifying settings at the cube level

See Editing a database alias.

Cache Values
The Value Cache saves elements of client lists that have been returned by filtering values. It is not enabled by default. To enable it, select True.
Note: The Value Cache saves elements only of client lists.
Cache Attributes
The Attribute Cache saves the attributes only of client list elements.
Mode
Settings of the Dimension Cache are made at cube level. It saves client list elements to accelerate report creation. The settings at the dimension level override the settings at the cube level.
To specify users of the Dimension Cache, select Creating dimension cache and select the setting from the drop-down list in the Value column:
Setting Description
None No dimension cache is created.
User Creates an element cache for each Application Studio user who is logged on.
Group Creates an element cache for each Application Studio user group.
All All users access the same element cache.
Note: The Dimension Cache saves elements only of client lists.
Update Cache
To update the Dimension Cache automatically at specified times, double-click in the value column to make it editable.
Use these instructions to specify the times and frequency of the updates. Note the different usage of parentheses ( ), square brackets [ ] and braces { }:
Point in time Syntax Example
Point in time

[1] = Sunday

[2] = Monday

[3] = Tuesday

[4] = Wednesday

[5] = Thursday

[6] = Friday

[7] = Saturday

[-] = no refresh

(Hour:Minute)

[26](12:30) refresh the cache each Monday and Friday at 12.30
periodical

{Day}(Hour:Minute)

or

(Hour:Minute)

{15}(14:00) updates the cache every 15th day of a month at 2 p.m.
once a year

{Day.Month}(Hour:Minute)

or

{Hour.Minute}(Day:Month)

[1.5](12:00) updates the cache May 1 at 12 o’clock.
one-time

{Day.Month.Year}(Hour:Minute)

or

{Hour.Minute}(Day.Month.Year)

{20.6.2002}(8:30) updates the cache on 20.6.2002 at 8.30.
Note: Changes to the schedule for updating the Dimension Cache are automatically applied to the Attribute Cache at the dimension level.
See Specifying settings at the dimension level.
Changes to the schedule for updating the Attribute Cache do not affect the schedule for the Dimension Cache.
If you change the Attribute Cache schedule, subsequent changes to the Dimension Cache schedule are not applied to the Attribute Cache.