Cute Trick #5: Calc Manager’s Format Code Button

You know how I recently wrote about a little but great Calc Manager feature hidden in plain sight? Well, what do you know, I was recently discussing some EPBCS calculation performance with my good friend Essbase Down Under, and he showed me yet another one. I’ve since shared this with a couple people that didn’t know about it either, so I thought I’d write about it!

So, it’s this little button: Format Code. And it’s staring at you right in the middle of the screen.

Continue reading “Cute Trick #5: Calc Manager’s Format Code Button”

Cute Trick #2: Using Dynamic User Variables with Prompts

In the EPBCS project I’m working on we use quite a bit of dynamic user variables to control hardcoded vs selectable form columns. We also use a lot of run on save business rules with hidden prompts. We recently had a situation where we had to combine both. The documentation is a little vague on how to actually do it, so here ya go!

Continue reading “Cute Trick #2: Using Dynamic User Variables with Prompts”

Cute Trick #1: Calc Manager’s Best Kept Secret?

Here’s an easy one I thought I’d share, since I continue to find people that don’t know about this feature. Best kept secrets are hidden in plain sight, amirite?

How often do you need to asses re-coding effort because of a potential member rename? Or maybe you’re cleaning up substitution variables (quarantine spring cleaning, anyone?) and need to search for which ones are used where? Did you know the Find feature in Calc Manager not only allows you to search for artifact names, but also code? Without exporting anything?

Continue reading “Cute Trick #1: Calc Manager’s Best Kept Secret?”