I’m not a big fan of performing customization at a client side. However you’ll find that I’ve written a handful of posts about customizing Workspace and Planning.
I’ll explain why I still write posts about customization in a while.
With the new ADF release most of the Planning customizations (ValidateData.js, Grid Spread) are going away (they might come back later, who knows).
How about the form given below, isn’t is nice to have the headers stand out? (I would love to get a different formatting according to the levels in hierarchy)
I did a little bit of research and figured out that it is possible. (Ok it is not possible to do selective formatting, but something is better than nothing
) Starting from 11.1.2.2.300 you can customize the style of header cells!!!!!!Sounds fun isn’t it? (Now you know why I write posts about customization, it is fun )
)Before you start performing the steps, remember to take a backup of HyperionPlanning.ear file
Changing header for all forms
If you like to change the style of header for all forms, then you can follow the steps below.
Open HyperionPlanning.ear file under <EPM_ORACLE_HOME>productsPlanningAppServerInstallableAppsCommon using 7Zip.
Open HyperionPlanning.war file in HyperionPlanning.ear file and navigate to custom folder
1. Create a class in HspCustom.css as given below.
.customheaderStyle{
font-family:Garamond;
font-size:14;
font-weight:bold;
}
2. Create a file called trinidad-skins.xml as given below.
<skins xmlns=”http://myfaces.apache.org/trinidad/skin”>
<skin>
<id>HspCustom.desktop</id>
<family>HspCustom</family>
<extends>blafplus-rich.desktop</extends>
<render-kit-id>org.apache.myfaces.trinidad.desktop</render-kit-id>
<style-sheet-name>custom/HspCustom.css</style-sheet-name>
</skin>
</skins>
<skin>
<id>HspCustom.desktop</id>
<family>HspCustom</family>
<extends>blafplus-rich.desktop</extends>
<render-kit-id>org.apache.myfaces.trinidad.desktop</render-kit-id>
<style-sheet-name>custom/HspCustom.css</style-sheet-name>
</skin>
</skins>
3. Add trinidad-skins.xml to HyperionPlanning.warWEB-INF
4. Update the file with the changes.
5. Redeploy the application server.
6. Restart the application server and clear the browser cache.
7. Add a new application property called SKIN_FAMILY ( Administration -> Application -> Properties)
Set the property value to reference the custom skin “HspCustom”
Set the property value to reference the custom skin “HspCustom”
9. Log out, and then log in.
Changing header for one form
In order to change the header of one single form, we’ve to first get the ID of the form. You can query Planning application relational database and get the ID from there.
Select object_id AS FORM_ID,object_name AS FORM_NAME from hsp_object where
object_name like ‘Plan Revenue – COS’;
object_name like ‘Plan Revenue – COS’;
Class in HspCustom.css will now look similar to the one given below.
.customheaderStyle_51120{
font-family:Garamond;
font-size:14;
font-weight:bold;
}
Follow the steps from 2 on-wards.
Once you log back, you can see the changes.
For the record, I did try playing around with ADF and Trinidad skinning, however none of them worked. It’s good to get back column level (colheader_0, colheader_1 etc etc) customization back.
Let’s hope someone is listening.
Just missing the available styles that can be used… But that's a great Job! 🙂
Is it true that in the current version 11.1.2.4 of hyperion planning, the client side validation using validate.js is not available?
That is gone from 11.1.2.x onwards. You could still make it work by disabling ADF. It is not possible from this version.
Do you test it in 11.124? I tried but without success : Maybe you can give me an advice to do it properly in 124?
Thanks to your help.
11.1.2.4 has all ADF customization. I'm planning to update this one for 11.1.2.4
Hi Celvin,
Thanks to your answer.
When do you plan to update this ? I have currently an issue to wrap text on webform headers. I hope your proposal could help me on this.
Hi Celvin,
I am implementing Hyperion Planning 11.1.2.4 for one of the client. Client want to change the text alignment of the form. Currently all the text values are getting aligned in bottom and numbers are aligned at top. Client want text also to be aligned top. Is it possible to change the alignment of the values in form.
Thanks in advance.
Regards,
Sunil