Friday, March 14, 2014

Xperia Launches Advanced Query Reporting Tool for Apparel ERP Users


Apparel ERP Report Writer / Query Builder for the Apparel & Footwear Fashion Industry Announced by Xperia Solutions

Xperia specializes in software for apparel and footwear manufacturers, importers and distributors.

EMMAUS, PA – March 14, 2014
Xperia Solutions announced today the addition of an Advanced Query Reporting tool for its Connectiv and Comprehensiv Business Intelligence Software Suite. 

Build and Run Queries With No I.T. Experience
The Advanced Query Reporting tool allows an end user to build their own custom queries by selecting a primary module from a list of query-enabled modules within the system. Without any SQL experience, a user can add selection clauses using columns or fields from the primary module/table/view as well as secondary modules/tables/views based on the 1:M relationship model.

With a very simple Query Builder UX, the user can add selection filters and then format the output of the data by selecting the fields, sequence and sort order, all of which will be saved along with the query definition. The ability to save the query makes it quicker and easier to rerun frequently used reports allowing manufacturing companies and their employees to be more efficient. It also provides a way to distribute information to other users by marking the query as shared, and allows an administrator to provide a set of predefined shared queries for access by all users.

The Advanced Query Reporting Tool will generate the necessary SQL code that will retrieve the data from the system and show the results in a newly created tab within the main window. Query results can be easily exported to Microsoft Excel to work with and analyze data as well as have complete control over its presentation.

Quick and Easy Query Building Access Throughout ERP Software
The new reporting tool is a system task pane that is always accessible by the user and is designed to easily find and run a query. The user will be able to apply different views to see All Queries, Shared Queries or My Queries. A Quick Access tab is also available to show the queries available for the currently selected module in the navigator. From the technical side, a developer has full control over what modules are available to the Advanced Query Reporting Tool as well as what columns (or fields) are available for the selection clauses and output format.

About Xperia Solutions
Founded in 1984, Xperia is an industry leader in enterprise management solutions for the apparel and footwear industries. Xperia’s Executiv™ Suite helps businesses of all sizes manage the full spectrum of manufacturers’ requirements including warehouse inventory, procurement, production, financials, e-commerce and more. For more information about Xperia products and services, visit the company's web site at www.xperiasolutions.com.