Analysis - Basics
Like reports, analysis objects can be managed in a freely definable hierarchical tree structure including two type of nodes:
When you open the Analysis module by clicking the Analysis menu item in section 5 of the Main Screen, you end up with the following screen and a pre-installed one analysis folder structure.
The analysis folder structure can be managed by functions via a toolbar similar as in the Reports module.
|1.||Refresh the tree node structure|
|2.||Execute the analysis SQL query and open the analysis cube|
|3.||Execute SQL query stored along the selected analysis node. The result set will be shown in the Query Result Set tab|
|4.||Add a new analysis/folder node|
|5.||Delete the selected analysis/folder node|
|6.||Edit the selected analysis/folder node (F2)|
|7.||Duplicate the selected analysis/folder node|
You can also drag&drop both type of nodes including their child nodes around.
The Analysis tab area is divided into the following sections:
|2.||Row fields area|
|3.||Column fields area|
|4.||Measure fields area|
These sections are discussed below.
Section 1 - Toolbar
The toolbar allows you to issue the following commands:
|1.||Save current cube file|
|2.||Load cube file|
|3.||Clear grid, clearing all row, column and measure fields|
|4.||Save current schema|
|6.||Export grid content into various formats|
|8.||Hide row zeros. This suppresses empty rows in the data grid|
|9.||Hide column zeros. This suppresses empty columns in the data grid|
|10.||Row sort type|
|11.||Column sort type|
|12.||Edit Measures. This allows to define measure, which are aggregates (count, sum, min, max, avg, ...) on field names|
Section 2 - Row Fields Area
Row fields can be dropped onto this area. To drop fields you can either use the drop-down box of section 6 or the Field list toolbar button.
Section 3 - Column Fields Area
Column fields can be dropped onto this area. To drop fields you can either use the drop-down box of section 6 or the Field list toolbar button.
Section 4 - Measure Fields Area
Measure (aggregated) fields can be dropped onto this area. To drop fields you can either use the drop-down box of section 5 or the Field list toolbar button.
Section 5 - Measures
Here you can access all defined measures.
Section 6 - Field list
Here you can access all available fields of the underlaying dataset.