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.
Topics
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.
Expressions
The Expression Editor allows you to create and save string, mathematical, and date expressions for use in reports in all MarketWide programs.
When using the Expression Editor, you have two options for creating expressions:
- You can use the Expression Wizard option where the Expression Editor takes you step by step through expression creation.
- If you already know the syntax of your expression, you can use the Advanced Expression Editor option to skip the wizard screens and enter the syntax directly.
The next sections address both the wizard and advanced expression building options.
The Expression Wizard
The Expression Wizard systematically prompts you for all the information needed to create an expression. Furthermore, the wizard is especially handy because it alleviates the need to know the exact syntax required to build expressions on your database.
For example, suppose you want to create an expression to calculate the interval between two date fields. SQL Server databases uses the expression datediff(dd, date1, date2), while other servers simply use date1 – date2. To save you the trouble of remembering database-specific syntax, the Expression Wizard constructs a universal expression, which can be interpreted by any relational database.
Option | Description |
|---|---|
General | Allows you to name your expression and enter in a description. |
Return Type | Indicates the Expression type |
Attaches To | Allows you to choose whether to attach the expression to a server, table, or field. |
Attachment Names | Displays a list of available servers, databases, owners, tables, or fields, depending on which attachment type you select. |
Type | Allows you to indicate whether you are creating an expression to calculate a Character, Numeric, Decimal, or date/time value. |
Function | Lists the functions available based on the type of expression you select. A description of the highlighted function appears at the top of the screen. |
Function Descriptions | Displays a brief description of the Function selected |
Parameters | What the selected expression is affecting and to what extent. |
Parameter Description | Displays a brief description of the Parameter selected |
Auto Attach to Joins | If checked it will include the expression in any joins where the attachment method applies. |
To Create an Expression Using the Expression Wizard
- Right click on the Expressions (
) icon and choose Add Expression () - Select an expression Type and Function.
- Choose an Attachment Type and select Attachment Names.
- Enter a value for each parameter as follows:
- For constant values: Type in the value in the expression Value column.
- For field values: Click the Fields button to open the Select Field dialog. Highlight a field in the Available Fields list. Choose OK to confirm your selection.
- Enter a title in the Title field and a description in the Description field and select OK.
To Create an Expression Using the Advanced Expression Editor
- Right click on the Expressions ( ) icon and choose Add Expression ()
- Select the Advanced tab at the bottom of the Wizard.
- Choose an Attachment Type and select Attachment Names.
- Type your expression.
- Enter a title in the Title field and a description in the Description field and select OK.
To Edit an Expression
- Click on the Expressions ( ) icon.
- In the right pane, highlight the expression you wish to edit.
- Right click and select Edit.
- Make your changes.
- Click OK to save your changes.
To Delete an Expression
- Click on the Expressions ( ) icon.
- In the right pane, highlight the expression you wish to edit.
- Right click and select Delete.
- Click OK if you are sure you would like it deleted.
Table Filters
Table filters allow you to hide or display tables based on criteria placed on table names, even though users may have permission to access them. This can be quite helpful if your database has internal system tables that you do not want users to see. The table filters option can be accessed from the main MarketWide AdminUtility window, under the server name in the Table Filters folder. You can assign filters on a global, database or owner level.
Note
- You can enter wild cards in any of the following fields: 'Database', 'Owner', and 'Table'. The wildcard sign (%) is used to indicate a string of one or more characters.
- You can enter multiple Includes. For example, to display tables belonging to owners Joe and Bob, enter two filters, one with Owner set to Joe and the other with Owner set to Bob. Set filter type to Include on each.
To Add a Table Filter
- Click on the Table Filters (
) icon. - Right click and select Manage Table Filters
- In the Filter Type column, you can opt to use an Include or Exclude for the filter. The include will display the tables that meet your criteria; the exclude will hide tables that meet your criteria.
- Enter filter criteria in the Database, Owner, or Table field. The wildcard sign % is used to indicate a string of one or more characters.
- When you enter filter criteria in the last empty row, a new row is automatically inserted.
- 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.
To Edit a Table Filter
- Click on the Table Filters () icon.
- Highlight the filter you would like to edit.
- Right click and select Manage Table Filters.
- Make your changes.
- Click OK to save your changes.
To Delete a Table Filter
- Click on the Table Filters () icon.
- Highlight the filter you would like to edit.
- Right click and select Manage Table Filters.
- Highlight the filter you would like to delete and click the Delete (
) icon. - Click OK to save your changes.
Field Properties
After adding databases, you can begin to create some of the user-friendly features MarketWide provides for users. You can add properties to fields such as aliases, descriptions, picklists, lookups, print formats, and composite fields. You can also specify whether the field is suitable to group and perform arithmetic on. For example, with these options, you can prevent a user from specifying a date field as a dimension or from trying to calculate a sum or average of account numbers.
To Add or Edit Field Properties
- Click on the All Fields (
) icon... - Right click and select Manage All Fields.
- Type an alias next to the field in the Alias column if you would like this name displayed to users rather than the actual field name.
- Add a description of the field in the Description column.
- To assign a picklist to a field, click in the Picklist column next to the field and use the drop-down list to select a picklist.
- To assign a lookup to a field, click in the Lookup column next to the field and use the drop-down list to select a lookup.
- To add a print format, type an entry in the Format column.
- If you wish to make a field unavailable for use as dimensions and/or arithmetic functions, uncheck the box in the Dimensions and/or Arithmetic columns next to the field to deselect them.
- Click the checkbox in the Reference column if the field is a reference to a file outside of MarketWide.
- Click the checkbox in the Composite column if the field will be parsed for data when creating a solicit file.
- Click OK to save changes and exit the dialog.
Note
- You can print fields and their properties, or copy and paste values from another location (such as Excel).
- Marking a field as read only is valid only when you also assign a picklist or lookup to that field.