Add a virtual member to the cube.

When you press the  Add or Edit button in section Virtual member creation , we get the following dialog:

This dialog will let you define a new cube formula. These formulas must be in one of the cube dimensions, although normally they will be part of the Measures dimension.

This dialog options are:

• Dimension : This field will be part of this dimension.
• Name : Is the name of this formula or virtual member being defined. This name must be unique in its dimension.
• Fields : This is a list of the existing fields you can use as part of the new formula definition. Double click on this list to insert this field in the cube formula.
• Member: This is the new formula definition. This formulas are in MDX language, that is the cube manipulation language used by Microsoft. It is beyond the scope of this manual to teach MDX, but you can get more information at the following Internet addresses: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnolap/html/intromdx.asp, or at  http://msdn.microsoft.com/library and search for  MDX.
• Format : You can choose an output format or write your own display format for this field.
• Formula : This is a list of MDX functions that can be used to create new formulas. See the Database formulas to get more information about this issue.

Press the OK to create the formula and Cancel to exit this dialog without creating the formula.