Tag: BI

Uncategorized 4 comments

SpagoBI – Exporting and Importing Report Documents

Step-by-step instructions for Exporting a report document from one server and importing into others. Steps In the source SpagoBI Environment, go to Import/Export Then, select the documents you want to export. Name the export (20 character limit?) ex:  2015-12-30-scheduled-cand Then, press the export icon When the “Download” link appears, click it Now, You’ve now got a zip file (in downloads) containing the two reports and meta-data about them.  Sign out of POC / DEV This file must have the exact

Read more
Uncategorized One comment

SpagoBI DataSet Webservice via Groovy

SpagoBI DataSet Webservice via Groovy UPDATE: THIS IS A GREAT IDEA, EXCEPT IT DOESN’T WORK IN THE FINAL STEP.  Per SpagoBI Support: Groovy cannot be used in a script-based Dataset to provide rows of data. According to the last support ticket, there is no intent to make that work. SpagoBI Support also states that the Web-Service Dataset is deprecated and so far refuses to document how to use it. Note: I have not yet figured out how to get a SpagoBI Data Set

Read more
Uncategorized 2 comments

Upgrading Groovy in SpagoBI

Groovy Language It is possible to create a SpagoBI Script (Groovy-based) Data Set which calls a web service and returns data in the standard XML format needed by consumers of SpagoBI Data Sets. As a proof of concept, I used Groovy-WS Lite (a Groovy SOAP/RESTful client library, which required a newer version of Groovy than that which shipped with SpagoBI 5.0 (Groovy 1.5.x). So, it was necessary to replace the Groovy-all library jar with a later version and add the

Read more
Uncategorized 5 comments

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

Read more