SpagoBI – Page 2 – David B. Harrison

SpagoBI report deployment via SDK

Below are my thoughts on approach, capabilities, and limitations on doing automated deployments of SpagoBI reports through the SDK. I welcome your comments and suggestions. If you’re doing something differently, please share. As I now have 12 SpagoBI instances, keeping the reports in Sync on all environments has become a challenge. As a proof of concept, I’ve created a groovy script that can import an Exported-SpagoBI document to a list of SpagoBI servers. (Happy to share that if anyone is

SpagoBI Groovy LOV for Last Day of Last Month

SpagoBI Lookup Value (LOV) in Groovy to get the last day of last month 1 2 3 4 5 6 7 8 9 10 11 12 Calendar cal = Calendar.getInstance() cal.add(Calendar.MONTH, -1) cal.set(Calendar.DATE, 1) Date firstDateOfPreviousMonth = cal.getTime() cal.set(Calendar.DATE, cal.getActualMaximum(Calendar.DATE)) Date prevDate = cal.getTime() //You pick whether you like sprintf or GString better //String returnStr = "${(cal.get(Calendar.MONTH)+1).toString().padLeft(2,’0′)}/${(cal.get(Calendar.DATE)).toString().padLeft(2,’0′)}/${cal.get(Calendar.YEAR)}" //return returnStr.toString() String returnStr = sprintf("%02d/%02d/%4d", cal.get(Calendar.MONTH)+1, cal.get(Calendar.DATE), cal.get(Calendar.YEAR)) return returnStrCalendar cal = Calendar.getInstance() cal.add(Calendar.MONTH, -1) cal.set(Calendar.DATE, 1) Date firstDateOfPreviousMonth = cal.getTime()