#groovyrocks

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…

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…

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…

Get ready for a Smarter Smart Push - Quick Tip # 4 #GroovyRocks #OrclEPM #SmartPush

I’m on a project where Smart Push is used quite a lot to create a Real-Time ASO reporting application, and this one was an annoying issue.

While performing the Smart Push (Roshin and Varun, my partners in crime) found that it takes an awful lot of time to move the data if we use the ILvl0Descendants(Account) function. If I add the accounts manually (level 0 member count from the function –…

@ATTRIBUTE function in Groovy - Quick Tip # 3 #EPM #GroovyRocks #OrclEPM #DataMaps #DataMapsForLargeDataMovement

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

This post is a follow up to what we did with UDAs. The culprit today is @ATTRIBUTE, BSO calc scripts, and DATA Map.

If you take a look at Data Map member selection, you will find that there is no option to push data using ATTRIBUTEs.

I decided to use Groovy and override the member selection while performing…

@UDA function in Groovy - Quick Tip #2 #EPM #GroovyRocks #OrclEPM

I got an email from colleagues of mine asking, “How can we use UDA function in Groovy?”

I was a bit surprised to hear that. Now, they did clarify that they want to use @UDA function in Data map/Smart Push.

I was half sure that it is not allowed. I still thought of making sure of that before I say anything 😉

Here are all the functions that are available while you create a Data Map.

Now…

Copy version and Push data to ASO using Groovy #DataMapsForLargeDataMovement #EPM #GroovyRocks #OrclEPM

I guess you all might have implemented a reporting application along with the planning application. If you are not, please start doing that from now on.

When you have got a reporting application, you’ll always want both (planning and reporting) to be in sync. Smart Push (on Planning Cloud) lets you sync the data in real-time.

I would also like to point out that you do not use Smart Push if…