Creating Analyses

This chapter describes how to create analyses in Oracle Business Intelligence Enterprise Edition, including how to specify the criteria for analyses, display the results, and examine the SQL statements. It also explains subject areas and columns, the double column feature, and variables.

This chapter includes the following sections:

• "What Are Analyses?"

• "What Are Subject Areas and Columns?"

• "Understanding the Double Column Feature"

• "What Is the Analysis Editor?"

• "What Is the Process for Constructing Analyses?"

• "Creating New Analyses"

• "Specifying the Criteria for Analyses"

• "Saving Columns to the Catalog"

• "Changing the Sort Order of Subject Areas and Subject Area Folders"

• "Displaying the Results of Analyses"

• "Adding Prompts to Analyses"

• "Examining the Logical SQL Statements for Analyses"

• "Saving Analyses"

• "Creating Agents from Analyses"

• "Editing Analyses"

• "About Embedding an Analysis in a Dashboard"

• "Working with Direct Database Requests"

• "Using Variables"

• "Where Can I Reference Variables?"

• "What Is the Syntax for Referencing Variables?"

• "What Predefined Presentation Variables Are Available?"

• "Example of Referencing a Variable in a Title View"