Ad-Hoc analyses

 Ad-hoc analyses

Ad-hoc analyzes are used for detailed data analysis. The work in a similar way than pivot tables. Ad-Hoc analyses use SQL statements where you define measures and dimensions and create pivot tables.

Ad-Hoc analyses require .dll files for their use. If .dll files are not found on the computer or new version of .dll files apperar, transfer process is started automatically when Ad-Hoc analysis is opened or newly created.

1. Toolbar

Toolbar of Ad-Hoc form contain different buttons that are used to work with Ad-Hoc analyses.

	Delete the current analyses
	Key of the analyses and arrow keys.  Key of each analysis is generated automatically. System (imported) analysis keys are numercial with - prefix. Custom analyses (created by user) get alphabetical prefix that starts with "A".
	Save the current analyses
	Open new analyses
	Adds decimal numbers to results of Ad-Hoc analysis.
	Removes decimal numbers to results of Ad-Hoc analysis.
	Opens Ad-Hoc editor from Ad-Hoc window.
	Exports Ad-Hoc data to Excel file.
	Shows graph horizontally below the Ad-Hoc results grid.
	Shows graph vertically od the right edge of the Ad-Hoc results grid.
	Opens Ad-Hoc window from Ad-Hoc editor.
	Opens Ad-Hoc editor from Ad-Hoc window.

Ad-hoc analyses module consists of multiple functionalities: Ad-Hoc editor. Ad-Hoc window. Analyses import. Analyses template designer.