Min/Max Profiler
Use this topic for a simple page, dialog or other UI without any sections or tabs. You must describe every field and option on the page.
To configure this topic so it generates correctly in the help output, perform the following steps:
-
Configure the
Sect1
element:-
Create the context-sensitive topic as a
Sect1
. -
Title the context-sensitive topic to reflect the name of the UI, using a simple noun phrase with headline-style capping. In the page title, include the generic noun. For example, Preferences Page, Preferences Dialog, Editing Window, Resource Catalog. If this is a topic that you are migrating, use the same title as before..
-
Set the
HelpTOC
attribute toTopicOnly
, so this topic does not appear in the TOC. -
Modify the sample
OutputFileName
attribute of the element to include the name of your UI and optionally include the product name. For example, if your product is Oracle XYZ Server and the UI is the Preferences Dialog, modify the value of this attribute fromcs_pagename1.htm
to something likecs_preferences.htm
orxyz_cs_preferences.htm
. -
Modify the
HelpTopicID
attribute to match the topicID for the Help icon, button, or UI.Use the topicID provided by the engineer as the value for the
HelpTopicID
attribute for theSect1
topic. If converting help from another format, use the existing HelpTopicID. Alternatively, you can assign a topicID to the topic and then provide the engineer with the topicID you assigned. The important thing is to make sure the topicID you assign to the topic in FrameMaker matches the topicID assigned to the UI, Help icon or button by development.
-
-
Configure the
InformalTable
element with the following guidelines:-
Modify the
Summary
andTitle
attributes as appropriate for the table. -
In the Element column, enter all the elements or options in the UI that should be documented, using the
HelpPara
element. In the Element column, do not bold the UI element. -
To indent the text in the Element column in order to groups the elements as they display in the UI, edit the
Role
attribute of theHelpPara
element. Select Level1 to indent the text from the left margin. You can indent up to four levels to reflect the organization of options displayed in the UI, if needed, using Level1, Level2, Level3, and Level4. -
In the Description column, use the
Para
element, not theHelpPara
element. You will not indent text in this column. Describe the option or element in detail. If you reference UI elements other than the one you are describing, use the Bold emphasis. If you provide a code snippet or code reference, apply the Code emphasis. -
In the Description column, include More inline links to conceptual topics in administrator, developer and user guides in the documentation library; include How? inline links to individual task topics in these books. Do not include inline links for other information. Instead, include those other links under the Related Topics heading, as described below.
-
To insert More and How? link to books, use the Xulink element and for the Attribute value, enter olink:DOCID (for example, olink:ASADM11113). For more detailed information about linking, see the topic Applying TopicID Values and Adding Links to Books in the online help standards.
-
In both the Element and Description columns, add inline graphics where necessary, as described below. Use inline graphics sparingly, only as needed, to provide UI overviews and define unlabeled elements on screen. Icons and buttons are not required in context sensitive online help.
-
Inline graphics are limited to a height of 22 pixels. If you insert an image that exceeds 22 pixels in height, the image will be reduced and distorted in the OHW/OHJ help JAR, so do not insert it. There are no specific restrictions to the pixel width of an image, however images that fill more than half a column would be better inserted as informal figures in the introductory paragraphs.
-
-
To insert an inline graphic, follow these guidelines:
-
Select the location where you want to insert the inline graphic.
-
In the Elements window, select InlineGraphic, and click Insert. The Attributes for New Element window appears.
-
Type the AltText value. This is a required attribute and the book will fail if you do not enter some text. Click Insert Element. The Import dialog appears.
-
Select the graphic to be imported from the graphics folder. The Import Graphic Scaling dialog appears.
-
Select 72 dpi. Click Set. The graphic is inserted.
-
Using the spacebar, insert one space before or after the graphic as needed, so there is a single space between the image and text A single space is required between an image and text before or after it (identical to the space between words). No extra space should be added before an image at the beginning of a line.
-
-
To include the
RelatedTopics
element and links, follow these guidelines:-
The RelatedTopics element is the last element in a Sect1 element and is mandatory. It is included in the template and does not need to be inserted.
-
The only child element available under the RelatedTopics element is the Para element. You can add multiple Para elements under the RelatedTopics element, in addition to those already in the template.
-
Add any topics about technologies mentioned, if they are not covered by inline How? and More links.
-
Add additional cross references to chapters or Sect1s in the documentation library.
-
To insert link to books, use the Xulink element and for the Attribute value, enter olink:DOCID (for example, olink:ASADM11113). For more detailed information about linking, see the topic Applying TopicID Values and Adding Links to Books in the online help standards.
-
The Max/Min Profiler examines the extremes of the data in each attribute, and returns:
-
The shortest value
-
the longest value
-
the 'lowest' value
-
the 'highest' value
Use the Max/Min Profiler to gain an initial understanding of your data. The Max/Min Profiler gives you a quick overview of whether or not your data conforms to its length and valid value restrictions, and allows you to find 'outliers'; that is, values that are clearly out of range, such as number amounts that are larger or smaller than expected, date values that are earlier or later than expected, or text values that consist only of invalid characters such as '#', or of data cheats such as 'aaa' or 'zzz'.
The following table describes the configuration options:
Configuration | Description |
---|---|
Inputs |
Specify any attributes in which you want to find Data Maxima and Minima. |
Options |
None. |
Outputs |
Describes any data attribute or flag attribute outputs. |
Data Attributes |
None. |
Flags |
The following flag is output:
|
The Max/Min Profiler requires a batch of records to produce useful statistics. It must therefore run to completion before its results are available, and is not suitable for a process that requires a real time response.
When executed against a batch of transactions from a real time data source, it will finish its processing when the commit point (transaction or time limit) configured on the Read Processor is reached.
The following table describes the statistics produced by the profiler for each attribute.
Statistic | Description |
---|---|
Minimum Length |
The number of characters of the shortest value in the attribute, in number of characters. |
Maximum Length |
The number of characters of the longest value in the attribute, in number of characters. |
Minimum Value |
The 'lowest' value in the attribute. For Number attributes, this is the lowest numeric value. For Date attributes, this is the earliest date. For Text attributes, this is the first value alphabetically. Note that Null values are ignored in this analysis, but other types of No Data (for example, values consisting only of spaces) are not. |
Maximum Value |
The 'highest' value in the attribute. For Number attributes, this is the highest numeric value. For Date attributes, this is the latest date. For Text attributes, this is the last value alphabetically. Note that Null values are ignored in this analysis, but other types of No Data (for example, values consisting only of spaces) are not. |
Clicking on the Additional Information button shows the number and percentage of records with the minimum length, maximum length, minimum value and maximum value, alongside the above statistics.
Example
In this example, the Max/Min Profiler examines all attributes in a table of Customer records:
Table 1-122 Max/Min Profiler
Input Field | Total number | Minimum Length | Maximum Length | Minimum Value | Maximum Value |
---|---|---|---|---|---|
CU_NO |
2010 |
2 |
6 |
10 |
875825 |
CU_ACCOUNT |
2010 |
7 |
12 |
00-0-XX |
OO-24282-LR |
TITLE |
2010 |
1 |
12 |
1 |
The Reverend |
NAME |
2010 |
4 |
29 |
# ADAMS |
aaaaaaaaa |
GENDER |
2010 |
1 |
1 |
1 |
M |
BUSINESS |
2010 |
2 |
41 |
Stoke Newington Town Hall |
e-sites.co.uk |
ADDRESS1 |
2010 |
1 |
50 |
(Brassfounders) LD, Coursington Road |
kjhkg |
ADDRESS2 |
2010 |
1 |
31 |
WARRINGTON |
jhgfhj |
ADDRESS3 |
2010 |
1 |
22 |
Aberdeen |
jhvgj |
POSTCODE |
2010 |
1 |
8 |
1P1 3HS |
gjhgj |
AREA_CODE |
2010 |
1 |
4 |
0 |
2920 |
TEL_NO |
2010 |
1 |
7 |
1 |
4227051 |
|
2010 |
1 |
50 |
5 |
zoe.peckham@btopenworld.com |
ACC_MGR |
2010 |
2 |
3 |
22 |
WH |
DT_PURCHASED |
2010 |
5 |
10 |
01/01/1995 |
Brian |
DT_ACC_OPEN |
2010 |
5 |
10 |
01/01/1995 |
Brian |
DT_LAST_PAYMENT |
2010 |
19 |
19 |
01-Jan-1970 00:00:00 |
21-Mar-2004 00:00:00 |
DT_LAST_PO_RAISED |
2010 |
19 |
19 |
01-Jan-1970 00:00:00 |
14-Feb-2004 00:00:00 |
BALANCE |
2010 |
1 |
10 |
-999999 |
410.5 |