Issue with Shell Escape and @CalcMgrExecuteMaxLScript

Thought I’d post a little tip that could prove useful to others that are looking to use the @CalcMgrExecuteEncryptMaxLFile and @CalcMgrExecuteMaxLScript Essbase functions (CDFs). I often find the ‘shell’ command that is available with MaxL scripting to be very useful. According to the Oracle technical documents the ‘shell’ or ‘Shell……

Continue reading

Using escape character (\) to retain quotes in Essbase dim builds

Hello fellow Essbasers, I thought I’d pass on a little tip for an issue you may come across when creating an Essbase dimensional build. Occasionally you may need to build outline members that require quotes in one of the dimensional build fields (typically involving member formulas). Let’s take the following……

Continue reading

Workflow Task Calculate Name and Calculate Parent features

DRM (Data Relationship Management) version 11.1.2.4.341 brings some new features to DRG, specifically to the workflow tasks and in this post we will talk about the Calculate Name and Calculate Parent features. (Hopefully, a Calculate Description option will be added in a future release) Before I start, I just want to mention that……

Continue reading

Reduce size of Runtime Prompts in Hyperion Planning applications

Hyperion planning users sometimes, when running a business rule that require some kind of selection through a runtime prompts window will complain that the OK and Cancel button are not displayed on their screen, as seen below. The runtime prompt window is too big for their screen resolution, so those buttons……

Continue reading