2 Creating Analyses

This section describes how to create an analysis for Oracle BI Enterprise Edition.

Topics:

• Typical Workflow for Creating Analyses

• Creating Your First Analysis

• Adding and Removing Columns in Analyses

• Saving Analyses

• Adding Interactivity to Analyses

• Applying Formatting to Objects

• Setting Properties for Columns

• Formatting Columns

• Exporting Content from Analyses and Dashboards

• Editing Formulas or Calculated Measures

• Setting Properties for Analyses

• Setting Preferences

• Importing Formatting from Another Analysis

• Combining Columns to Display Data Differently

• Advanced Techniques: Examining the Logical SQL Statements for Analyses

• Advanced Techniques: Referencing Stored Values in Variables

For more detailed information about creating analyses, see Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition.

Typical Workflow for Creating Analyses

To start creating analyses, refer to the typical workflow described in the following table:

Task	Description	More Information
Create an analysis	Select and arrange columns that you want to use in an analysis.	Creating Your First Analysis
Add and remove columns in an analysis	Modify the analysis by adding and removing columns.	Adding and Removing Columns in Analyses
Format columns	Specify formatting such as font, alignment, and borders for columns.	Formatting Columns
Set properties for columns	Specify properties such as heading and value formats, display of data, and conditional formatting.	Setting Properties for Columns
Work with the data in the analysis.	Add formulas and calculated measures to the analysis.	Editing Formulas or Calculated Measures
Affect the values of data in the analysis.	Specify filters, selection steps, groups, and calculated items for the analysis.	Filtering and Selecting Data for Analyses
Save an analysis	Save an analysis for your personal use or share it with other users.	Saving Analyses