#calcmanager

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

Where are Groovy functions in 11.1.2.4.900?

Where are Groovy functions in 11.1.2.4.900? #CalcManager #OrclEPM #Patching

Now don’t ask me what 11.1.2.4.900 version is. If you’ve not read about it, there are plenty of articles out there which talks about this release.

There is no supported upgrade path for this release, and you’ll have to create new applications if you are planning to move to this release.

I did install this new version on my Virtual box image and was planning to write a blog post on an…

View On WordPress

[cvkattookaran]

Metadata loop using Groovy scripting in EPM Enterprise Cloud

Metadata loop using Groovy scripting in EPM Enterprise Cloud #CalcManager #GroovyIsAwesome #OrclEpm #EPM

When I wrote the blog post on using Metadata loop in Calc Manager Pete Nitschke commented on it. His comment was related to dynamic dimensions. If you are using a Metadata loop on an always-changing dimension like Entity/Account), then you’ll have to redeploy the rule after a metadata change.

Bummer!!!

I thought that was the case with Essbase rules, after a quick chat with Sree Menon from…

View On WordPress

[cvkattookaran]

Create a Metadata loop in Calc Manager

Perform a Metadata loop in Calc Manager #CalcManager #EPM #OrclEPM

I’m on a project right now where I’m looking at optimizing an On-Prem migration to the cloud which went wrong.

I guess most of you are familiar with the best practices while writing an Essbase calculation script. I bet you all know how to use an IF condition inside a FIX statement.

We all know that Scenario is DENSE in sample basic application. Let’s changes the setting and make it a…

View On WordPress