Ad-Hoc analyses

 Ad-hoc analyses

Ad-hoc analize are used for business analytic without using OLAP server and processing OLAP cubes. Instead, Ad-Hoc analyses use SQL statements where you define measurements and dimensions and create pivot tables.

1. Form buttons

Top bar of Ad-Hoc form contain different buttons that are used to work with Ad-Hoc 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.

2. Editor window 

3. Analysis window

HOW TO?

Use Ad-Hoc analyses? Import Ad-Hoc analysis from web service?

Ad-hoc analyses module consists of multiple functionalities:

• Ad-Hoc editor.
• Ad-Hoc window.
• Analyses import.
• Analyses template designer.