About Query & Analysis
Infor Query & Analysis is an executive information system. It provides an easy and fast way in Microsoft Excel to interrogate and analyze data that is held in your data source.
Extracting data
You use a data extraction definition to extract data from your data source and display the results in Microsoft® Office Excel.
Drilling down
Drill Down enables you to drill down on any amount to display details of its composition.
Suppressing zeros
You use Zero Suppress to hide rows and columns that only contain zero values.
Analyzing data
You can recalculate worksheets, workbooks and cell ranges, and post data back to your product database using Data Send.
Data Send
You use Data Send to post data from an Microsoft® Office Excel worksheet to your product database.
User-defined outputs
Use user-defined outputs (UDOs) to include calculated output within the output of a worksheet query.
Excel plugin utilities
Use the Query & Analysis Plugin Checker tool to enable the Q&A plugin in Excel.
DataLink Server utilities
DataLink Server includes several administrative utilities, which are available on the Windows Start menu.
Web-enabled user management
User Management is a web-based administrative tool for Query & Analysis.
Macros
Macros enable you to automate a process within the Q&A DataLink Server by calling exposed functions within the macro.
Alert Scheduler
You use Alert to define tasks, and schedule them to run when required.
Utilities
Various administration utilities are available in Q&A DataLink Server.
Home