What is the Best practice to create automatic reports with Cumulocity

Question

So, I want to use the data I have collected with Cumulocity to create automated reports. The creation of the reports must be automated such that they aggregate accumulated time series, alarm & event data into a single report which is automatically sent to relevant parties through e-mail at a fixed time interval (say, weekly or monthly).

I have a basic idea of how it works with the APIs provided by Cumulocity, but I'm rather intrigued regarding more specific implementations.

Should the data that I want to aggregate be retrieved with CEL (Cumulocity Event Language) and then the report created in the desired format (pdf) with my own script? Could anybody tell me if it's possible to host this kind of script in Cumulocity or should I have to host it myself?

Answer 1

There is a new feature regarding reporting in the cockpit (excel/csv export). It can be scheduled and send via mail. 

Scheduled export configuration

Hope it helps.