Intellicus helps you to process OLAP cube-building activity on a dedicated cube server. To process this, you first need to create a data warehouse connection that holds the data that you want to use for cube building.
To create a data warehouse connection, go to –
Navigate > Administration > Configure > Connections
Click Add. Or you can modify an existing connection.
In the current version, you can create a data warehouse connection with MSSQL, POSTGRES, or MYSQL as the provider.
Create a desired connection. Subsequent chapters explain how to create a connection based on provider type.
While creating the connection, select Data Warehouse Connection. This property is below the the Read Only property. Once saved, this connection will now serve as the data warehouse connection.
Note: You can create only 1 Data Warehouse Connection.