Bottom     Previous     Contents

Analysis Views


As the name suggests, Analysis Views allow you to pull together your Actual, Forecast and Projected data for analysis. Unlike other views, these cross-tab views do not exists until you create them via the Analysis View Configuration Dialogue.


Analysis Cross-Tab View

Select-clicking on the Analysis View button on the Accounts List Button Bar, or the Budget List Button Bar, will open the default Analysis View. If a default view has not been defined then the Analysis View Configuration Dialogue is shown instead.

Creating Analysis Views via the Analysis View Configuration Dialogue is discussed later in this chapter.


Button Bar

 View Maintenance.

 Display Currency Options.

 Currency Total Summary.

 Print Analysis View.


Value Types

A value's type is just a name depicting where the values came from, and what they represent.

There are four Types of value:


Refreshing Data

For consistency, Analysis Views do not respond to changes in the underlying environment: data modifications and currency fluctuations, occurring after the view is opened, are ignored.

Select Refresh Data from the view menu to have any changes incorporated in the view.


Including Projections

Tick Include Projections on the view menu if you wish to have values from Projections included in your Actual values. Projections are projected based on the Projection Settings, the analysis period does not influence their existence in any way.

Note: changing this option also causes view data to be refreshed.


Active Value Type

Nominated from one of the four Value Types, the Active Value Type determines which type of value is used for:

The Active Value Type can be set via the Analysis View Configuration Dialogue or the view menu.

Changing the Active Value Type causes your analysis view to be refreshed.


Blank Analysis Keys

Key fields that have not been assigned a value, an Analysis Class of '<None>' for example, are considered blank. By default values accumulated against blank keys are not shown.

Tick Format => Show Blank Key's from the view menu to include values for blank keys.


Inverting Values

By default, Credit and Expenditure values are shown as negative values. However, depending on the intended use of the statistics, vehicle expenditure or credit card activity for example, this may not be appropriate. Therefore, you can elect to show these values with their sign inverted.

Use Format => Invert Credit Accounts and Format => Invert Expenditure as required from the view menu.


Analysis Totals

Both Grand and Sub totals can be added to an analysis view from the view menu.

Subtotals are either Income/Expenditure or Credit/Debit depending on whether the field assigned to the primary key is an Analysis Code or Account ID.

Enabling grand totals also enables subtotals.


View Colouring

The colours used to draw a view are specified via the Analysis View Colours Dialogue.

The Exceptions Field Group specifies the 'alarm' colours for the variance values. An 'alarm' is triggered when the actual variance for a period exceeds the limits specified on the Analysis Code.


Default View

Once a view has been saved, it can be nominated as the Default Analysis View.

The default view is opened in response to select-clicks on the Analysis View Button of the Account List and Budget List button bars.

Tick Default View on the view menu to identify the view as the default.


Currency Considerations

Analysis Views work in Display Currency. That is, all source values are converted to Display Currency before they are accumulated. Setting the Display Currency is the same as setting the Analysis Currency and vice versa.

Transaction values are converted to Analysis Currency in line with your Currency Settings. This will be either: direct from Local Transaction Currency, or indirectly via Account Currency.

Budget Entries are always converted direct from Local Currency.

The information returned by the Currency Total Summary is dependant on the Active Value Type:

The specified Exchange Rate Type is only used by the Base Currency Model to determine which type of exchange rate to use when converting values from Base to Analysis Currency.


Analysis View Configuration Dialogue

To open the dialogue: adjust-click on the Analysis View button on the Account List Button Bar.

To save a view: re-enter the Configuration Dialogue from an active Analysis View and click Save.

To delete a saved view: Select the view name, to load it, then click Delete.


View Field Group


View Name

A name that identifies the view.
You can either:

If you type the name of an existing view, then the original view will be overwritten, should you elect to save the new view.


Description

A textual description for the view.
This field is used for the window title of the Analysis View.


Key Fields Field Group

The Key Fields Group defines the structure of the Analysis Key. The Key determines how values are grouped and summarized within the resulting view. The Key consists of up to three levels. Each required level must be assigned one of the following data fields:

Restrictions:


Periods Field Group


Occurrence

The frequency at which the analysis periods occur.

A frequency can be specified as either:

Date frequencies, Daily through Yearly, occur on a given date irrespective of what day that may be.

Specific occurrences, First Monday through Last Sunday and Last Day, occur on a given day irrespective of what date that may be. If, when selecting a Specific Occurrence, a valid From Date exists, the day-of-month is adjusted accordingly.


From Date

The date the first analysis period starts on.
For Specific Occurrences, the date specified must match the selected day.


Periods

The number of periods required.
The maximum number of periods is 52.


Display Field Group

There are four Value Types available for inclusion on each row of the Analysis View.
Select one, or more, of the following types:

The included Value Types can also be adjusted from the Analysis View Menu.


Values Field Group


Active Value

Identifies which of the four possible Value Types is to be Active.

The Active value is used for operations that require a single value, sorting for example. It is not possible to sort a row by each of the four possible value types, so the active value is used.


Currency Fields

The currency settings for Analysis Views are set via the standard Display Currency Options dialogue.
Click the Set button to open the currency dialogue.


Data Filters Field Group


Transaction

A Transaction Audit Filter can be used to filter the transactions selected for inclusion.
Select the name of a previously saved Transaction Audit Filter from the pop-up menu.
Refer to the section on the Query Module for details on building and saving queries.


Budget

A Budget List Filter can be used to filter the budget entries used to build forecast data.
Select the name of a previously saved Budget List Filter from the pop-up menu.



Next     Top