5 The FMS Dashboard

The Dashboard and the Fleet screens appear on your system start-up.

Dashboard

The Dashboard displays the daily data of ships. The revenue is grouped by financial classifications. The top 10 nationalities and the Age group chart represent the current status of guests onboard.

You can customize the Dashboard for individual login with the below steps.

Right-click inside the Dashboard and select Show Customization Form. Drag and drop the individual items to the Dashboard.
Save your customized layout.
Right-click inside the Passenger Status [Last Poll Date] window and export the details to other formats, such as HTML and PDF. The following figure explains the Age Group chart that represents the current status of guests onboard.

Figure 5-1 The Age Group Chart

The Fleet

The Fleet screen shows the itinerary of the ship in a calendar view and according to the branding. The ships are arranged according to their branding in the left pane. For example, all ships belonging to the default brand would show under Default. When you select the individual dates, the details about the passengers, crew, and the revenue for that selected date is shown.

Overview of Guest Relation Management

You can view and/or customize the guest details in the Guest Relation Management screen by:

Guest Details
Group Management

The following topics are available in this section:

Viewing Guest Details

In the Fleet Management screen, select Module menu, and click Guest Relation Management.
In the left navigation pane of the Guest Details screen,
1. In the Search section, enter Passenger Info in the given fields.
2. Click the Ships field and select the ship from the list.
3. Click the Cruise field and select the cruise from the list.
4. Select a port. Multiple port selection is allowed.
5. Click Search to search for the details. A list of ships appears in the right pane.
6. Select the ship of your choice and expand the list.
7. Select the guest from the list and the information is reflected in the extreme right pane.
8. Under Embarkation/Disembarkation, select the Start and End dates from the drop-down list.
9. Click Search on the lower left of the panel. The information appears on the right side.
10. Click Port to view the details of all the stored ports.
11. Search the Date Range from the guest embarked port to guest disembarked port.
12. Enter your frequent cruiser card information, under the Card info.
13. Enter the information in the given fields, under Special Criteria.
Note:
Search criteria can work with any selection and it is not mandatory to choose the date and port together. You can also search by date and port individually and results are generated accordingly.
In the Settings section:
1. Select Public or Private settings.
2. Insert a template name and select Save Current.
3. Select an existing XML template in the Load From drop-down list.
4. Click Delete Current to delete the template.
  
  Note:
  If Private setting is selected, the template will only appear to the user who logged-in whereas the Public setting will show the template to all users.
From the Grid Apperance section, click the collapsible button and select the color of your choice to change the color of the screen.

Note:
Not all onboard available Guest Details are shown on the Fleet Management screen, but these details are available for marketing data exports.

Viewing Group Management

Group Management is similar to the Guest Management screen. For more information about Guest Management, see Viewing Guest Details

Viewing Shore Excursion Management

Sales data and the number of guests attending the tour are shown on the Shore Excursion Management screen.

On the Fleet Management screen, select Module menu, and click Shore Excursion Management.
In the left navigation pane of the Excursion Setup Details screen, in the Search section, enter Excursion details in the given fields and click Search. The Shore Excursion details are displayed in the right pane.

Customizing Statistical Analysis

The Statistical Analysis screen provides financial data in form of pivot grids.

In the Fleet Management screen, select Reporting and Utilities menu, and click Statistical Analysis. The Statistical Analysis screen appears.
In the left navigation pane of the Statistical Analysis screen,
1. In the Search section under Ship/Cruise, enter information in the given fields.
2. Under Demographics, enter Nationality, Age-Group and Gender.
3. Under Date Range, enter Start Date, End Date, and Fiscal Year.
4. Under Classifications/Departments, in Main Department and Sub Department fields, enter Group, Classification and Department details.
Drag and drop the individual items from Ship/Cruise, Demographics, and Date Range into Passenger Revenue Analysis pane. The data are shown in the columns.
On Statistical Analysis screen, click Department Analysis. Department Analysis screen appears in the right pane.
You can rearrange the columns and rows in the Department Analysis pane.

Note:
All the selected data from the various grids are visible in the form of graphical representation at the bottom of the screen.
To collapse or expand a list of Departments or Classifications, right-click anywhere in the Classification result shown in the Department Analysis pane, and select Collapse All or Expand All.
Select values in the grid and right-click the selection to export the details to other formats for example, .XLS, HTML, or PDF.
To use the Filter Editor, right-click the column header and click Filter Editor. The Filter Editor enables you to include a criteria filter.
In the Settings drop-down list:
1. Select Public or Private settings.
2. Insert a template name and select Save Current.
3. Select an existing XML template in the Load From drop-down list.
4. Click the Delete Current to delete the template.
  
  Note:
  The Private settings only enable user who logged in to view this template. The Public settings shows the template to all users.

Exporting a Template

Data can be exported to a file for external data activities. There are two ways to export the data.

On the Fleet Management screen, select Reporting and Utilities menu, and click General Utilities.
On the General Utilities screen, click File Export Utility. File Export screen is displayed.
In the left navigation pane:
1. Select the Template from the drop-down list.
2. Select the Type from the drop-down list, select Add Column Header check box, and then click Export.
3. In the Search drop-down list, enter information in the required fields.
Select values in the grid and right-click the selection to export the details to other formats, such as *.XLS, HTML, PDF and so on.
To apply Filter Editor, right-click the column header, and click Filter Editor. Filter Editor enables you to include a criteria filter.

Note:
If you do not select any specific criteria in the search panel, by default, all the stored data gets reflected on the File Export screen.
Right-click the selected grid and select Column Chooser to customize your selection. Drag and drop the required columns into the Customization box.

Financial Classifications

Fleet Management System Financial Classification Setup enables you to group and analyze the data by classifying them into Main and Sub department’s types, and have various departments grouped within each of the department types based on financial or unique similarities

Figure 5-2 Grouping of Main and Sub Departments

This figure shows that Main and Sub departments are grouped into Main and Sub departments classifications, and then grouped to Main and Sub department groups.

This data is further classified into two categories:

Main Department - Group Classification

Main departments are grouped into main department classifications, and then to main department groups
- Main department group (to be setup in FMS)
- Main department classification (to be setup in FMS)
- Main department of the individual vessel (as data transfer from the ship)

Sub-Department - Group Classification

Sub-department are grouped into sub-department classifications, and then to sub-department groups.
- Sub-department group (to be setup in FMS)
- Sub-department classification (to be setup in FMS)
- Sub-department of the individual vessel (as data transfer from the ship)

Note:

The main and sub-department hierarchy is separate.

Other Classifications

Other classifications enable you to group and analyze data on the cabin, category, sailing region base, and so on. Following are the current potential classifications and their descriptions:

Table 5-1 Classifications and their descriptions

Classifications	Descriptions
Cabin Classification	Special grouping for cabins could be: Inside, outside, suite, Crew, staff, officer.
Category Classification	Ships stateroom categories can be grouped to the advertised brochure cabin categories, such as Deluxe Suite, Standard A; B; C, and so on.
Cruise Itinerary Classification	The cruises can be grouped by its cruise regions following brochures releases or other analyzing criteria’s, such as Europe, Mediterranean, Caribbean, Alaska, Baltic, and so on.
Cruise Season Classification	The cruises can be grouped by its cruise seasons following brochures releases or other analyzing criteria’s, such as Fall 2009, Spring 2010, Summer 2010, Holidays 2010, Christmas 2010, and so on.
Excursion Classification	Excursions can be classified as requested analyzing criteria’s, such as City tours, walking tours, half day, full day, or Low cost, high cost, and so on.
Maintenance Area or Location Classification	Areas for maintenance analyzing can be grouped fleet wise.
Maintenance Task Group Classification	Maintenance tasks can be grouped (higher level) and classified (lower level) for analyzing purpose.
Medical Item Group Classification	Medical sales items can be grouped (higher grouping level) and classified (lower grouping level).
Menu Item Group Classification	Menu sales items can be grouped (higher grouping level) and classified (lower grouping level).
Ship Category and Ship Classification	The vessels can be grouped by its ship category (holiday, rating category *****, and so on.) or by its ship classes (gross tons, Guest capacity, and so on.)

Setting Classifications Types

This topic describes how to set up and assigns Fleet Management System financial groups and classifications.

On the Fleet Management screen, select Reporting and Utilities menu, and click General Utilities.
Select Classification Setup, Setup, or Classification Type.

Note:
The Classification Types are predefined.

Classification Assignment

The Main and Sub-department can be assigned to their respective Classification/Group using the drag and drop method.

On the Fleet Management screen, select Reporting and Utilities menu, and click General Utilities.
Select Classification Setup, Assignment, Main Dept. Group or Sub Dept. Group.
1. Select a ship. You can view the ship if the default radio button Ship view is selected.
2. Expand + next to UNCLASSIFIED.
3. Drag the departments from UNCLASSIFIED to the required department classification. You can select multiple departments by using the Shift key.
Click Update All Postings.
Once all departments are classified, the financial posting records (POS table) are stamped with the Classification ID and the Classification description.

Assigning Main and Sub-Department

On the Fleet Management screen, select Reporting and Utilities menu, and click General Utilities.
From General Utilities, Setup, Classification, select Main Dept. Group or Sub Dept. Group.
Right-click to add and assign a Group (Main or Sub) or Classification (Main or Sub).

Note:
The classification should be linked to a higher lever Group under the Depend Type field.

Shore Side Departments

Data or information provided in Fleet Management is useful for corporate departments like Hotel Operations, Customer Services, Onboard Revenue, Finance, Marine Maintenance, Human Resources, and Marketing.

The following topics are available in this chapter:

Hotel Operation

The main areas of interest of a hotel operation are:

Passenger data – Passenger listings per cruise/vessel/time period, including manifest data like Name, passport number, Date Of Birth, Guest picture, cruise and cabin details, address, flight details, etc.
Guest history records (all cruises per individual Guest).
Guest comments/complain data – per individual Guest and as analyzing summary per cruise/ship/fleet.
Amenities and special request data.
Medical records – individually per Guest, cruise/ship/fleet statistics. Possible medical fleet item classifications like Procedures, Medicines, X-rays (transactions, not images), Laboratory, etc.
Onboard spending and invoice data - Guest checks and invoice details.
Guest Comment Card data (cruise evaluation forms) – per individual Guest (image of scanned Guest card), analyzing, data comparison and charts per department, sailing, ship, fleet comparison.
Work-order – per individual Guest/sailing and as analyzing summary.
Guest group data – group, members, spending, and satisfactory level details.
Financial performance per division – sales analyzing per sub-divisions like Housekeeping, Front Office using financial Fleet Management Flash Groups. Revenue reporting for selected departments only.
House Account spending control - House Account, cruise, Guest check level.

Customer Service Department

For post-cruise customer service contact and/or analysis of customer satisfaction levels, the main areas of interest are:

Guest Invoices, Guest checks - can be recreated (printed, exported to file) at any time directly within Fleet Management.
Medical insurance invoices (Insurance claim forms) - can be reproduced (if initially issued onboard using medical module).
Individual Guest comments and complaints - onboard follow-up taken, Guest compensations per Guest/cruise.
Group records and account information.
Guest and public areas maintenance Work-order - statuses, date and time of completeness.
Credit card authorizations, settlements per Guest/cruise/transaction can be verified if transferred and required (details masked).
Amenities and special request – verifying inserts.
Guest history records (all cruises per individual Guest).
Application activities – time of check- in, routing of posting, close accounts, etc.
Gangway activities – verifying onboard presence during certain occasions.
Individual Guest Comment Card ratings with included handwritten comments on the Comment Card.
Complaint and work order statistics.

Onboard Revenue Department

The main areas of interest are analyzing onboard revenue by:

Financial main and sub-department - by ship, ship class, cruise, fleet.
Financial classification - main and sub-group, classification.
Shore excursion - revenue analysis, per tour, port, country, excursion, demographics.
MICROS item analysis – item count and revenue per item (cruise, ship, and fleet).
Region analysis – revenue comparison of travelled region (Alaska cruises, etc.).
Demographic analysis – revenues per nationality, age group, gender, etc.
Back to back spending pattern – comparison of repeaters versus first cruiser.
Group spending comparison, reporting.
Revenue breakdown – average passenger per day, etc.
Selective revenue charting.

This includes the creation and assignment of financial sub/main department groups/classification, item classifications, and excursion classifications.

Finance Department

The main areas of interest to management are the financial reporting and verifying financial reports, submitted by the ships as well as cash book and payroll data.

The main financial classification usually follows the corporate financial reporting grouping.

This includes creating and assigning financial sub/main department groups/classifications.

Department Analysis – reporting by financial main and sub-department (cruise, ship, and fleet).
Quarter Revenue Reporting – following the calendar quarters.
Void journal controlling.
Revenue reporting for Crew.
Payment journals.
Open balance reports.
System account analysis.
Cash book – reporting different currency cash books.
Online Credit Card Management - CC authorizations, settlement, per Guest, cruise, ship, fleet, type.
Payroll Overview and Reporting

Marketing Department

It is possible to review customer revenue-behavior and feedback based on demographics (nationality, gender, age mix/profile). The main areas of interest are:

Guest onboard spending based on demographics.
Spending analyzing per department and demographics.
Guest Comment Card summaries (if the Comment Card module is used).

Includes cruise classification, cruise region classifications, and category classifications.

Adding and Editing a Ship

The section describes how to configure a new ship or edit an existing ship details in Fleet Management Viewer.

On the Administration screen, click Ship Setup.
Select Details and then select Fleet Management.

Fill in the following details in Ship Details:

Table 5-2 General properties for Adding a Ship

Properties	Description
Status	Select the status as Active/Dry Dock/Inactive. By default, the status is Active. This is a mandatory field.
Ship ID	Enter the ship ID. The ship ID should be between 11 and 98. The Ship ID must be unique and if duplicated, gives an error. This field is mandatory. Note: This field is enabled only in the Add mode. Right-click to edit this field.
Ship Name	The Ship Name of the selected ship gets automatically displayed.
Ship Short Name	The Short Name of the selected ship gets automatically displayed. Note: This field is enabled only in the Add mode. Right-click to edit this field.
Company Name	Enter the name of the company. The maximum length is 50. A pre-filled list of existing distinct values of this column can be displayed for selection. If you want to enter a new value, type the value. The status is enabled always and this field is not mandatory.
Classification	Select the Classification from the drop-down list.
Category	Select the Category from the drop-down list.
Security Class	Shows the default.
Ship Image	Shows the image of the ship.
ERS status	Select the Emergency Response Status as Yes or No. The default status is NO. If you select Yes, you are setting frequent data transfer from ship to shore. Note: This option should be enabled in case of Emergency only.

In the Selected Ship Partitions List, select only the tables.

Note:
Green color signifies the tables exist, and red color signifies the tables does not exist.
Click Save and click Yes to continue.
In the left navigation pane, under Ship Selection, right-click the ship you need to edit. Do the required changes and the data is edited and saved in the database.

Change Logs and Error Logs Details

On the Administration screen, click Ship Setup.
Select Change Logs or Error Logs.

Under Ship Selection, select the ship. The data is displayed on the Change Logs or Error Logs screen.

By default, the results are populated with date and time and in descending format.

Following is the column description for Screen Change Logs and Error Logs:

Table 5-3 Column description for Change Logs and Error Logs

Column	Description
Procedure Name	Ship Insert/Update/ with schema name.
Log Details	Displays the detailed log of what activity is performed by the Admin.
Changed By	Displays the User ID of the logged-in user.
Changed Time	Displays the date and time of the changed log and the time of the error.

Adding Users and Groups

User authorization privileges are configured within the Fleet Management Administration module. Fleet Management uses an authorization mode where each user belongs to one or more user groups, and then the user gets all the privileges assigned to the user group(s). Alternatively, Fleet Management can use Active Directory as an alternative for authentication/authorization. In the Active Directory mode, the Microsoft Windows user is used to login into Fleet Management.

To add Groups and Users to the Cruise Fleet Management System:

To create a group:
1. On the Fleet Management System screen, from the Administration menu, select General.
2. On the Administration screen, click User Security and then click the Group. On the left panel under Groups, right-click any group and click Add.
  After selecting the information for the group and the user rights, click OK to save. The administrator can select the various modules to create groups.
To create a user:
1. On the Administration screen, click User Security. On the left panel under Groups, right-click any of the group and click Add.
2. Enter the User Login, Password, First Name, Last Name, Group, and Class. You can enable or disable the user by selecting the User Enabled check box.
3. Select the drop-down list of the group section and then click OK.

Logging And Security Shore-Side

In Fleet Management System, users are assigned rights based on their department/group. The departments can be Finance, Operations and Administrators, and rights that are assigned to them. Access rights are assigned based on group and users can be allotted within them, thus maintaining a filter of access. Groups that are part of Administrators will have full access rights. In the case of an invalid user name or password used at log in, a warning will appear on the screen. The user is locked out on the seventh (7th) attempt for five (5) minutes if incorrect credentials are entered.

Fleet Management System has a dedicated screen that logs the users’ access to different modules and applications, which shows the details of users and the activity they performed on the application including the date, workstation, OS User and user name.

Logging In FMS Database Shore-Side

Logging into Fleet Management System Database Shore-Side explains the Activity Logs of the logged-in user.

The user’s access log to different modules in Fleet Management System application is stored in the ACTIVITY_LOG table in FCFMSADMIN schema in the database.
The ACTIVITY_LOG table logs in all activities of the user in the FMS System. These details can also be viewed from the FMS Activity Log Viewer function.
Each DDL activity performed is recorded in the FIDELIOBK.DDL_AUDIT table.
FIDELIOBK.DDL_AUDIT table capture activities like CREATE, ALTER, DROP, RENAME OR TRUNCATE ON SCHEMA.

Active Directory Integration In Fleet Management System

Active Directory is activated by changing a parameter in the database. The parameter table has a Y/N flag as PAR_VALUE within the Group. When the parameter is set to Y, the Active Directory is integrated with Fleet Management System. The integrated Active Directory function in the following manner:

Upon start-up the application fetches the active directory information of the OS user.
Once the user is authenticated by the active directory, only then they can access the application. If the authentication is not done, then the application closes after giving a message.
The active directory connection details are logged once the Active Directory authentication is done. The details logged are date, user, domain, email, group, and workstation.
If User Groups do not already exist, then they are added to the User Groups of the Active Directory.
The Operating System user gets the rights assigned to the Active Directory Groups within the application.

Setting up Active Directory

To set up an Active Directory:

Identify the users who must have administrator privilege in the Fleet Management System Application.
Ensure all such users belongs to the same domain.
Notify the exact domain group name for administrator rights so that we can set them up.
Once privileges are granted in Fleet Management System, the domain group users can try running the Fleet Management System from their domain group logged- in machines.
Any user of the domain with administrator privileges can grant or revoke privilege to users of another domain group.
All user privileges are based on domain group, hence any user belonging to a domain has the same privilege as members of that domain group.
A user belonging to more than one domain group would have the privilege that are union of both domain group.
Once a user from any new domain group logs in; their details are automatically entered in required tables.
The administrator user from the Administrator group as identified above can then give desired rights by right-clicking on the domain group and selecting edit.