PowerDesigner can update your facts and dimensions in a
multidimensional diagram representing a cube to reflect changes made to your operational
tables or simply to add or remove dimensions, measures, or attributes.
- Select the cube fact in the multidimensional diagram you want
to update, and then select to open the wizard.
- Select the operational tables from which to build dimensions
around your facts, and then click Next.
By default, PowerDesigner selects only those tables that you have previously
selected as dimensions.
- Select fact table columns as measures or attributes of your
facts, and then click Next. By default,
PowerDesigner reproduces your previous choices and you can drag and drop columns
between the Candidates, Measures, and Attributes trees as necessary.
- Review the objects that will be generated, and click Finish to begin the generation.
The wizard updates your multidimensional diagram to reflect
your new choices.