5.3.2 Programmable Alerts
7.3 Data Management and Data Model Handling
7.3.4 Working with Data Model
7.4 Control Center
7.4.1 License Entitlements
7.5 Platform Settings
Report Generation >
All Reports created by the admin will be listed under the Report Builder, This functionality allows you to generate reports; for instance, generating a Long term data storage report is accessible via the report builder.
The following fields will be displayed.
In addition, there are other options available at the top of the table
To create a report:
Creating a Report consists of two steps and an optional step:
Step 3: Schedule to Generate and Distribute (Optional)
Enter the following details and click on the next tab
This section has 3 tabs to select the source of the Report. The following are the sources:
💡Note: Only one source can be chosen at a time for generating reports.
Now, let’s generate the reports using each of these sources.
💡Note: You can select up to 3 dashboards at once for generating reports. To replace a selected dashboard, click delete, and then proceed with your desired selections.
From the Time Filter option, set the exact time range for the reports you want to generate.
Additionally, you can download the reports. Just click the Download button to get the report.
When you click Download, the report will be downloaded directly to your local system from the user interface.
Now, let’s create the Reports using the Data Source.
Supported data sources include:
a) NoSQL Timelion Query
The user can provide the ES Timelion query in the ES Query.
b) NoSQL DSL Query
The user should provide the NoSQL Query along with the respective index for that query
You can refer to the annexure, for a sample Elasticsearch Queries
c) Long-Term Storage SQL Query:
For the Long-Term Storage SQL Query, the user can provide the Long-term data store query.
d) Internal Storage SQL Query:
For the Internal Storage SQL Query, the user can provide the MySQL query.
You can refer to the annexure, for a sample Long-term storage Queries
Data Summarization for Long term data storage
The user can generate a report based on the raw data, daily data, hourly data, and weekly data.
Users need to write queries with the raw table name irrespective of the time period. If the query has a time filter, the system will identify the table from which the data has to be fetched as per the time period.
Dynamic Filters in Long term data storage
The Admin Users can include dynamic filters in the SQL query based on their use case. Using Dynamic Filters, the admin user can grant users permission to view and edit reports based on the specific user utilizing that report.
Charts in Long term data storage
The admin user can pick from three chart types: Line chart, Area chart, and Vertical Bar chart for their reports. They can also add a chart title and choose values for the X-axis and Y-axis.
💡Note: Only numerical values are available under the Y-axis
i) Line Chart– The generated report will be visible in the line chart format.
ii) Area Chart– The generated report will be visible in the Area Chart format.
iii) Vertical Bar Chart– The generated report will be visible in the bar chart format.
The Admin user can edit the text of the header column by clicking on Customize Columns. The user can omit the columns that are not required in the report by unchecking them.
Therefore, this is all about creating reports using a Data source. Now, let’s move on to creating Reports using the Data Model.
Select the required Data Model and Metric. Click on Submit to preview the data.
The step consists of 3 collapsible sections as follows:
💡Note: The CSV format can not be used to generate Reports for
1. Dashboard as a report
2. Long-term data storage report using chart
This section is used for the scheduling frequency of the report.
Click on the Radio button to toggle Schedule Reports.
After setting everything, click Save to create the Report. You’ll see the new Report on the Report Builder page.
This feature lets you choose how date fields appear in reports. The default format is DD/MM/YYYY hh:mm: ss.
You can delete the reports either using the Delete button at the top or under the Action column.
To view the Report, click on the clickable report name.
On clicking, you will be redirected to the following page. Here you would only be able to view the reports.
To Edit the Report, click on the Edit button located under the Action column of the respective Report.
On clicking, you will be redirected to the following page
To make any changes in Reports, the following action buttons are available in the top right corner.
With object-level permissions, the user who has admin permission will be able to edit and delete the report. Click on Permissions to manage Object Level Permissions in Reports.
The screen will look like this.
For every role, you can give 3 types of permission.
You can generate reports from this tab, or you can access the Generate Report button under the Action column. More information is available in the following section.
After making changes at any step according to your desired configuration, proceed to click the Update button to save the changes. Otherwise, click the Cancel button to discard the changes made. For instance, if you want to edit the Report-DataModel report, click on the edit button under the Actions column, and make the changes.
After making changes, click on Update.
The changes made have been updated.
This option will allow you to duplicate existing reports if you wish to use the existing reports as a template.
On clicking the Duplicate report the pop-up will appear, and by default, the report name will be suffixed as ” _copy” to have uniqueness. For example, a duplicate DataModel report will be named Report-DataModel_copy. Users can also rename the report at a later time.
Click on Save to make a copy of the report.
Browse through our resources to learn how you can accelerate digital transformation within your organisation.
VuNet Systems is a next-gen visibility and analytics company that uses full-stack AI & Big Data analytics to accelerate digital transformation within an organisation. We provide deep observability into business journeys to reduce failures and enhance overall customer experience.
© 2023 VuNet. All Rights Reserved.