We are excited to announce a significant enhancement to the Report Run algorithm within the OWOX: Reports, Charts & Pivots extension. This update allows users to seamlessly execute advanced SQL Queries alongside the Filters, Sorting, and Limits functionalities.
Context
Previously, our users could successfully run Reports that included specific SQL clauses such as WITH or DECLARE and others. However, when they added Filters, Sorting, or Limits to these Reports, execution errors would occur. These issues prevented users from fully leveraging these features and maximizing the value of the OWOX: Reports, Charts & Pivots extension.
Enhancements Overview
With the latest update, users can confidently execute any advanced Query while applying Filters, Sorting, or Limits. The updated Query execution algorithm in BigQuery now operates in a two-stage process:
- Stage 1: The raw Query runs, and the result is written into a temporary table, following standard BigQuery logic.
- Stage 2: The data is retrieved from the temporary table, and the selected Filters, Sorting, and Limits are applied.
This two-stage approach ensures that even the most complex queries will be executed smoothly, enabling more flexible and powerful data analysis.
For detailed instructions on how to use Filters, Sorting, and Limits, please read this article in our Help Center.
If you have any questions or require further assistance, feel free to contact us at bi@owox.com. We're here to help.
Thank you for choosing OWOX BI. Happy analyzing!
0 Comments