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
-
On the Databases tree, right-click the dimension you want to work on and
click Edit dimension.
- Click the Members tab on the dimension editor.
- 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.
- 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.