Technology Overview

Logi Ad Hoc is a standalone web-based application built on LogiXML’s core business intelligence platform.

Open technology approach based on industry standards (HTML, XML, and AJAX)

• Support for both .NET and Java
• Support for SQL, MSDE, Sybase, MySQL, Oracle, DB2, Intersystems Cache, Informix, SAND, PI, and PostgreSQL
• 32-bit and 64-bit versions available

Report Development

Logi Ad Hoc’s highly intuitive interface was designed by self-service reporting experts to include the following features, thus eliminating the need for business user training and ongoing IT support.

• Modern and familiar web-based interface
• Intuitive step-by-step report builder with drag and drop
• Embedded how-to videos and useful tips
• Live preview – allows business users to see in real time how the report will look
• Business-friendly data selection that eliminates the need to understand complex schemas and relationships
• Simple query construction through an intuitive code-free interface that enables advanced sorting, filtering, and grouping
• Code-free data manipulation for power-users including virtual calculated columns and statistical columns, with no impact on source data
• Reporting Portal for easy management, scheduling, and sharing
• Search function that assists in finding reports quickly
• Report folders to organize related reports and dashboards
• File management system to move, copy, and rename reports
• Sharing to collaborate, co-author, and co-modify dashboards and reports

Reporting Styles and Features

Using Ad Hoc's intuitive web-based interface, business users can design impressive dashboards, reports, and analyses themselves, leveraging powerful yet easy-to-use features such as:

• Customizable and multi-dimensional tabular reports with flat, crosstab, drill-down, multi-layer grouping, and conditional styling
• Animated and static charts and graphs that users can export to popular formats such as Excel, Word, PDF, CSV, and XML
• Interactive Data View (IDV) that dynamically displays data in a table, pie chart, grid chart, line chart or area chart and can be filtered on the fly to perform quick calculations or create "what-if" scenarios
• Heat maps that give business users quick views of large amounts of data to find trends and anomalies at a glance
• Ability to build panels and construct dashboards with up to four columns (panels can include any report or web page)
• User-defined data columns and summary rows with calculations and transformations, including mathematical, statistical, date & time, logical, and text
• Pre-defined and ask-in-report parameters, including cascading filters and multivariate filters
• Style and formatting options, including report style, labels, images, page size, print orientation and printable paging
• Scheduler to automatically deliver reports once, daily, weekly, or monthly in multiple formats including HTML, Word, Excel, and PDF
• Archiving to view previously generated versions of reports

Deployment and Administration

Rapid Deployment Wizards enable IT to quickly connect to data, import schemas and relationships, and configure and deploy the application in hours instead of weeks or months. Our Easy Administration Console integrates the following features, making ongoing maintenance quick and painless.

• A single configuration wizard quickly walks IT through the setup process including database connection, importing schemas and relationships, and deploying the application
• Management application (Logi Ad Hoc Management Console) is packed with guidance and links to documentation assisting IT through the process
• Metadata database is easily configured and used for transparent storage and protection of database schematics, security information, friendly names, descriptions of data, and virtual data structures defined by users and administrators
• Data objects can be preconfigured with formatting, data type, filtering, sorting, and virtual calculated columns
• Unnecessary data objects and columns can be hidden from users
• Virtual data objects, virtual views, and virtual relationships can be established between data objects
• Categories allow data objects to be labeled so they can be easily found by end users
• Friendly names and descriptions for data objects and columns to enable easy selection by end-users

Integration and Security

Logi Ad Hoc utilizes standards-based technologies such as XML and CSS to support integration requirements such as white label rebranding, security integration, and single sign-on.

• Customizable appearance to incorporate custom colors, logos, images, icons, font types and styles to give the user interface a certain “look and feel”
• Customizable interface by hiding menu bars and certain functions
• Easy customization through the web interface, CSS, and XML settings files
• Ability to bring authentication and authorization credentials from any source system to create a single sign-on experience
• Bypassable built-in authentication if security information is passed from the parent application via session parameter, Active Directory, or SecureKey
• Automated synchronization of users between a parent application
• Role-based authorization (pre-defined permission packages come preloaded)
• Over 60 application rights customizable for permission packages
• Role-based access restrictions to data objects at the object or column level

Data Connectivity

Support for popular SQL compliant data platforms including SQL, MSDE, Sybase, MySQL, Oracle, DB2, Intersystems Cache, Informix, SAND, PI, and PostgreSQL within .NET and Java environments.