After a SAS OLAP cube
is created, it might be necessary to add further data to the cube
without completely re-creating the cube. If a cube is in production,
you must consider what the best process to update your cube is. You
should also consider an approach that will have as little impact as
possible on users. It is important to limit the amount of time that
a cube is unavailable to users while the cube is being updated with
new data. It is also important that the updated cube be checked for
correctness before the cube is made available for queries. To address
these concerns, you can choose either to update a SAS OLAP cube in-place
or to create an incremental copy of the cube.
You can update SAS OLAP
cubes that physically exist and that are generated from either detail
tables or star schemas. You cannot update a fully summarized cube.
Furthermore you must have ReadMetadata and WriteMetadata permissions
for all elements of the cube
New data to add to a
cube can include new members and new data for the cube or additional
data for existing members. You can update a cube using SAS OLAP Cube
Studio or manually using PROC OLAP and PROC OLAPOPERATE.