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/essbasecontext root, returning an HTML403 Forbiddenerror.
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.
Tagged:
0