Workforce issue while enabling custom dimension


This was an issue I got in the 11.1.2 Planning version (I’ve never tried the in-built workforce module till now) when I tried to enable some custom dimensions in Workforce.

I enabled Capex and Workforce when I created the application and after a while I thought of adding Currency dimension in both Capex and Workforce.

Since the application was already created I went for a Database “Refresh”.

All the 3 Plan types and Capex restructure worked well, however Workforce give me an error, which indicated that it was crashing the Essbase server.

Creating rebind thread to RMI

d{ISO8601} WARN [ACTIVE] ExecuteThread: ‘0’ for queue: ‘weblogic.kernel.Default (self-tuning)’ com.hyperion.hbr.security.HbrSecurityAPI – Error retrieving user by identity

com.hyperion.planning.olap.EssbaseException: Network error [%s]: Cannot Receive Data (1042013)
at com.hyperion.planning.olap.HspEssbaseOutlineAPI.EssRestructure(Native Method)
at com.hyperion.planning.olap.HspCubeRefreshTask.buildOutlines(Unknown Source)
at com.hyperion.planning.olap.HspCubeRefreshTask.run(Unknown Source)
at java.lang.Thread.run(Thread.java:619)


John Good Win (through OTN forums) asked me to perform a Database “Create” instead of “Refresh”, mine was a sample experiment Application and I had no issues doing this.

I think the “Create” option made 11.1.2 Planning to think a while and gave me some meaningful errors. 🙂 (Previous error was an indication that it is crashing the Essbase server, but it was not).

The error was caused due to member formulas in the below given members.

“SSTax Rate1”
“SSTax Rate2”
“SSTax Cap”
“SUI Rate”
“SUI Cap”
“FUTA Rate”
“FUTA Cap”
“Medicare Rate”

They are having a formula similar to the one given below,

[OpenInputValueBlock]
 [CrossRef(“SSTax Rate2 Input”)]
 [CloseInputValueBlock]

When converted into Essbase terms the formula was showing up as

 “BegBalance”->”No Scenario”->”No Version”->”No Entity”->”No Employee”->”No Currency”->”SSTax Rate1 Input”;

So now I learned that each custom dimension added it should have “No <Dimension name>” as a member in it. (It was the first time I was using the in-built workforce module) 🙂

I agree to the point that Workforce will require modifications according to your needs, but I strongly believe that the error logging of 11.1.2 has to improve a lot.
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