Chapter 2. Creating New Queries

In this chapter, we will cover the following recipes:

• The universe structure
• Creating a simple query
• Editing the query
• Filtering the query results
• Using prompts
• Using AND/OR logic in conditions
• Creating nested filters
• Using a subquery
• Using combined queries
• Adding another query
• Working with several queries
• Working with the query properties
• Using the data preview
• Viewing the SQL
• Using other query results
• Scope of analysis
• Using database ranking
• Using BEx queries