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.
My Questions:
- Is there an undocumented Groovy method or an internal EPM Planning REST endpoint that exposes ASO storage statistics (specifically the incremental slice count) at runtime?
- Has anyone found a supported workaround to fetch this value dynamically?
Any insights or alternative architectural approaches would be highly appreciated!
TIA,
Shubham