#orclepm

[cvkattookaran]

Check whether the entered value is an Integer in Planning webforms - Part II

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

We did see how to perform this check on an On-Premises version of Hyperion Planning. Now, let’s look at how this can be enhanced using Groovy on an Enterprise Planning instance.

I’m using the Sample Vision application, and the form in question is “Revenue Plan – Revenue Assumptions.”

We are trying to prevent users from entering non-integer units. Groovy Planning rules in Enterprise Planning…

View On WordPress

[cvkattookaran]

Check whether the entered value is an Integer in Planning webforms - Part I

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…

View On WordPress

[cvkattookaran]

Inline Calculation rule and syntax checking - Quick Tip # 9

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…

View On WordPress

[cvkattookaran]

Level 0 DESCENDANTS Of @Sibling function in Groovy - Quick Tip # 8

Level 0 DESCENDANTS Of @Sibling function in Groovy - Quick Tip # 8 #BSOFunctionsToGroovy #EPM #GroovyRocks #OrclEPM

If you have not read the post on @UDA function in Groovy and @ATTRIBUTE function in Groovy, please do that now 🙂

This post, we are going to look at how to get all the level 0 members of all sibling members of a user prompt.

If you look at the screenshot below and if the user selects East as the Market RTP value, then the script must provide California, Oregon,…Iowa, and Colorado.

Groovy…

View On WordPress

[cvkattookaran]

Row number in Hyperion Financial Reporting - Quick Tip # 7

Row number in Hyperion Financial Reporting - Quick Tip # 7 #OrclEPM #ReportingTricks #StillHFR

I never thought I’d be writing a blog post on Hyperion Financial Reporting in 2020!

However, here we are. HFR is still used and loved by the financial community.

I got this question from someone who was looking to add row numbers to an HFR report.

I was like, “This should be something like an in-built function. However, it is not”. The second thought was, “Why cannot we use the Rank fun…

View On WordPress

[cvkattookaran]

Delete year members from On-Premises Hyperion Planning

Delete year members from On-Premises Hyperion Planning #OnPremIsStillAlive #OrclEPM #DeleteYear

I got an email from a friend mine asking, “How can I delete year members from Hyperion Planning?”

I was thinking, “Isn’t there a delete icon to do so?” Then I suddenly realized that the feature was only available in the Cloud version.

I thought of trying this on the new 11.2 Vision application, and here is the year dimension.

FY28, FY29, and FY30 were added accidentally, and now I want…

View On WordPress

[cvkattookaran]

Custom Access control report from Planning Cloud

Custom Access control report from Planning Cloud #OrclEPM #RESTAPI #GroovyRocks #AccessControl

You might be thinking why I’m writing about creating an access control report when Cloud has an inbuilt access control report.

If you are thinking about the access control card from Tools cluster, that is not the one I’m looking for. I’m after the “Access Control” report that On-Premises used to provide, which gives you information on dimension and object-level security.

It is buried under…

View On WordPress

[cvkattookaran]

Extract Planning dimensions in a level format

Extract Planning dimensions in level format #DimensionExtract #GroovyIsAwesome #OrclEPM

I sometimes try to answer questions on Cloud Customer Connect and found a question that was posted there really interesting.

Joe wanted to know whether PBCS dimensions can be exported in a level format. I thought about that for a while and came up with two options.

Export the outline, create an On-Premises cube and use OutlineExtractor

Use groovy to generate the file for you.

The first option…

View On WordPress