Creating a New Query
Whether you are creating a new query or modifying an existing query to add a new result column or change a condition, you use the query panel. The query panel lets you select columns to display in a report and specify conditions to limit the rows returned, all without your knowing SQL. The universe’s semantic layer displays business names and dynamically generates the necessary SQL behind the scenes. Chapter 6 gives a more thorough discussion of how the universe accomplishes this. This chapter provides a strategy for turning a business question into a query and how to use the Web Intelligence query panel.