SQL Editor to run output of Analyse SQL | Product Feedback Forum

Tim von Ahsen · 2024-08-04T10:20:13.704000Z

"Analyse SQL" helped me understand some widget measure formulas and filters. I wanted to then experiment with it in Sisense's "SQL Runner", but that didn't work: the query is too large, and it uses strange names for tables and columns (aFactXwAaSaleXwAaorders for the table Fact_Sale_orders, and aCountryCode for the CountryCode column).It'd be helpful if you modified SQL Runner and/or Analyse SQL so that I can paste results, edit, and run them.The purpose to help me investigate questions such as "How does this filter affect my measure?" or "What does my colleague's horribly convoluted measure formula mean, why is it wrong, and how might I fix it?" or "Is my widget doing unexpected joins?". I'd like this as a tool for myself and to recommend to colleagues.

MoreDiscussions

SQL Editor to run output of Analyse SQL | Product Feedback Forum | Sisense Community