Groovy – Run FCCS Consolidation

You can trigger FCCS Seeded Rules from groovy business rules. This may be useful if you want to elevate some of your users to trigger the consolidation for a higher level entity parent for instance. All the principles are same as explained in my previous post, approach is same as Sanjay’s data push post as well.

You have to start with a connection definition as usual, target FCCS instance doesn’t have to be a local instance which means you can technically control an FCCS instance from an EPBCS instance. All you need is an environment where groovy business rules are enabled and connectivity to FCCS environment.

Leaving the code snippet here. I have hardcoded all dimensions apart from entity for simplicity. You can apply same logic that entity has to other dimensions if you need to extend this.

/RTPS: {Entity}/
def params = new JSONObject()
     .put("Entity",rtps.Entity.toString())
     .put("Scenario","Actual")
     .put("Year","FY15")
     .put("Period","Jan")
def body = new JSONObject()
     .put("jobType","Rules")
     .put("jobName","Consolidate")
     .put("parameters",params)
     .toString()
HttpResponse jsonResponse = operation.application.getConnection("FCCS").post("/rest/v3/applications/VisCnsl/jobs").body(body).asString();
if(!(200..299).contains(jsonResponse.status)){
     throwVetoException("Error processing RestAPI: $jsonResponse.statusText")
}

I have saved this rule with the name RunConsolidation, and when I run the rule, I can observe it is triggering the Consolidate Rule as follows.