Page History

This tutorial shows how to use Dynamic data tables with Remote storage and PostgreSQL database.

1. Open Advanced settings and set up Remote storage.
   
   Image Added
2. Enable Dynamic Data Tables in Advanced settings
   Image Added
3. Upload data to the data set.
4. Create a sample data set, e.g. with a simple table.
5. Open pgAdmin and connect to the Remote storage database.
6. Select the database schema, according to the domain of your user (example - domain "D1" -> database schema "ds_d1".
7. Create a new view or table. The view or table must have the same structure (forced table or view must contain at least the same columns as original table). To test this feature, you can create a view which will load the data from the original data set table with a limit:
   Image Added
8. Open the report. To load the data from the dynamic data table (or view), add the parameter bd_force_data_table to the URL. Example: http://localhost:8080/bi/report/detail/1?bd_force_data_table=view
9. Data from the view will be loaded.