Unable to Reorder Dimensions in Performance Settings Tab

After assigning new dimensions as dense or sparse, you cannot reorder them in the 

dimensional hierarchy. This is a know bug in version 11.1.2.0, but the good news is its been 

resolved in 11.1.2.1.

Why this issue occurs: Whenever we add a dimension in Planning a record is been added in 

HSP_DIMENSION table of the application's relational database. HSP_DIMENSION have 

following columns:

DIM_ID,   ENFORCE_SECURITY,   DIM_TYPE,   DENSITY USED_IN,   DIM_EDITOR,   

DENSITY1,   DENSITY2,   DENSITY3,   DENSITY4,   DENSITY5,   POSITION1,   POSITION2,   

POSITION3,   POSITION4,   POSITION5,   ENUM_ORDER1,   ENUM_ORDER2,   

ENUM_ORDER3,   ENUM_ORDER4,   ENUM_ORDER5,   DRIVER_DIM_ID 

Column Position1 to Position5  corresponds to the position of the dimension in the 

Performance Settings, due to some reasons the value in the position columns become same 

for few dimensions, now when you try to move the dimension members using up and down 

arrow it doesn't work! Here is an example, I just kept position column here and sorted it with 

Position to make it look better:

Here we can see that the values for DIM_ID 33 and 50079, for DIM_ID 35 and 50082, and for 

38 and 50081 are same for Position 1 this is stopping us to move them in the Performance 

Settings to workaround Lets Change them as:

Now, save the changes, restart the Planning Service and try moving the dimension from 

Hyperion Planning Web.

Cheers...!!!

Rahul S.