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.
Table of contents
- Toolbar
- Editor window
- Analysis window with results of the analysis
|
Toolbar of Ad-Hoc form contain different buttons that are used to work with Ad-Hoc analyses.
 |
Delete the current analyses |
 |
ID of the analyses and arrow keys. ID of each analysis is generated automatically. System (imported) analysis IDs 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:
|