The “Query Builder” allows you to add query parameters when creating filtering criteria. To specify the parameters of the added query parameters, click the “Edit parameters …” button: In the opened form, add a new parameter (using the «Add» button) and specify its parameters: Name – parameter name; Type – parameter type; Expression – specifies […]

After you add required tables and views, you can customize the automatically generated “SQL query”:  

The “Query Builder” allows you to preview data for the created “SQL query”. To do this, click the «Preview Results» button …  

In the “Data Source Wizard” window, select the “Stored Procedure” method, select the required stored procedure and click on the «Next» button: In the next window you can specify the parameter settings: Note. Use of the “Stored Procedure” is only possible for the following data sources: Microsoft SQL Server, Oracle, Teradata, Firebird, IBM DB2, MySQL, […]

After connecting to the data source and selecting the necessary data, you can edit the “Query” / “Stored procedure” or add another “Query” / “Stored procedure” to the data source. To do this, use buttons from the “Query” group in the “Data Source” tab: Add Query – adds a new query to the data source. […]

After you created the data source, you can add a new calculated field based on the existing data source fields. To create a calculated field, select the required data source in the Data Source list and click the «Add Calculated Field» button on the “Data Source” tab: In the “Expression Editor” window that appears, you […]

Move to the “Data Sources” tab: In the form that appears, select the “Microsoft Excel workbook” / “CSV” file data source: As the next step, specify the file location: Now specify the import parameters used to retrieve the data from the file: The following parameters are available: Use values of the first row as field […]

First of all you need to enter the information about the cubes. Go to the “Cubes” tab: This list contains the information about cubes. In fact they are not cubes but rather pointers to the cubes. These pointers are needed for the reports: the reports are «bound» not to the physical cubes, but to the […]

Creation of Users Cube Access Rights Binding to Domain User

Go to the “Report Users” tab, press the right mouse button and choose menu item “New Report User”: You will get the edit form. Enter the following data (password – mike): Press the button «Save». The dialog box will be shown: Press «No» (later we will explain the meaning of this choice). The new user […]