Using the Analyzer
- Introduction to the Analyzer
- Introduction
- Accessing the Analyzer
- Orientation to the Analyzer and Mini Analyzer
- Displaying a Pivot Table
- Exiting the Analyzer or Mini Analyzer
- Location of Pivot Table Definitions
- Accessing the BI Samples
- Creating Pivot Tables
- Introduction to the Autosave Feature
- Selecting a Subject Area
- Getting Familiar with a Subject Area
- Creating a Pivot Table
- Specifying the Rows in a Pivot Table
- Specifying the Columns in a Pivot Table
- Displaying Measures in a Pivot Table
- Displaying Properties in a Pivot Table
- Transposing a Pivot Table
- Changing the Order of Items
- Copying and Pasting Items
- Adding a Summary Row or Column
- Applying 80/20 Suppression
- Clearing the Autosave State of a Pivot Table
- Saving a Pivot Table
- Filtering Pivot Tables
- About Filters
- Dragging and Dropping Filter Items
- Creating and Using a Drop-Down Menu
- Adding Advanced Filters
- Filtering the Base Records by Measure Value
- Defining Named Filters
- Redefining a Named Filter
- Deleting a Named Filter
- Using Named Filters
- Disabling or Removing Filters
- How Business Intelligence Combines Filters
- Finding the Key for a Member
- Defining Calculated Elements
- Overview
- Defining a Calculated Measure
- Defining a Calculated Member That Is Not a Measure
- Redefining a Calculated Member
- Deleting a Calculated Member
- Defining and Using Pivot Variables
- Overview
- Defining a Pivot Variable
- Defining and Using an Expression Pivot Variable
- Literal Pivot Variables
- Redefining a Pivot Variable
- Deleting a Pivot Variable
- Customizing Pivot Tables
- Specifying Pivot Options
- Customizing Pivot Table Items
- Displaying a Constant Row or Column
- Specifying a Spacer Row or Column
- Displaying an Different Set for Rows or Columns
- Specifying New Captions
- Specifying a Format String
- Specifying Cell and Header Styles
- Sorting and Filtering Members
- Specifying Alternative Aggregation Methods for a Measure
- Customizing Double-Click Drilldown
- Applying Conditional Formatting
- Specifying the Print Settings
- Specifying the MDX Query Manually
- Working with Pivot Tables
- Opening a Saved Pivot Table
- Disabling and Enabling Auto-Execution
- Canceling a Running Query
- Exporting Data to Microsoft Excel or CSV file
- Printing a Pivot Table
- Sending Email
- Displaying the Pivot Table as a Chart
- Deleting a Pivot Table
- Performing Ad Hoc Analysis
- Displaying a Detail Listing
- Drilldown via Double-Click
- Performing Arbitrary Drilldown
- Introduction to the Pivot Analysis Window
- Configuring InterSystems IRIS for PDF Output