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.

Comments

Post a Comment

Popular posts from this blog

Dynamic Calc Members Are Not Auto Calculated in EPBCS

Image
Background: We had a dynamic calc member with a member formula but it wasn't getting calculated automatically. We had to aggregate account dimension in order to calculate dynamic calc values. This defeats the purpose of having a dynamic calc member.  After researching further we got to know the reason of the issue and a solution.  Here is how we can replicate the issue: Create  a TestMember, which Never Share or Store property: If you will go  to the member formula tab, data storage for default cube and OEP_WFP cube will be Never Share:   Let's edit this member and change the storage property to Dynamic Calc: You will notice data storage will change for the Default Cube: But if you look further data storage will still be never share for OEP_WFP cube. For us, initially when we loaded some members, we had the storage property as Never Share, which we later changed to Dynamic Calc, but internally it was still N...
Read more

The Member Does Not Exists For The Specified Cube

Image
The member "" does not exist for the specified cube or you do not have access to it. Issue:  If you are running into a issue, where for a RTP member selection is throwing an error for a missing member, this regardless of the member you have selected in RTP or regardless of rule. You may be able to execute the rule from Calc Manager and not from Planning. Reason: You may run into this issue if: 1. You have added members in Planning and have not refreshed the cube 2. For the default value of a RTP in calc member you have a member which is not valid any more for planning application 3. For the default value of a RTP in calc member you have a member which is not valid any more for a plan type Solution: 1. Refresh cube 2. Update Default value of RTP which is causing issue to member which exists 3. Deploy the rule Rahul S.
Read more

"Smart View handled an unknown exception thrown by Microsoft Office" Error on Vista, Windows 7, Windows 2008

My MS-Office Components are Crashing After Installing Smart View on Vista, Windows 7, Windows 2008! This is one more one pretty common issue,   "Smart View handled an unknown exception thrown by Microsoft Office."   This is actually a known issue in version 11.1.2.1. If you look at the read me of Smart View you will find bug# 11696583 "On Vista, Windows 2008, and Windows 7 operating systems, Excel may terminate abruptly upon launching after you install Smart View. Workaround: Turn off “User Access Control” in User Accounts, available from the Control Panel." Here is the link to read me: http://download.oracle.com/docs/cd/E17236_01/epm.1112/readme/sv_1112100_readme.html When the User Access Controls are on Smart View faces problem in registering, when you set it off Smart View register itself like a charm. To have more information on UAC: http://technet.microsoft.com/en-us/library/cc709691(WS.10).aspx Now, when y...
Read more