FB TraceManager 2 - Documentation

Analysis - Walk Through Analysis Example

Analysis - Walk Through Analysis Example

Previous topic Next topic  

Analysis - Walk Through Analysis Example

Previous topic Next topic  

A simple walk through example is discussed in this section. The provided steps should get you started for your own customized analysis requirements. This example will give us the answer for the following question:

 

"What's the number of events along a date dimension with the following hierarchies: year/quarter/month/day".

 

 

Step 1 - Define the date dimension in the row fields area

 

Open the Field list editor via the toolbar. Here you see all available fields for the Analysis module. If the field is of type DATE, then additional fields like year, quarter, month, week, day are available as child nodes.

 

fbtm_analysis_example_field_list

 

Navigate to the first field entry called DATE_TIME. Drag&drop the following child nodes in the here used order onto the row fields area:

 

Year_DATE_TIME
Quarter_DATE_TIME
Month_DATE_TIME
Day_DATE_TIME

 

This should result in an output similar to this one (your data will be different of course):

 

fbtm_analysis_example_grid_1

 

 

Step 2 - Define a new measure aggregating the number of event name occurrences

 

We now define a new measure, which uses a COUNT aggregate function.

 

Open the Edit Measures editor via the toolbar.

 

fbtm_analysis_example_edit_measures

 

Click Add and edit some data as shown in the following dialog.

 

fbtm_analysis_example_edit_measure

 

Click OK. Tick the checkbox of the newly created measure as shown in the following screen.

 

fbtm_analysis_example_edit_measures_selected

 

Click OK. A new measure is now available for selection, which is indicated as:

 

fbtm_analysis_example_grid_2

 

 

Step 3 - Define the column fields area

 

We now drag&drop the entire Measure (1) drop-down box shown as a red rectangle in the screen above onto the column fields area. We end up with something like that, our final result:

 

fbtm_analysis_example_grid_3

 

You now can collapse/expand the various levels along the date dimension. For example, if you are only interested in an annual statistic, either remove the quarter, month and day level completely, or simply collapse them. You then will see something like that:

 

fbtm_analysis_example_grid_4

 

This can be expanded again or mixed with additional fields available in the Field list editor as you like. I guess you now can imagine what powerful feature the Analysis module is.

 

 

What's next: The next section Reuse Possibilities discusses ways to re-use results created with an analysis task.

 

See also

Analysis Basics

Analysis Register Analysis

Analysis Reuse Possibilities

Analysis Data Source

Browse

Reports

Event Processing

 

 

"tdm_browse.htm">Browse

Reports

Event Processing