How to sort Planning Webform folders


Merry Christmas and to those who are not celebrating, Happy Holidays
It is hard to type without two fingers šŸ™ So I’ll make this short. Oh, I cut two of my fingers within two weeks time frame, so it is an eventful vacation.
I’ve often heard this question about sorting webform folders. I’m not sure why this feature has not made into Planning yet.
There are different ways to achieve sorting of Webforms (1st the supported way and the next – the unsupported way).
Supported/Oracle recommended way
1. Export existing forms.
2. Create the folders in the order you need
3. Import the forms back
There were times where I couldn’t make this work. I guess it was because I was not doing it right šŸ™
Just for kicks šŸ™‚ I was looking for an option to see whether this can be achieved in an easier way.
What I’m going to describe below is an unsupported way, continue at your own risk šŸ˜‰
1st step is to find out the object_id and the position of the folders
1. Object_id and position of the folders

SELECT 
	OBJECT_ID,
	OBJECT_NAME,
	POSITION 
FROM HSP_OBJECT 
WHERE OBJECT_TYPE=1 AND 
	  PARENT_ID=9  -- PARENT IS FORMS ORDER BY POSITION;
You can use the above given SQL for that purpose.
Let’s say the client want to make Forecast as last folder.
You can go the supported route and import the forms back, or you can update the position of Forecast.
Commit the changes and restart the services. Ta da
I’ll be seeing you next year, so Happy New Year in advance.
Hope to see the Rise of Hybrid next year. (can’t wait long)

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with ā€œIntekgrate Corporationā€ based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.