Admin

Allows you to administer users and groups. You can set access rights and view system logs.

Users, groups and access rights are all specific to the domain using which you have logged in. You will not be able to login nor use these access rights on another domain.

Users

The screen displays the list of users and the groups to which they belong.

Figure 2.34. List of Users

List of Users

To enable or disable a user, toggle the Enabled checkbox.

To make or remove an user as an administrator, toggle the Administrator checkbox.

Adding a User

  1. Click Add.

  2. Fill in the appropriate details.

    Figure 2.35. Add a User

    Add a User
  3. Optionally, to add the user to a group, click the icon next to the group.

  4. Click Save to add the user.

Editing a User

The user name cannot be edited. To edit the other details, click the user name from the Users screen and follow the process as described in the section called “Adding a User”.

Deleting a User

Click the user name from the Users screen, and click Delete.

Groups

Adding a Group

  1. Click Add.

  2. Fill in the appropriate details.

    Figure 2.36. Add a Group

    Add a Group
  3. Optionally, to add a user to the group, click the icon next to the user.

  4. Click Save to add the group.

Editing a Group

The group name cannot be edited. To edit the users in a group, click the group name from the Groups screen and follow the process as described in the section called “Adding a Group”.

Deleting a Group

Click the group name from the Groups screen, and click Delete.

Access Matrix

Allows you to set the access rights for each user. The access rights are:

Figure 2.37. Access Matrix

Access Matrix
  1. AdhocDashboardEdit: Allows the user to create, edit and delete dashboards.

  2. AdhocDashboardView: Allows the user to only view dashboards. The user cannot create, edit and delete dashboards.

  3. AdhocReportEdit: Allows the user to create, edit and delete reports.

  4. AdhocReportView: Allows the user to only view reports. The user cannot create, edit and delete reports.

  5. SignIn: Allows the user to sign in to the Ambience Web Interface.

  6. SSOAuthentication: Allows the user to sign in to the Ambience Web Interface using Single Sign On.

The Select All and Deselect All options toggle the selection of the access right for all users.

For enhanced security:

  1. Deselect All will NOT turn off the SignIn access right for the curent user.
  2. Select All will NOT turn on the access right for the anon user.
  3. Deselect All will turn off the access right for the anon user.

Logs

You can view logs of everything that takes place on the system. All user logs are displayed for you to view as an administrator, and take the appropriate actions.

Figure 2.38. Admin Logs

Admin Logs

Drivers

This page lists the JDBC driver configuration for databases that have been configured on the system.

Figure 2.39. JDBC Drivers

JDBC Drivers

To enable or disable a driver configuration, toggle the Enabled checkbox.

To delete a driver configuration, click Delete.

Adding a Driver Configuration

  1. Click Add Driver.
  2. Enter the appropriate driver details as shown in the following example:

    Figure 2.40. JDBC Drivers

    JDBC Drivers
  3. Click Save to save the driver configuration.

These driver configurations are displayed as driver suggestions in various other screens where JDBC drivers are used. For example, the Connection Pool wizard displays these driver suggestions as shown in Figure 2.41, “JDBC Driver Suggestions”:

Figure 2.41. JDBC Driver Suggestions

JDBC Driver Suggestions

Download the appropriate driver files from the respective database vendors. Place them in the /lib directory and restart the server to have them loaded.

Calendars

Calendars allow you to define the period when your scheduled jobs should NOT run. You define the schedule when you want to run your jobs, using the Scheduler as described in the section called “Schedule”. If you want to define periods when you do not want your jobs to run (for example on weekends or public holidays), you define them in a calendar and then use the calendar in the scheduler.

For example, assume you want to generate a sales report every day, automatically, but do NOT want to generate the sales report on weekends (as the staff are on holiday). You perform the following steps to achieve this:

  1. Define a calendar entry to NOT run your sales report generation job on weekends.
  2. Define the sales report job to run each day using the scheduler as described in the section called “Schedule”. Select the calendar defined in step 1, in the Scheduler.

The sales report will now be generated every day, except on weekends.

There are four built-in calendars as shown in Figure 2.42, “Built-in Web Calendars”

Figure 2.42. Built-in Web Calendars

Built-in Web Calendars
  • 9am-5pm only: Jobs only run between 9 AM to 5 PM each day.
  • 9am-6pm only: Jobs only run between 9 AM to 6 PM each day.
  • Weekdays only: Jobs run each day but not on weekends (Saturday and Sunday).
  • Weekends only: Jobs only run on weekends (Saturday and Sunday).

To add a new calendar, click Add.

The Web Calendar screen appears as shown in Figure 2.43, “Web Calendars”.

Figure 2.43. Web Calendars

Web Calendars

To create a calendar:

  1. Enter a name and description for the calendar. The name and description are not mandatory. However, when creating the job schedule from the scheduler [as explained in the section called “Schedule”], this name is displayed in the calendar drop-down to help you select it. The description helps you remember the purpose of the calendar.
  2. Optionally, select the time zone from the drop-down list. Jobs are run on the specified days and times, based on this time zone. The default choice of "System Default Time Zone" uses the same time zone as the system on which Ambience is running.
  3. Select the periods when the job will NOT run. Usually, you want to run your jobs periodically, except on certain days or times - for example, on holidays, weekends or at certain times when backups are running. Hence, it is more convenient to select the periods when your jobs should NOT run.

    You can select ANY of the following criteria - days of week, days of month, particular times of the day and specific dates.

    For example, if you select Sunday, and the time period as between 10 PM and 11 PM, the job will NOT run every Sunday, AND between 10 PM and 11 PM each day.

  4. Alternatively, you can just enter a CRON expression to denote the days and times when the job is NOT to be run.
  5. Click Save to save the calendar.

Example 1: Your job should NOT run between 10 PM and 11 PM Singapore time, each day, as that is the time when your data is being backed up.

The relevant selection for this calendar is shown in Figure 2.44, “Web Calendars - Example 1”.

Figure 2.44. Web Calendars - Example 1

Web Calendars - Example 1

Example 2: Your job should NOT run on Saturday and Sunday and 2 Public holidays - for example, 1 Jan 2015 and 25 Dec 2015, as the staff are on holiday.

The relevant selection for this calendar is shown in Figure 2.45, “Web Calendars - Example 2”.

Figure 2.45. Web Calendars - Example 2

Web Calendars - Example 2

Example 2 shows you how to define your weekends, as well as public holidays, when your job should NOT run, as the staff may be on holiday.

Example 3: Using CRON, your job should NOT run on the 31st of March, each year, as the system may be processing financial year end activities.

The relevant selection for this calendar is shown in Figure 2.46, “Web Calendars - Example 3”.

Figure 2.46. Web Calendars - Example 3

Web Calendars - Example 3

After you create and save a calendar, you can use it in the scheduler as described in the section called “Schedule”.

Universe

The Universe section allows you to map a Universe to a specified universe name and then export the Universe in a format suitable for use by Ad-hoc Dashboard and Ad-Hoc Report.

Adding a Universe Mapping

To add a Universe mapping:

  1. Click Add Mapping. The Add Mapping screen displays as shown:

    Figure 2.47. Adding a Universe Mapping

    Adding a Universe Mapping
  2. Enter a name for the Universe and select the Universe file.

  3. Click Save to save the mapping.

Publishing the Universe as a Template

To publish the Universe in a format suitable for use by Ad-Hoc Dashboard and Ad-Hoc Report, enter a name for the template in Publish Ad-hoc Template as. Then, click Dashboard or Report respectively.

Setting Universe Access Permissions

By default, everyone can access the Universe provided it is saved in a publicly accessible folder, i.e. not in any User folder.

Optionally, to set restrict the users and groups who can access the Universe:

Click the Add icon () next to the user or group to move it from the Available section to the Access Granted section, as shown:

Figure 2.48. Setting Access Rights for a Universe

Setting Access Rights for a Universe