Work quickly and easily in Lighthouse21


First, you define Connection to your data sources, e.g. your economic system, payroll, attendance, production or CRM. You can define several connections simultaneously.


Then, you define Query for selecting data from a source, sometimes referred to as "metadata". In the query definition, you can use a dictionary of terms for the data being displayed. Also included is a filter specification for selecting data, e.g. from-to date, customer list, item interval, etc. You can also include formulas for calculating indicators in the query. Financial statements are a special data source.


After defining the Query you do the Authorization of users. This will ensure that users have secure access to the data they need. For example, the user cannot see sales price data.


The next step is to design your own report or analysis. In the "View" definition for displaying the data, you choose from several display styles, select data into rows and columns, choose subtotals and sorting methods. Basic view styles include 1D-Tables, 2D-Tables, Charts, Trees (hierarchical parent-child structures). When defining a view, drag&drop functionality can be used, making view preparation user-friendly. A relative filter can be defined for a view, e.g. displaying data from the beginning of the last month to the end of the current month. You can assign an icon to the view for easy orientation.


A special style of displaying company information is Dashboard, where you include several objects for data analysis on the desktop, e.g. a table, a map and a graph.


Finally, you can arrange your views into Panels, which you can define yourself. Each panel is a separate workspace with a menu of views.