Skip to main content
Skip table of contents

Getting Started - SuperWEB2

This section describes how to get started with SuperWEB2. It shows you how to login to SuperWEB2 and start creating tables.

Step 1 - Login

SuperWEB2 is a browser application. Your system administrator will provide you with a URL or link for your SuperWEB2 installation.

The first step is to open your web browser and enter the URL in the address bar or click the link that has been provided to you.

SuperWEB2 displays the login page, which will look similar to the following (although your installation may have been branded and may therefore look slightly different to this example):

If you have been given a username and password, enter the details and click Log in.

Guest User Access

If you do not have a username and password, you may be able to login as a guest user: if you can see the Guest log in option, click this to use SuperWEB2 in guest mode:

Guest users cannot save tables, and may only have access to a subset of the databases installed on the server.

If you do not see this option then this means your administrator has disabled guest access.

I Do Not Have a Username/Password

If you are unable to use guest mode and do not have a username and password, contact your system administrator to obtain access.

I Am Unable To Login

SuperWEB2 displays an error message if you enter the wrong login credentials. If you enter the wrong credentials more than a certain number of times, your account may become locked.

If this happens you may need to contact your system administrator to have your account unlocked (depending on how your system has been configured; it is also possible that your account may become unlocked automatically after a short period of time).

Step 2 - Select a Database

Once you have logged in, SuperWEB2 displays the database catalogue.

Use this screen to select the database or table you want to work with:

  • The list on the left contains databases and saved tables that you can open. Double-click an item in the list to open it.
  • The area on the right displays information about the currently selected database. Click once on an item in the database list to see more information about that database or table.
  • You can use the search area at the top to find a particular database or saved table. Enter some text in the box and click Explore. The list of databases and tables will be filtered so that it only shows tables or databases whose names contain the text you searched for.

Locate and open the database or table you want to work with.

The rest of this section uses examples from the sample Retail Banking database. To follow the examples, double-click the Retail Banking database to open it.

Step 3 - Build a Table

Once you have opened a database, SuperWEB2 displays the Table View, where you can build tables:

The Customise Table section on the left shows a list of available fields and field values you can add to the table. If this area does not display, click Customise Table to show it.

The area on the right is where your table displays. This area will usually not contain any table when you first open a database. The exception to this is if your administrator has configured Mandatory Fields. If this is the case a basic table containing all the mandatory fields will appear in the section on the right; you will be able to add fields to the table, and make other changes, but you will not be able to remove the mandatory fields from the table.

To create a table, select the fields you want from the list and add them to either the table rows or columns. For example (using the sample Retail Banking database), suppose we want to create a table with Gender in the rows and Marital Status in the columns:

  1. Go to the tree on the left. This is where you select the fields you want in your table.
  2. Click the arrow on the left of Customers to expand the list of available fields:
  3. Click the arrow on the left of Gender to expand the list of values available for this field:
  4. Select the check boxes next to the values you want to add to the table, for example Male and Female:
  5. Click Add to Row:

    SuperWEB2 adds these values to the table:

    When you add the first field values to the table, SuperWEB2 also adds the default summation, so that your table has something to measure. Typically the default summation will be something like a count. For the Retail Banking database, the default summation option is to count customers.

    Next we will add the Marital Status field to the column headings. This time, as an alternative to selecting all the values we want, we will use a shortcut that allows us to quickly select all the available values.

  6. Click the arrow to the right of the Marital Status field:

    A drop-down list appears:
  7. Select Marital Status from the drop-down list. This field only has one level, so selecting this option will select all the available values for the Marital Status field:

    You can see that SuperWEB2 has selected all the values if you expand Marital Status:
  8. Click Add to Column. SuperWEB2 adds all the selected values of Marital Status to the column headings:
  9. Click Retrieve Data to perform the cross tabulation:

Step 4 - Modify the Table

Now that we have created a basic table, there are a number of changes we could make. The following are just some examples.

Remove Some Values

Suppose we have decided that we do not want to include all the values of the Marital Status field in the table. We can use the tree on the left to remove individual field values.

For example:

  1. Click the arrow on the left to expand Marital Status if it is not already expanded:

    The field values that are currently in the table appear in bold and italics (in this case, all the values are in the table, because we used the Select all at level option to select and add them all):
  2. Select the check boxes for the values you want to remove from the table (for example Unknown and Not Applicable), then click Remove from Table.

    SuperWEB2 removes these values from the table.
  3. Click Retrieve Data again to repeat the cross tabulation:

Move a Field to a Different Axis

Suppose you want to swap the columns and rows. Simply drag and drop the field names from within the table.

For example:

  1. Drag and drop the Gender field name onto the column headings:

    This adds Gender to the column headings with Marital Status nested beneath it:
  2. Now drag the Marital Status field name onto the rows:

    The table updates:

Remove a Field Entirely

The easiest way to remove an entire field from the table, is to drag and drop the field name onto the bin/trash icon:

SuperWEB2 removes the entire field from the table:

Clear the Table and Start Again

To clear the table and start again:

  1. Click the Clear Table icon:

    SuperWEB2 will prompt you to confirm that you want to delete the table.
  2. Click OK:

    SuperWEB2 clears the table:

Switch to a Different Database

If you decide you want to switch to working with a different database, click the Select database or topic link in the top right:

Switching to another database or table will clear the current table. If you think you might want to use the table you were working with again, you may wish to consider using the save table feature.

Next Steps...

This section has explained how to get started with SuperWEB2. Now that you know how to login and create a simple table, see the following sections to learn more about what else you can do:

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.