|Oracle® OLAP DML Reference
11g Release 2 (11.2)
Part Number E17122-05
The REVERT command drops all changes made to the specified objects since they were last updated, resynchronized (using a RESYNC statement), acquired using ACQUIRE with the RESYNC phrase, or since the analytic workspace was attached.
A list of the names, separated by commas, of acquired variables, valuesets, relations, or dimensions in an analytic workspace attached in multiwriter mode or a list of variables, valuesets, relations, or dimensions in an analytic workspace attached in read-only mode.
Reverting a Dimension After Adding Dimension Values
Reverting a dimension after adding dimension values is not recommended since it can result in suboptimal space allocation for variables dimensioned by that dimension.
Example 10-108 Using REVERT to Undo Modifications
Assume that you have a variable named
budget in an analytic workspace named
myworkspace. Assume, also, that you must modify
budget in several steps but do not want to update the analytic workspace data until all steps are completed. For each step, you want to run several models to find the one that produces desired results. To perform this task, take the following steps:
Attach the analytic workspace in multiwriter mode.
For each step:
Run the appropriate models, performing revert operations between them until you finds the desired model
Commit and release
The following code accomplishes these tasks.
AW ATTACH myworkspace MULTI ACQUIRE RESYNC budget ...try model 1a --> not acceptable REVERT budget ...try model 1b --> ok. Done with Step 1 UPDATE MULTI budget ...try model 2a --> not acceptable REVERT budget ...try model 2b --> not acceptable REVERT budget ...try model 2c --> ok. Done with Step 2 UPDATE MULTI budget ...try model 3a --> ok. Done with Step 3. Done with all steps. UPDATE MULTI budget COMMIT RELEASE budget AW DETACH myworkspace