Adhoc designer allows you to just drag and drop columns from various tables, add filters and create reports on the fly from the browser itself. The report created can be visualized either in tabular format or cross tabular format or various charts or map.
Creating Reports:
You can first connect to data source and create a metadata from it. This basically allows you the flexibility to define and edit joins, rename of tables and columns for easier understanding, create views and select only those tables and columns to be used for adhoc, thus provide data security also.Data Source Connection:
Selecting catalogs & Schemas
Workflow Selecting the Tables
Workflow Selecting the Columns
Defining Alias and Joins.
Here is the final Adhoc UI
You can refer to below quick presentation for creating a report
Please refer to our guide on how to add Filters and how to apply Aggregate Functions like sum, min, max, average etc.
Adhoc provides options to view the result either in tabular format, cross-tabular format, on a geographical map, or any of the various charts which we provide. The charting options which we provide not only has simple charts but also many advanced charts for statistical and scientific analysis. Adhoc also allows you to add new templates in the form of VF, add new chart types also. Adhoc also allows you to add javascript, HTML, CSS and AJAX thus allowing you to do extensive customizations.
Guide for Usage of Filters
Please refer to our Adhoc Chart Customization Category to learn how you can go about making various customization in the chart.
Guide for Usage of Cross Tab
Technical Guide for Adding New Aggregate Functions
Once the report is created, it can be saved at any of the folders for later viewing.
For More Info, Contact us at demo@helicalinsight.com