Change History Years in Planning


I was using the Sample Planning application to test a validation rule of 11.1.2

When I tried to create the application (Manage Database -> Create), it gave me errors!!!

The issue was due to the fact that the formula members(members that are having a formula in it) has FY09 in them, where as the start year for Sample Planning application is FY10. (I think this is a bug, someone forgot to clean up the code for Sample App).

I’m a lazy guy and I didn’t like to go to each member and correct the formula. So I thought of changing the Year FY10 to FY09, but we know that once Planning application is created you cannot add History years. I had to manipulate the backend tables to get this working.

Note: This is not a supported/recommended way

There is a table in Planning repository which keeps the Year information, and is called as HSP_CALENDAR.

So I changed the FIRST_YEAR column value from 2010 to 2009


The value that you see in CURRENT_YEAR comes from HSP_OBJECT table.


Run a SQL query against HSP_OBJECT table.


 select * from HSP_OBJECT where OBJECT_NAME like ‘FY%’;


Change FY10, FY11, FY12, FY13 to FY09, FY10, FY11, FY12



Update HSP_CALENDAR FIRST_YEAR column to the new year.

Commit the changes and restart Planning services, thats it. Now I’ve have FY09 in my Planning application, (I can add FY13 later from Planning itself).


I was able to deploy the Sample Planning application without any errors.


Sample application was a fresh application and there was no need to backup any data. But if you are doing this in a Prod/Dev/Test application, then you have to take a back up of the schema, data, etc.


Hope it helps.
Advertisements

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

0 thoughts on “Change History Years in Planning