Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

In cases of slow report execution speed due to large amounts of data it might be beneficial to use a separate database with a Snowflake architecture for report execution. Supported database by flex.bi right now is Vertica.

To enable separate database for report execution:

  1. Install the additional database on your server

  2. Add database connector to /flexbi_private/lib

  3. Configure OLAP DWH database connection parameters in Admin Settings page or /flexbi_private/config/database.toml file

4. Select the olap_dwh option for “OLAP DWH connection” on the Update Account page

Emptying and deleting data cubes right now is not fully supported with Vertica. In order to do this the “OLAP DWH connection” parameter has to be disabled and re-enabled after the re-import is finished.

  • No labels