Search TipsCMiC Analytics: Query Builder
BI Query Builder
Overview – BI Query Builder
BI Query Builder
BI Dashboard Builder is a powerful business intelligence tool for building custom dashboards with interactive charts, gauges, and tables that use real-time data directly from your CMiC system.
BI Query Builder, however, is a simplified version of BI Dashboard Builder, tailored specifically for building and generating queries. In this specialized version of the software, users can focus on creating and modifying queries. In BI Query Builder, a query is a dashboard that contains a single table visualization that is always maximized. This fine-tuned query generator makes query building simple and easy, and it supports all the table visualization features available in BI Dashboard Builder, including pivoting, drill-in-place, etc. In addition, queries built in BI Query Builder can be viewed and maintained in BI Dashboard Builder. Queries can also be set to launch in card view, allowing them to be filtered as cards in BI Analytics. They can also be set to launch in crosstab view.
This document focuses on the components and functionality specific to the BI Query Builder tool. For more information on the full-blown software features of BI Dashboard Builder, including requirements and setup options, please refer to the BI Dashboard Builder guide.
To learn more about BI QueryBuilder, please see the following sections: