AdminUtility
The MarketWide Administration Utility lets you configure advanced settings for MarketWide, such as adding/removing databases, drilldowns, lookups, and picklists.
After installation, you can configure MarketWide for users with the MarketWide Administration Utility, available from the MarketWide main window. This utility lets you specify databases, picklists, lookups, and other helpful features. MarketWide stores these settings in the catalog. The rest of this section discusses how to use the MarketWide Administration Utility to configure MarketWide.
The MarketWide Catalog
MarketWide makes use of a catalog to preserve information about databases, table names, and field names required for using each server, in addition to features such as picklists and lookups. The catalog is created during installation, but any work done to the catalog takes place in the MarketWide Administration Utility. The catalog is saved on the host machine, and every time users access it when launching MarketWide, they receive the most current catalog, including all updates and administrative changes.
Each time an Administrator makes changes to the catalog, a temporary work catalog is created where edits can be made so that it does not interfere with the primary catalog. After changes are completed, the Administrator must save the working catalog by clicking Save. If you leave the MarketWide Administration Utility, you will be asked if you want to save the catalog. Once you have made all the changes to the catalog, you must commit the catalog to replace the primary catalog with your saved work catalog.
To commit the catalog, click the Commit button () on the AdminUtility toolbar. You must have saved a working catalog before committing that catalog. The changes will only affect users upon launching MarketWide, where they will receive the newest version of the catalog. If a user is currently on MarketWide when a new catalog is committed, they will be prompted to download the new catalog.
If you elect to save your changes without committing, the next time you launch the MarketWide Administration Utility, you will receive a message that asks if you would like to continue with the previously saved changes, or drop all uncommitted changes and start over.
To Commit the Catalog
After making changes to the catalog, click Save ().
Once you have saved a working catalog, click Commit () and Close.
The AdminUtility Menu and Toolbar
The AdminUtility toolbar provides quick access to commonly used commands in AdminUtility. Click the icon once to carry out the action represented by that icon.
Icon | Description | Menu Equivalent |
|---|---|---|
 | Allows you to commit the changes you have made and update the catalog. | File > Commit |
| Saves changes without committing them to the catalog. | File > Save |
– | Exits the MarketWide Administration Utility. | File > Exit |
| Depending on which folder is selected, allows you to delete properties from the right pane. | Edit > Delete |
| Allows you to refresh all databases, owners and tables. | Edit > Refresh |
– | Opens the Manage Table Filters dialog box. | Edit > Manage Table Filters |
| Opens the Add Drilldown dialog box. | Edit > Add Drilldown |
| Opens the Add Lookups dialog box. | Edit > Add Lookup |
| Opens the Add Picklist dialog box. | Edit > Add Picklist |
-- | Opens the Manage All Fields dialog box. | Edit > Manage All Fields |
-- | Opens the AdminUtility Help files. | Help > Admin Utility Help |
Print Formats
MarketWide supports the standard print formats available in Microsoft Excel.
For your convenience, this section contains definitions of the print format characters and examples of common print formats.
Character | Description |
|---|---|
# | A hash symbol represents a whole number. |
0 | A zero means you want to display insignificant zeros if a number has fewer zeros than specified in the format. |
% | Adding the percent sign to a print format displays the number as a percentage of 100. |
$ | Adding the dollar sign to a print format displays numbers preceded by the dollar sign. |
, | Inserts a comma as a thousand separator. |
Examples of Common Print Formats
To Display... | As... | Use this Format... |
|---|---|---|
2500 | 2,500 | #,### |
1.2 | 1.200 | #.00 |
.224 | 0.2 | 0.# |
25.99 | $25.99 | $#.00 |
0.3796 | 38% | 0% |
0.3796 | 37.96% | 0.0% |
To Enter Default Print Formats
Click the Print Formats (
) icon.
In the Data Type Print Formats dialog, enter the necessary format for each Data Type in the Format column. MarketWide supports the standard print formats available in Microsoft Excel.
After making changes to the catalog, click Save ().
Once you have saved a working catalog, click Commit (
) and Close.
Drilldowns
Drilldowns allow you to right-click an item of interest on any MarketWide screen and view more information about the item. In short, drilldowns typically provide quick access to commonly wanted information. There are three integrated drilldowns in MarketWide, but you can have any number of custom drilldowns built from stored procedures using Rexx scripts. The three drilldowns are the Customer Information Report, the Field Information Drilldown, and the Frequency Distribution Drilldown.
There are similarities and differences between the Customer Information report, Field Information drilldown and Frequency Distribution drilldown:
Customer Information Report
The database administrator must complete the Customer Key setup prior to running the report.
The report option is available from the main MarketWide window using the Reports a Customer Information option.
Field Information Drilldown
The database administrator attaches the integrated stored procedure to the MarketWide catalog.
The drilldown option is available from any MarketWide output window.
Frequency Distribution Drilldown
The database administrator attaches the integrated stored procedure to the MarketWide catalog.
This drilldown is only available as a right-click menu option from fields in the right pane of the SQLManager window.
The drilldown is run by performing calculations on selected fields using Analyzer, MarketWide's data analysis program.
To Add a Drilldown
Click on the Drilldowns.
Right click and select Add (
) Drilldown
Click the Add button to select a table.
From the Drilldown Field drop-down menu, select one of the common fields that were found across your selected tables. The Attach to Fields menu will be filled in for you.
Finally, give your new Drilldown a name. This name will appear in MarketWide when you right-click on your selected Drilldown field.
Click OK to save your changes.
After making changes to the catalog, click Save ().
Once you have saved a working catalog, click Commit () and Close.