Contents Overview of Infor BI Q&A Extracting Data Absolute and Relative Cell Addressing Automatic Filter Lookups Creating a Summary Link Creating a Summary Report Creating a Detailed Report Creating a Reference Link Named ranges Creating named ranges Filtering on named ranges Data extraction examples Query Definition dialog Setting filter options Selecting a filter option Extraction types Sorting output items Output options Period selection Selecting a period Current period override Date lookup Report style Analyzing Data Data Send Data Send Dialog Box Constructing a Data Send Definition Creating a Data Send Data Send to SunSystems SSC Recalculate Administering relational hierarchies Creating a parent hierarchy Managing hierarchies Adding a parent node to the hierarchy Adding a child node to the hierarchy Removing a node from the hierarchy Removing all nodes from a hierarchy Validating filters in the hierarchy Hierarchy extraction types Extracting data from hierarchies Reporting on a hierarchy Filtering on a hierarchy Drilling down Drill Path Manager Current Drill Path Saved Drill Paths Linked sheets Moving the Drill Path Manager Window Resizing the Drill Path Manager Window Summary Drill Down Transaction Drill Down Breakout Expand Drill Down examples Creating and managing alerts Alert Scheduler Alert tasks Creating Alert Tasks Managing Alert Tasks Administering Alert Tasks Alert processes Creating an Alert Process Creating a Microsoft® Office Excel Process Scheduling the Workbook Creating a Command Line Process Creating an E-mail Process Scheduling a Task Defining the duration and frequency of a Scheduled Task Editing a Scheduled Event Utilities Migrating queries Changing passwords Viewing Logs Saving to ZIP file Macros Supported macros Creating Macros Recalculate a report Run and populate a query formula Insert and run a query formula Data Send Log on/log off server