Use different aggregation methods for each member of a parent-child dimension | Add a column to the dimension table containing the codes + for addition, - for subtraction, and ~ for no aggregation. Then assign that column by using the dialog box for the Unary Operators property. |
Add a custom formula to a specific member of a parent-child dimension | Add a column to the dimension table and store in it an MDX expression. Then assign that column to the level by using the dialog box for the Custom Members property. |
Enable drillthrough for a cube | In the Cube Editor, click Drillthrough Options on the Tools menu to open the Cube Drillthrough Options dialog box. Select Enable Drillthrough. |
Automatically divide members of a level into groups | Create a new level in the dimension, and change the Grouping property for the level to Automatic. |
Disable levels of a shared dimension | In the Cube Editor, expand the dimension and select the highest level you want to disable. Then set the Disabled property to Yes. |
Write enable a cube | In the Analysis Manager console tree, right-click the cube and click Write-Enable. |
Write enable a parent-child dimension | In the Dimension Editor, change the Write-Enabled property for the dimension to True. |
Create a cube from an empty fact table | In the Cube Editor, change the Fact Table Size property of the cube to 1. |
Add members to a write-enabled dimension | In the Cube Editor, right-click the write-enabled dimension and click Browse. Right-click an existing member, point to New Member, and click either Child or Sibling. |
Create a virtual cube | In the console tree, right-click the Cubes folder and click New Virtual Cube. Using the wizard, select the cubes, dimensions, and measures for the virtual cube. |
Make structural changes to a virtual cube | In the Virtual Cube Editor, click the Edit Structure (Wizard) toolbar button. |
Add a calculated member to a virtual cube | In the Virtual Cube Editor, click the Insert Calculated Member toolbar button. |