#groovyisawesome

[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]

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

[cvkattookaran]

Dynamically assign text value in a calc script

Dynamically assign text value in a calc script #EPM #GroovyIsAwesome #OrclEPM

This blog post is similar to the On-Prem one. We did see how to create text value from the rule dynamically, it’s now time to see how this can be done on Cloud.

When you are on Planning Cloud, you do have more options than on-premises. You can solve this in a few different ways.

What we are trying to do is generate text value from a rule, if you are looking for an option where the user is…

View On WordPress

[cvkattookaran]

Dynamically assign text value in a calc script - On-Prem Hyperion Planning

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…

View On WordPress

[cvkattookaran]

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

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…

View On WordPress

[cvkattookaran]

How to find out the RTP values for a user-initiated calculation

DATACOPY to a file with RTPs in file name #EPBCS #GroovyIsAwesome #OrclEPM #RESTAPI @orclepmblogs

Have you ever wondered how to create a document that details which calc manager rules we’re executed by the user and what RTPs they used?

If you never did, a friend of mine did. He asked help on this on a private group, and I believe this was before 19.06 Cloud release. The idea was to write a DATAEXPORT script with the RTPs to extract a single line of data, that contains the RTP values.

I…

View On WordPress

[cvkattookaran]

Copy Cell Notes using a calc script

Copy Cell Notes using a calc script #CalcManager #GroovyIsAwesome #OrclEPM

The origins of this post date back to my old blog and 3 years. It was in my drafts for quite a long until I decided enough was enough 🙂

You might have seen the option to copy comments while performing a “Copy Version.”

3 years back (or longer) somebody asked on my favorite forum Network54 about copy comments using a business rule, that could mean

Copy comments only – no data

Copy…

View On WordPress

[cvkattookaran]

Documenting Business Rules on a Webform

Documenting Business Rules on a Webform #GroovyIsAwesome #OrclEPM #Tricks

I got this question from a colleague of mine.

“Is there an easy way to analyze the Business rules attached to a form?”

I’ve written about a few queries on documenting the usage of menus, calculation scriptsand was hoping that it’ll be useful. However, this is a cloud instance, and the blog post is not helpful anymore. One way to do that will be to open the forms in the Form editor and look…

View On WordPress