The Flynet DataConnect query editor allows you to build simple and complex SQL queries alike. These queries are ultimately made available as web methods on an XML web service. Web services can be used by clients such as SAP Dashboard Design / Xcelsius.
A query is made up of a number of sections (clauses) that let you specify what data you would like to see and how you would like to filter and order it. It can also take input parameters so you can change the filter range dynmically.