Updating SAS OLAP Cubes |
You can update the captions and descriptions for a cube without adding data to the cube. This is considered a nonstructural update and can be performed on a cube with the UPDATE_DISPLAY_NAMES option for PROC OLAP. This option enables you to identify captions and descriptions on a cube that will change. Here is an example:
proc olap cube=cubename description="new description" UPDATE_DISPLAY_NAMES dt=newdtname; metasvr options; dimension time description="New TimeDescription" caption="New TimeCaptions";
Note: The only description that can change when a cube is renamed is the cube description (the drill-through table name might also be changed during a rename). Other descriptions and captions must be altered in a separate step after the cube is renamed.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.