|Oracle® OLAP DML Reference
11g Release 1 (11.1)
|PDF · Mobi · ePub|
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.
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.
Objects that share a composite dimension can be resynchronized separately as long as all such objects that are not being resynchronized are either unchanged or acquired.
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 ...