Import Calculated Cells Dialog Box
Use this dialog box to import a calculated cells definition into a virtual cube from its component cubes.
This dialog box is displayed in Virtual Cube Editor when you perform one of the following actions:
- On the Edit menu, click Import, and then click Calculated Cells.
- Click the Import Calculated Cells button on the toolbar.
- In the tree pane of the Virtual Cube Editor, right-click the Calculated Cells folder, and then click Import Calculated Cells.
Options
Available Calculated Cells
Select the check boxes beside the calculated cells definitions that you want to import. If you want to import all the calculated cells definitions in a cube, select the check box next to the cube.
This box lists only calculated cells definitions that are in the component cubes of the virtual cube.
If you select a calculated cells definition with the same name as a calculated cells definition already in the virtual cube, the selected calculated cells definition is imported with a new name consisting of its old name and a numeric suffix.
Value expression
View the calculation formula for the selected calculated cells definition. To change this formula in the virtual cube, import the calculated cells definition and edit it in the Calculated Cells Wizard.
Show source cubes only
Specifies whether to view calculated cells definitions only in the component cubes of the virtual cube. Clear this check box to view all calculated cells definitions in the database. Adding a calculated cells definition that is not in a source cube of the virtual cube may generate formula errors. After you import a calculated cells definition, you can edit it to fix formula errors or make any other required changes.