Change the type of members to numeric or text in Planning Analytics Workspace

You can change the properties of a member to make it numeric or a string (text). You can also change the weighting of a member.

Make sure that all members that are strings in a cube are in the same dimension, along with any pick list members. The dimension that contains string members and pick list members must be the last dimension in the cube.

Procedure

  1. On the Databases tree, right-click the dimension you want to work on and click Edit dimension.
  2. Click the Members tab on the dimension editor.
  3. To change the type of a member, select the member name, then select the desired member type in the Type column.

    You can set a member type to Numeric or String. You can change the member type only for of leaf member.

    Note: Dimensions that contain members that have the String type, or are pick lists, must be last in a cube. String type members and pick list members must be in the same dimension.
  4. To change the weight of a member, select the member name, then enter the desired weight in the Weight column.

    Weight can be used to change a positive value to a negative value, often -1.

    For example, if the unit price for a product is EUR 50 and the discount is EUR 5, apply a weight of -1 to the discount member. Applying a weight keeps the addition result logical. To find out more, see Weights.