You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Horrendeously slow running business rule

Received Response
5
Views
8
Comments
edited Aug 2, 2018 2:36AM in Essbase 8 comments

Summary

Horrendeously slow running business rule

Content

Hi,

I have a business rule which runs in seconds when I run it for a single combination of sparse / dense members, i.e. with prompts for cost centre, entity and division - all sparse members

When I try to take the prompts off the script runs for over a day, with no other jobs running and after a restart.

My pain point is that I need to avoid changing data in closed periods, but it is not as simple as just fixing on open periods because I have some Accounts -> Start Month, End Month, Salary Increase Month which I need to compare to the month being processed to see if I need to clear values from that month.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!