Specifying settings at the dimension level

See Editing a database alias

Cache Attributes
The Attribute Cache saves the attributes only of client list elements.
Mode
The settings at the dimension level override the settings at the cube level.
Note: The Attribute Cache saves attributes only of client lists.
To specify the users of the Attribute Cache, select from the list in the Value column:
Setting Description
None No attribute cache is created.
User Creates an element cache for each user who is logged-on.
Group Creates an element cache for each user group.
All All users share the same element cache.
Update Cache
By default, the cache is updated when elements in the OLAP Server database change. You can make the cache update at times you specify. To do this, double-click the value field to make it editable. Specify the times and frequency of the updates, using these instructions. Note the different usage of parentheses ( ), square brackets [ ] and braces { }:
Point in time Syntax Example
Fixed 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
Periodically every x days

{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 at the cube level are automatically applied to the Attribute Cache. Changes to the schedule for updating the Attribute Cache do not affect the schedule for the Dimension Cache.
If you change the schedule of the Attribute Cache, subsequent changes to the Dimension Cache have no effect on the Attribute Cache.
SeeUpdating the dimension cache
Inherit
For each dimension, select True to specify that the Cache Attributes, Mode and Update Cache settings are inherited from the cube. Otherwise, select False.