|Oracle® OLAP DML Reference
11g Release 2 (11.2)
Part Number E17122-05
RESYNC resynthesized read-only objects. Use ACQUIRE to resynchronize acquired objects
A list of one or more variables, relations, valuesets, or dimension names, separated by commas, that you want to resynchronize. Oracle OLAP ignores any acquired objects in this list.
Name as a value in objects to specify that you want to resynchronize the newest objects defined by other users.
Keeping Logical Relationship of Objects
When using RESYNC keep in mind the logical relationship of different objects to avoid losing the logical consistency of the data by promoting some objects, but not others to a new generation.
Resynchronizing Objects that Share a Composite Dimension
Objects that share a composite dimension can be resynchronized separately when all such objects that are not being resynchronized are either unchanged or acquired.
Example 10-105 Resynchronizing Objects
In this example, user A is periodically updating
actuals, while user R needs to periodically check the latest view of the data. They could execute the following OLAP DML statements.
User A could execute the following OLAP DML statements.
AW ATTACH myworkspace MULTI ACQUIRE actuals ...make modifications UPDATE MULTI actuals COMMIT ...make modification UPDATE MULTI actuals COMMIT
At the same time, user R could execute the following OLAP DML statements.
AW ATTACH myworkspace MULTI ... RESYNC actuals ... RESYNC actuals ... RESYNC actuals ...