The initial setup was straightforward, but when we wanted to achieve certain use cases, it started becoming complex.

For example, we tried the PPM data, which was connected to Spotfire and we were supposed to have some feature columns or engineer columns. If I needed to put it on, I needed to create a calculated column for that. When we were working on the calculated column, the metrics wanted some more data to be taken from other tables. I needed to join two tables and calculate the calculated column.

When we started connecting the calculated column necessary, the source of all that the column was was not properly coming.

When we put it into reports, it was really slow. Whenever the client or someone was opening the report it would take around 15 to 20 minutes to open the first time. That was a problem. We needed to go for caching at the server level, and that's where we were able to improve the performance by 10 minutes. For cross tables, we had to identify some scripting so that certain columns could be displayed properly. 

Deployment ended up taking about 15 days.

The initial setup is straightforward.

The initial setup was quite complex. I did it by myself. Between 2010 and 2012 I was working for TIBCO South Africa and those are the tools that we were using. Then I moved to other companies but still continued the implementation process.

The initial setup is straightforward.