Table of Contents

In business, it is crucial to know where to go. Whether you are acquiring new companies, introducing new products, or pursuing other options, it is essential to understand where you are going and why. This requires skills in business intelligence and reporting. With Infor® SunSystems Query and Analysis, you have access to real-time data 24 hours a day, seven days a week, to make strategic recommendations and decisions.

What is Infor SunSystems Query and Analysis?

Infor SunSystems Query and Analysis (formerly referred to as Infor SunSystems Vision) is a convenient tool for ad-hoc querying and reporting that enables both technical and non-technical professionals to maximise data 24/7.

Being used by more than 10,000 organisations worldwide, Infor Query and Analysis (or Infor Q&A) provides you with the information you require quickly, effectively, and at a lower total cost of ownership.

By integrating with Excel, Infor Q&A gives a familiar-looking interface. In addition to being user-friendly, Infor Query and Analysis is dynamic, multilingual, and equipped with sophisticated business intelligence tools.

You can execute queries across many applications, receive multiple data visualisation options (including multidimensional cues and charts), and pull the resulting data and performance measurements back into a single report.

What Infor SunSystems Query and Analysis does?

The Infor SunSystems Query and Analysis family of ad-hoc query and reporting tools includes:

1. Infor BI Query and Analysis

With unparalleled data visualisation functionality, this web service-enabled and cloud-ready solution allows you to turn information into insight—all in real-time. With Infor BI Query & Analysis, anyone in your organisation can get 24/7 access to real-time information to make informed and strategic decisions.

With a focus on reporting and analysis, Infor BI Query and Analysis provides a single working area within the popular MS Excel environment, allowing you the flexibility to drill down, break out, and expand views at a detailed transactional level and/or summary level.

Get a top-down view of your entire business with this dynamic analysis and reporting application’s powerful analytical capabilities, such as drill down, expand, and breakout. You can quickly analyse trends, problems, and opportunities often concealed within corporate transactional data. You can save frequently used analysis procedures and replay them in the future.

2. Infor Query and Analysis Context 

Empower your employees with this centralised platform for collaboration, where information is shared and conversations are organised into streams across the enterprise. With embedded business intelligence, real-time information, and custom visualisations, you’ll increase collaboration and streamline the decision-making process.

3. Infor Query and Analysis BI Dashboards

Approve transactions, drill down to transactional details, and monitor business performance anytime, from anywhere, with this intuitive and easy-to-use, touch-screen-enabled Apple iPad® app.

4. Infor Query and Analysis Alert

Enhance your ability to identify, analyse, and report on performance and trends concealed within the database with this query and analysis tool. You can create, edit, and schedule tasks and then let this tool automatically manage, run, and distribute reports based on scheduled events.

For example, you can set alerts to trigger one or more subsequent responses to take action (print the report, share the report via email or the web, or export the report to an Excel file) if a predefined financial limit is reached.

Q&A Alert processes will also be rescheduled automatically if specific conditions are not met at a predetermined time, as frequently as needed, without further prompting.

5. Infor Query and Analysis Datalink Studio

Infor Query and Analysis includes several pre-built, dynamic, intelligent business logic metadata layers that link directly to the enterprise data of other systems.

6. Infor Query and Analysis XL

A Microsoft Excel add-in that allows you to analyse data faster, easier, and more flexibly. You are provided with the freedom to create reports without the need to understand complicated database structures and then publish these reports to the web.

The report designed in Q&A XL offers a wide array of report styles and formats to accommodate your every need for reporting. Furthermore, the application also allows you to upload Excel data directly into the SunSystems database you need for reporting. Furthermore, the application also allows you to upload Excel data directly into the SunSystems database. This is particularly useful when you need to enter free-format Excel forms or upload a large amount of data.

7. Infor Query and Analysis Executive

A comprehensive analysis and reporting application that comes equipped with powerful analytical capabilities The application allows you to drill down, break out, and perform cube analysis, therefore making analysing trends and identifying problems and opportunities easier than ever.

Q&A Executive facilitates and defines inquiries and financial information analysis with a built-in guide to locating relevant data. Thus, selection can be enabled with just a click of a button.

Frequently used analysis processes can be saved for later use.

Benefits of using Infor SunSystems Query and Analysis

Infor Query & Analysis is a component of SunSystems meant to assist international enterprises and fast-growing businesses in managing complex financial operations. It is suitable for finance, accounting, and data analysis businesses.

Q&A provides financial users with a quick and simple approach to creating their own reports, such as legacy statements, P&L statements, and balance sheets, with the option to dive into balances at both summary and transaction levels, line expansion, and report analysis.

As the software is linked with Excel, users can get up and running with minimum training and technical expertise and create reports that display trends, patterns, and exceptions using a simple report builder.

You still receive business intelligence tools that are dynamic, multilingual, multicurrency, powerful, versatile, secure, user-friendly, and have inconsistent interfaces throughout the product. And because it is self-service, users need minimal IT help and participation. Consequently, maintenance is also simplified.

The same queries can be executed across various applications, and the resulting data can be compiled into a single report. With access to real-time data, you can rapidly analyse company data, measure performance, and be more reactive. You also have many options for conducting queries and viewing data, including multidimensional cubes and charts.

All in all, Infor Query & Analysis enables you to:

  • Get users operational rapidly with minimum IT intervention.
  • Exhibit a deeper comprehension of the trends, patterns, and outliers affecting your business.
  • On-demand provision of answers to crucial business questions so you can turn insights into actions

With Infor SunSystems Query and Analysis, anyone in your organisation can get 24/7 access to real-time information to make the right decisions at the right time.

How Astra Life automates its accounting and reporting systems with Infor SunSystems and Q&A

Astra Life is an Indonesia-based life insurance products and services provider. With low market penetration, the insurance market in Indonesia is still in a nascent stage of development. This offers a great opportunity for Astra Life, a company that intends to become a top-five insurance company.

Given the formation of the joint venture, the organisation must report to PT Astra International Tbk and Aviva International Holdings, as well as the Indonesian Financial Services Authority (OJK). With the company’s existing accounting systems, it was a challenge for Astra Life to meet its monthly reporting deadlines.

Astra Life wanted a solution that could make reporting to its stakeholders easier and eliminate the risk of paying high penalties for late submissions and losing its license to operate as an insurance company.

Astra Life decided to upgrade its enterprise financial management solution to Infor SunSystems. It was the obvious choice: 70% of insurance companies in Indonesia use it for its ease of use, cost-effectiveness, and responsiveness. And thanks to Infor SunSystems’ Query & Analysis, Astra Life can now grab data automatically from its accounting system and prepare reports quickly.

The system has also allowed Astra Life to conveniently change its parameters to modify reports, so those reports better suit the end user.

Astra Life has also created templates that have helped it prepare custom reports to comply with the reporting requirements of the Indonesian Financial Services Authority (OJK).


The latest version, Infor Query and Analysis 11, is a cloud-ready solution that uses internet communication to deliver the data you need from a server-based query service to your desktop Excel. With Infor Q&A 11, you can confidently make informed and strategic decisions anytime and anywhere.

Experience Infor Q&A and SunSystems Cloud for yourself by requesting a demo today!

I really recommend Infor because it has ideal tools with industry-specific functionality. For industrial manufacturing, Infor LN is the best.

Ricardo Menezes Brandao TECFIL

We appreciate Infor’s partnership and ability to address the complexities of unifying our technology system.

Rucha Nanavati Albertsons Companies