Set Data Sources as Data Warehouse

A data warehouse is a dedicated data source where Nectari stores and processes OLAP cube data. If you plan to use OLAP cubes, one of your existing data sources must be designated as the data warehouse before you can create or load any cubes.

This is typically needed when you're using templates that include OLAP cube data models, or when your reporting relies on cube data for faster performance on large datasets. The data warehouse can be the same database server as your main data source, but it uses a separate schema to keep cube data organized independently.

important

Snowflake cannot be used as a data warehouse since OLAP cubes are not supported on it.

Set as data warehouse

1. In the Data Sources panel, select the data source.
2. Select Set as Data Warehouse at the bottom of the panel.
3. New fields appear in the Data Source Definition panel.
4. Enter the Data Warehouse Schema. This usually matches your custom schema.
5. For SQL Server, enable Use MARS during the cube loading to allow multiple active result sets at the same time.
6. Select Save.

note

Before version 8.0.1, MARS was enabled by default. See Using Multiple Active Result Sets (MARS) for more information.