Using AtScale with Logi Report
You can connect from Logi Report to a published AtScale cube using the Hive connection.
Before you begin
- Make sure you are familiar with the standard procedure for creating JDBC connections. For details, check the documentation for the corresponding version of Logi Report Designer
- Make sure that all libraries required for Hive connection are referenced correctly.
- Make sure the AtScale project containing the cube to which you want to connect is published.
- In AtScale, go to the corresponding published cube, and copy the JDBC connection information available in the Connect tab.
- Make sure the Logi system can connect through the network to the AtScale system (the host obtained in the previous step).
Procedure
Perform the following steps in Logi Report:
-
Create a new data source and select connection type Hive.
-
In the connection window, fill in the required details:
- Driver: the name of the Hive Driver
- URL: the URL of the published cube
- User: use the AtScale user
- Password: use the AtScale password
-
Choose More Options, and for the Name Pattern option select 2-Part Names.
-
Test the connection, and if successful save it.
-
Go to the properties of the connection you created, and set the Push Down Group Query property to
true
.This property will be applied automatically to Web reports. If a page report is created it should be adjusted in the same way - by setting its Push Down Group Query property to
true
.
What to do next
Build your report in Logi Report Designer. For details, check the documentation.