Chapter Summary

ToDo this
Use different aggregation methods for each member of a parent-child dimensionAdd 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 dimensionAdd 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 cubeIn 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 groupsCreate a new level in the dimension, and change the Grouping property for the level to Automatic.
Disable levels of a shared dimensionIn 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 cubeIn the Analysis Manager console tree, right-click the cube and click Write-Enable.
Write enable a parent-child dimensionIn the Dimension Editor, change the Write-Enabled property for the dimension to True.
Create a cube from an empty fact tableIn the Cube Editor, change the Fact Table Size property of the cube to 1.
Add members to a write-enabled dimensionIn 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 cubeIn 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 cubeIn the Virtual Cube Editor, click the Edit Structure (Wizard) toolbar button.
Add a calculated member to a virtual cubeIn the Virtual Cube Editor, click the Insert Calculated Member toolbar button.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.143.9.115