is there a way to generate a dataset column by writing some business logic around this using some script or Rule engine?

Question

I am new to Spago BI and I have installed Knowage 6.1, I have mapped my dataset to a mysql table and I want to create an extra column in my dataset that will be calculated based on some business logic implemented on some existing columns in my dataset.

how to achieve this?

Answer 1

Hi,

   You should be able to define datasets of type script (javascript or groovy) or query with scripts sections.

You can find details into the Knowage_6.x_CE_Manual.pdf - Dataset section (3.3 Data set configuration).

Regards.