Predefined Reports

xenn.lake has the ability to examine your data by executing a predefined report template on your data source. For this, you need to declare which template to execute on your data source. Please keep in mind that, the source of the should be applicable to the report template.

xenn.lake discovery module supports Oracle database alert log files, audit log files for the time being. There are also some common pre-processing steps to be run on unformatted XML and JSON files.

To create a predefined report, you need to login to xenn.lake web and click on the <DISCOVERY> Menu from the top menu bar. This will lead you to the Discovery Module of the xenn.lake.

For the first login after a fresh installation, there will be no reports defined. To create your first predefined report, click on <PREDEFINED> button on the left menu. This will lead you new predefined report create wizard. This type of report needs three main steps to be processed.

Enter the necessary information for the report definition;

Report Name: The name of the report you want to create

Report Description: The report description, which helps you to find your report after the creation.

Source Definition: Here you define the source, which your processing will work on. Your source needs to be the direct source of the data which is transferred to Hadoop. Predefined reports can be run on the raw source files only.

Source Name: The name of the source you have defined in the INTEGRATION module.

Source File: The name of the file defined in the source definition.

Click NEXT to go to the next step.

Second step shows you the predefined report templates coded in xenn.lake. You can select one of the predefined reports here. Consider, your source file should be compatible with the predefined template. For example, if you need a predefined database alert log processing, then the source must be a plain text file of the database alerts.

Click NEXT to go to the next step.

Lastly, you should define the repository for the processed data. There are two options;

HADOOP: Processed data will be stored in the Hadoop filesystem.

FILESYSTEM: Processed data will be stored in the OS filesystem.

You should also select the option for the visualisation layer. By default, your processed insight will be shown in the defined format. For this example, the default view type is the LINECHART as defined in the database alertlog alerts predefined report.

Click FINISH to save your report which will lead you back to the DISCOVERY Module where your saved report exists.

As you can see, the status if the report is DEFINED and it did not run for the time being. To examine the insight, your report should be run by clicking on the <RUN> button. Now you can see that your report status changed to RUNNING.

After the execution completed and the report status updates as COMPLETED, now you can examine your insight. Please also aware that Last Run: value of the report is also filled by the last run path inside the Hadoop filesystem.

Now you can click on the report name to see the insight. You can also change the way you examine the insight by changing the view type. To change the view type, use the buttons and selections as well as client filtering on the left panel of the presentation layer.