Ad-Hoc Editor
The Ad-Hoc Editor of the Ad-Hoc Analyses form allows you to create analyses with SQL statements.
First, you have to define the name of analysis (ID is created automatically) and description. You can also create a hierarchy of analyses with combo box next to the name of analysis. In the tabs below, you first define which fields will be used in analyses as measures and which as dimensions in the Settings tab. You can also set authorizations for each analysis in the Authorizations tab.
The Ad-Hoc Analyses form can be accessed from the menu Settings | Program | Ad-Hoc Analyses.
The toolbar is also displayed in previously created analyses that can be accessed from the menu Analytics | Ad-Hoc Analyses | Ad-Hoc Analyses Window.
Below is a description of toolbar’s features.
In this section, the general information about the analyses are entered.
|
Name
|
Enter the name of the analyses. The ID is created automatically.
|
|
Description
|
Enter the description of the analyses.
|
|
(Hierarchy)
|
In the combo box, select the hierarchy of the analyses from the drop-down menu.
|
In this section, you can create SQL statements for the analyses and assign values to measures and dimensions.
 |
Warning
Ad-Hoc system supports translations of captions, but they have to be written in correct order. If you write alias as #$sqlSubject$# instead of 'Subject', such alias will be translated into user-selected language. Translations are inserted following a database upgrade after you have defined the user language.
|
|
SQL Query
|
Enter the SQL query for the Ad-Hoc analyses.
You can open the Edit SQL Queries form for easier SQL editing by using right-mouse click in the field and selecting Edit SQL Queries.
|
|
Fields
|
Displays the fields that are used in the SQL query.
Fields can be then assigned to Measures (numerical fields) or Dimensions by using drag and drop.
|
|
Measures
|
Add numerical fields if you want to define them as measures. You can add them by using drag and drop.
Each field can then be assigned a type of calculation using a right-mouse click and selecting the type of calculation from the list:
- SUM - set by default. Shows summary of individual measure by dimension.
- AVG - Shows average of individual measure by dimension. (average)
- COUNT - Shows number of records (count) of individual measure by dimension.
- CURRENCY - Shows currency sign for individual measure. Currency sign is set according to selected currency in analytics in Administration panel.
|
|
Dimensions
|
Add fields if you want to define them as dimensions. You can add them by using drag and drop.
|
 |
Hint
Measure and dimension delimiter is semi-colon (;) so that comma (,) can be used in the alias of a variable.
|