Helical Insight provides user the flexibility to apply database functions on different data formats like Text, numeric, date, time, date-time etc. Following are the steps to apply database functions: Step 1: After getting the columns in the selection area, click on the downwards arrow on the column and then click on ‘More’. Step 2: Users
As Helical Insight supports Multi-tenancy, users would like to see data which is relevant to them. For example, Sales managers would like to see the reports/dashboards of sales data, Finance managers would see only financial reports etc. For that, ‘Metadata security’ feature can be used in which user can grant or deny the permission of
Helical Insight provides the user with the functionality of exporting the Reports/Dashboards into various file formats. Some of the file formats that Helical Insight supports are PDF, JPEG, PNG, Excel etc. Note: Users can also add a new ‘Exporting file format’ like .PPT by using exporting APIs Following are the steps to export a Report/Dashboard:
A View is nothing but a virtual table based on a result set of SQL statement. It is mainly used for designing complex reports in adhoc or when certain pre-calculations are required, which then can be used in the adhoc interface as columns to create reports. These Views are basically stored in local Helical server.