#longliveonprem

Check whether the entered value is an Integer in Planning webforms - Part I #LongLiveOnprem #OrclEPM #ValidationRules

This a draft I resurrected after 5 years. Yes, it is late. However, this is still relevant. Today we going to look at how to achieve this in both On-Premises and Cloud.

A few years back a friend of mine asked me this question, “How can I check whether a value entered in a webform is an integer or not?”

Back then, the only options were.

Create a validation rule and let the user know that…

Inline Calculation rule and syntax checking - Quick Tip # 9 #GroovyIsAwesome #LongLiveOnprem #OrclEPM

What if I tell you that syntax check in Essbase is overrated.

You are probably going to tell me that I’m crazy or stupid, or you might even think that I’m Bill Gates.

I’m not any of those (maybe a bit crazy) :).

You are probably going to hear about this specific solution in one way or another at a later point in time. However, I thought of pointing this out for you (if you are using…

Dynamically assign text value in a calc script - On-Prem Hyperion Planning #EPM #GroovyIsAwesome #LongLiveOnprem

I guess all of you are familiar with Planning Text members if you are not; Hyperion Planning allows you to enter free form text in Webforms and Smart View.

Text value gets stored in a relational table HSP_TEXT_CELL_VALUE, and a number TEXT_ID goes into Essbase.

When a user requests for this member with the correct intersection, Essbase sends the number back, then Web/Smart View converts…

EPM 11.2 is released #LongLiveOnprem #NewReleases #OrclEPM

Oracle Hyperion Enterprise Management (EPM) 11.2 was released on Dec 18th, and I guess that was an important day for the EPM/CPM market. OneStream 5.3 version was also released on the same day.

I opted to download Planning Plus, and the installer size (11 items, including the client installers) is 16 Gb.

I found out that (even in 2019) there are issues with spaces!. Well, part of the…

How to find out the RTP values for a user-initiated calculation - On-Prem Hyperion Planning #GroovyIsAwesome #OrclEPM #LongLiveOnPrem

If you read my blog post on How to find out RTP values for a user-initiated calculation, you might be thinking, “Celvin, that is for Cloud, what about On-Prem.” If you were one among those, then this post is for you.

On-Prem gives you the luxury of looking at the backend tables and figure out what exactly happens behind the scene. If you have got that knowledge, you can apply that same for…