A new and elegant way to create queries

  • Slides: 26
Download presentation
A new and elegant way to create queries and ad-hoc reports on your Baan

A new and elegant way to create queries and ad-hoc reports on your Baan / Infor ERP LN data. This Baan session is a query builder that comes with an easy to use graphical interface.

1. NAZDAQ Company 2. The Problem 3. The solution – Using Baan Query Tool

1. NAZDAQ Company 2. The Problem 3. The solution – Using Baan Query Tool 4. Success Stories

NAZDAQ is a provider of Add-ons for Baan and Infor ERP Ln. The NAZDAQ

NAZDAQ is a provider of Add-ons for Baan and Infor ERP Ln. The NAZDAQ tools provide a great return on investment and enable Emailing, faxing, archiving, printing documents like Purchase Orders and Invoices, and allow an easy way to convert reports to Excel, Word, PDF HTML and XML. Other solutions cover areas of document management, reporting and notification. The NAZDAQ tools are installed at hundreds of servers in more than 60 countries. They are used daily by users to automate transfer of Baan reports into front-office applications, as well as automating business processes. www. nazdaq-it. com

Generic Query Tools Difficult to install and configure Difficult to use Time consuming Expensive

Generic Query Tools Difficult to install and configure Difficult to use Time consuming Expensive to configure and run Not Baan/ERP LN specific

Baan Query Tool Quick Installation: Load few sessions and all Baan and ERP LN

Baan Query Tool Quick Installation: Load few sessions and all Baan and ERP LN users will have access to Baan Query Tool Easy to Configure: No ODBC or database drivers need to be configured Use Baan Data Dictionary: Browse tables and fields and create a query - using the Baan data dictionary

Baan Query Tool: Is fully integrated in Baan. Reports run as native Baan reports

Baan Query Tool: Is fully integrated in Baan. Reports run as native Baan reports Can work with Baan special fields like enumerated fields, arrays and text fields Does not have the limitation of 255 characters, like standard Baan reports

Baan Query Tool – Easy to find a Baan table Simply use the zoom

Baan Query Tool – Easy to find a Baan table Simply use the zoom option, then search the table description or code.

Baan Query Tool – Finding and adding fields Using this graphical tool, you can

Baan Query Tool – Finding and adding fields Using this graphical tool, you can easily find the fields and add them to the query.

Baan Query Tool – Printing results You can easily set the range and print

Baan Query Tool – Printing results You can easily set the range and print the results.

Baan Query Tool – Customizing the print form You can save different field values

Baan Query Tool – Customizing the print form You can save different field values using “Saving Defaults”. Save Defaults sets the fixed “where” statement of the Query.

Baan Query Tool – Customize fields You can customize any field details such as:

Baan Query Tool – Customize fields You can customize any field details such as: description, width, alignment and format in the print results.

Baan Query Tool – Adding fields from another table Add customer name and country

Baan Query Tool – Adding fields from another table Add customer name and country name, change title and change it’s position.

Baan Query Tool – Adding calculated fields Formulas can be added as fields to

Baan Query Tool – Adding calculated fields Formulas can be added as fields to the query.

Baan Query Tool – Adding conditional fields Conditional fields can be added as fields

Baan Query Tool – Adding conditional fields Conditional fields can be added as fields to the query.

Baan Query Tool – Sorting your output You can have 4 levels of sorting.

Baan Query Tool – Sorting your output You can have 4 levels of sorting.

Baan Query Tool – Adding aggregation functions You can use a group by option

Baan Query Tool – Adding aggregation functions You can use a group by option for a field using functions such as: sum, avg, min, max and count. Text before field - You can add sort fields values as variables: SORT 1, SORT 2, SORT 3, SORT 4

Baan Query Tool – Working with output You can pre-define your output device.

Baan Query Tool – Working with output You can pre-define your output device.

Baan Query Tool – Integrating with B 2 Win & B 2 Email If

Baan Query Tool – Integrating with B 2 Win & B 2 Email If you use B 2 Win and B 2 Email, you can automatically format the output in Excel format and Email it by setting the device and output file.

Baan Query Tool – Running wide reports In order to overcome the limitation of

Baan Query Tool – Running wide reports In order to overcome the limitation of 255 characters in Baan, use device type “Wide”. With this, you can write a query with unlimited number of fields.

Baan Query Tool – Automating queries By defining the output device and hiding the

Baan Query Tool – Automating queries By defining the output device and hiding the print form, Baan Query Tool does not require any input and can run in a job.

Baan Query Tool – Run queries Baan Query Tool is a tool for power

Baan Query Tool – Run queries Baan Query Tool is a tool for power users. For normal users you allow them to run queries using a limited interface. They can also run queries written by other users.

Baan Query Tool – Copy query Baan Query Tool is a tool for power

Baan Query Tool – Copy query Baan Query Tool is a tool for power users. For normal users you can also allow them to copy queries from other users and run them.

Kistler in Switzerland - Kistler is using B 2 Win now in almost all

Kistler in Switzerland - Kistler is using B 2 Win now in almost all departments, in order to put Baan reports into Excel. Baan Query Tool (BQT) is used mostly in IT to create fast and easy reports. In addition, they have a new project where they have to gather data together from all the Baan systems and consolidate it. BQT has been a great help because they can take out every data they want. BQT runs fast, even with more complex multi-table queries. Since they also have to perform large data cleanup, they can simply extract data into Excel. The users can modify the data in Excel and they can import it back using Exchange. According to Mr. Cajoos, “This technique saves man-weeks of work, because the users do not have to go through many Baan sessions, record by record. “ customer

info@nazdaq-it. com Free Demo

info@nazdaq-it. com Free Demo