Connecting to Infor OLAP (XMLA) Cube

Navigate to Modeler Connect.

Select the SQL Database connector or click +Create and select SQL Database from the Select the connector list.

Specify the Connection Name.

Select a Connection Type of Live Access.

Assign a Birst Cloud Agent for your connection.

Select a Database Type of Infor OLAP (XMLA).

Specify the connectivity information for your Infor OLAP (XMLA) cube. (server URL, Database name, User name, Password)

If your connection requires additional details, click More Options.

You can specify these parameters in the More Options tab:

Query Timeout: The parameter (in seconds) for the maximum time duration that the query is executed. If the database does not return results in this time-frame, the query execution is halted and a timeout exception occurs.
Note: The database for which we are connecting via Live Access may also have a defined query timeout parameter that may be less than the timeout parameter defined by our Live Access connection. You may want to verify that your Live Access timeout parameter is less than the database timeout parameter value.
Extended Connection Properties: Allows you enter additional parameters required to pass to their OLAP (XMLA) cube for retrieval of authorized or desired data elements.
Roles: Allows you to recognize role security for the cube. This can be used to display only the data that the specified roles can see

Click Save.

Select one / multiple cube(s) that you would like to connect to, and click Done.

Click Map OLAP Data to import the definition of these cubes into Birst.

After the mapping of the cube(s) is complete, you are now ready to create reports in Visualizer based on your mapped cubes.

Note: The hyperlinks in the report indicates that any drill paths defined in your cube are also active in the Visualizer report.

You can click Publish to publish.