In this second example,
an existing production cube is replaced with an updated version from
another schema and the old cube is archived.
Perform an incremental
update on production cube A. This creates a cube A located in OLAP
Schema TestSchema.
proc olap cube=A outschema=TestSchema add_data data=lib1.data1;
metasvr .... olap_schema=ProductionSchema ;
run;
Disable the production
cube.
proc olapoperate <server-connection-options>;
disable cube A;
run;
Move the old cube to
an archive schema.
proc olap rename cube=A outcube=A_September2005 outschema=ArchiveSchema;
metasvr ... olap_schema=ProductionSchema;
run;
Move the new cube to
the original production schema.
proc olap rename cube=A outschema=ProductionSchema;
metasvr ...olap_schema=TestSchema;
run;
Enable the new production
cube (make available for queries).
proc olapoperate <server-connection-options>;
enable cube A;
run;