The main task of the administrator is to create the set of reports and enable users to see them. Besides, the administrator can set access rights to the data in cubes and assign profiles to the users (a profile influences the report operations that are accessible to the user). This document is written in the […]
On the logon form enter “root” in the field “Login”, and in the field “Password” – the password which you set during installation of the application server: In the field “Server” you must enter http://[your application server]. In this form you can also choose the desired language of interface. You also can save your […]
After logging on you will get on the “Settings” tab: At the first tab you can read the information from the blog of our Company. That allows to inform the users about the new product versions. The system information is represented in this tab. You can change your personal data on the “User Information” tab, […]
Data sources could be the following: Database Microsoft Excel workbook/ CSV file OLAP DB
Move to the “Data Sources” tab: This list contains information about the data sources. Now this list is empty. Select “Data Source” / “New Data Source” in the menu: The following data sources are available in the appeared form:
Select the “Database” data source: You will see a form with the following data: Provider – select the required data source from the drop-down list Server name – specify server name Authentication – authentication method Database – database name Now, in the appeared form select the method for selecting the data: Query – possibility […]
In the “Data Source Wizard” window, select the “Query” method and use the “Run Query Builder …” button: The following form appears:
To add a table, either drag it to the “Diagram” pane or double-click on it: Then select the required columns: Note that if at least one table has been added to the “Diagram” pane, the “Tables” pane highlights tables that have a relationship with any of the recently added tables: To join the already added table with an another […]
After you have added the tables and selected the required columns, you can change settings for each column in the “Grid” pane: The following settings are available for each column: Column – the possibility to select the required column from the combo box or add a new column. If necessary, you can customize the column expression. To […]
To filter data in the “Query Builder”, click the “Filter …” button: This will open the “Filter Editor” dialog, which allows you to build the filter criteria: