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 name of analysis (ID is created automatically) and description. You can also create hierarchy of analyses with combo box besides name of analysis. In the tabs below, you first define which fields will be used in analyses as measurement and which as dimensions in Settings tab. You can also set authorizations for each analysis in Authorizations tab.
The Ad-Hoc Analyses form can be accessed from the menu Settings | Program | Ad-Hoc Analyses.
The toolbar is visible also in already created analyses, that can be accessed from the menu Analytics | Ad-Hoc Analyses | Ad-Hoc Analyses Window.
Below is the description of toolbar’s features.
In this section, the basic 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 by database upgrade after you define 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. Add them by using drag and drop.
Each field can then be assigned a type of calculation, if you use a right-mouse click and select the type of calculation from the list:
|
|
Dimensions
|
Add field, if you want to define them as dimension. Add them by using drag and drop.
|
 |
Hint
Measurement and dimension delimiter is semi-colon (;) so that comma (,) can be used in the alias of a variable.
|