Working with HP sometimes you get to dig in the Planning DB, here is my latest story. Might be good to mention don’t do this home alone without supervision by an adult.

I have been dealing with an applications sited in an older Hyperion (x.2.1) version. And when using LCM, it decided to re-order folders as it wished. “Move” did not do much in the sense of letting me re-order it. Here is a view of me trying to – btw you might notice it’s not the same version as my demo lab is x.2.3. – import the data forms.

In LCM:

LCM

In HP after import with LCM (AppX*) :
InPlanning

Which leaves me with a nice mess. So I decided to have a look at the background.

As I had to somewhere I first had a look at a select statement to get the most common object types counts:

On one of the apps I’m running on my x.2.3 lab, gives this result:
Result01

What about the Folder count per parent, to be able to compare two environments, you need the name and not id as that is probably different from app to app.

So let’s run the query, which just gives us you the count and the names. All the queries from here on were run on our AppX database:
Result02

But let’s go back to the problem that bought me here. You might have already know or notice while reading this the important column is Position as is how Planning knows how to sort the folders. Let’s take the “two ends” of the folders, just for a comparison, as you can see that the folders starting with 1, :

If you don’t know the “Forms” object ID, you can always do this to see the second generation:


Result03

After update has run:
Result04

If we now check our AppX we see this:
InPlanningOrdered

Very easily you can do something similar with TaskLists:

ID_and_POSITION_TaskList

So on the other hand this is how it looks creating folders in Planning:
Step 1:
FolderCreation
Step 2
FolderCreationMove
Step 3
FolderCreationInFolder3
And Step 4 looks like 1, so working as intended, so if you want to re-order you just have to do it with some sql skill.