Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Invoking a Cube Refresh via Business Rule — Cloud Customer Connect
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

Invoking a Cube Refresh via Business Rule

Accepted answer
84
Views
39
Comments
edited Feb 13, 2020 2:41PM in Planning 39 comments

Summary

I am trying to create a business rule that executes the Cube refresh

Content

I am trying to create a business rule that executes a cube refresh. I have created a job called "cube_refresh" and tried to execute via groovy script.

 

However it doesn't invoke the cube refresh. Any help is appreciated.

Below is the code i am using.

 

Thanks

 

 

Version

20.01.33

Code Snippet

// Refresh the cube
 
 
 def refresh = new JSONObject()
 .put("jobType","Cube Refresh")
 .put("jobName","refreshcube")
 .toString()
 
 
 
 // Call DM POST REST API to refresh the cube.  
 HttpResponse<String> jsonResponse = connection("https://xxxxxx.epm.em2.oraclecloud.com/HyperionPlanning/rest/v3/applications/appname/jobs","username","password").post()
 .header("Content-Type", "application/json")
 .body(refresh)
 .asString();

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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