How can Summary tables be connected in a Bold BI data source?
A summary table is a precomputed table that contains aggregated data from one or more source tables. It is utilized to enhance query performance by storing summarized data that can be quickly accessed without the need for complex calculations every time the data is queried.
In the context of a database, both summary tables and normal tables are referred to simply as “tables.” While their purposes and contents differ, they share fundamental characteristics and are managed within the same database framework. Like normal tables, summary tables have defined structures consisting of rows and columns, and they adhere to the relational database principles of data organization and manipulation. Therefore, it will be listed under the tables section on the data source designer page when creating the data source. Please refer to the following screenshot for your reference.
References
