FB TraceManager 2 - Documentation

Analysis - Basics

Analysis - Basics

Previous topic Next topic  

Analysis - Basics

Previous topic Next topic  

Like reports, analysis objects can be managed in a freely definable hierarchical tree structure including two type of nodes:

 

1.Folder
2.Analysis

 

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.

 

fbtm_analysis_with_sections

 

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:

 

1.Analysis toolbar
2.Row fields area
3.Column fields area
4.Measure fields area
5.Measures
6.Field list

 

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
5.Load schema
6.Export grid content into various formats
7.Show hints
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
13.Data marker
14.Display Format
15.Field list
16.Statistics

 

 

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.

 

 

See also

Analysis Register Analysis

Analysis Walk Through Analysis Example

Analysis Reuse Possibilities

Analysis Data Source

Browse

Reports

Event Processing

 

 

browse.htm">Browse

Reports

Event Processing