How to create a custom member formula in a write-enabled dimension

To create a custom member formula in a write-enabled dimension

1. (Only parent-child dimensions can be write-enabled.) Access the dimension that will contain the custom member formula:
   • If the dimension is shared, in the Analysis Manager tree pane, right-click the dimension, and then click Edit. In Dimension Editor, on the View menu, click Data.
     
     
   • If the dimension is private, in the Analysis Manager tree pane, right-click the cube that contains the dimension, and then click Edit. In the Cube Editor tree pane, right-click the dimension, and then click Browse.
2. In the dimension members pane, select the member for which you want to create the custom member formula.
   
   
3. In the custom member formula pane, create the custom member formula. Use any combination of the following methods:
   • Type.
     
     
   • Click the arithmetic operator buttons and parentheses buttons.
     
     
   • Click the edit (...) button to access MDX Builder in which you can construct the custom member formula with drag and drop techniques. After you are done in MDX Builder, click OK.
4. If the dimension is private, in Dimension Browser, click Close.
   
   
5. In the editor, on the File menu, click Save.

See Also

Creating Custom Member Formulas