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

How to retrieve ASO Incremental Data Slice count via Groovy (EPM Cloud Gen 2)?

Hi Experts,


I want a Groovy script to programmatically check the current number of incremental data slices.

I have explored several avenues to fetch ASO statistic programmatically, but hit walls with the EPM SaaS architecture:

  • I attempted to create a local Web Service connection to query the underlying Essbase REST API (/essbase/rest/v1/applications/{app}/databases/{cube}/statistics). While the connection authenticates successfully against standard Planning endpoints (/HyperionPlanning/rest/v3/...), the WAF actively blocks loopback GET requests to the /essbase context root, returning an HTML 403 Forbidden error.

Workaround: I considered using a Groovy script attached to forms/rules to increment a Substitution Variable counter on every save. However, this approach is blind to direct Smart View ad-hoc submits, meaning physical slices will be created without the counter knowing.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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