Suppose I have created one app and reports also. I want to know the SQL Query behind each reports that can help better to understand the problem which needs to be solved. How to do that?
It's a matter of an appropriate documentation within the object and it's dimensions/expressions what should happens and why.
The nearer everything is designed to the official recommendations (using a star-scheme and all essential logic is within the data-model) and the native usability (using mostly simple expressions like sum() and count() and the user selects the wanted views/values) it wouldn't be cost much efforts because the most within the UI would be self-explanatory and only the few exceptions needs to get attention.
