Oracle Demantra Implementation Guide Supplement

Display Series as a Link

You can create a series that displays its value as a hyperlink. This allows you to call your own external pages or documents that may provide information associated with the particular series. See Creating a Series that Appears as a Link in the Oracle Demantra Implementation Guide.

Creating a Series that Displays as a Link

You can create a series that displays its value as a hyperlink.

Enter the URL in a database column, for example using Oracle SQL Developer. You can either create a new column or insert the URL into an existing column. The column should be of Type VARCHAR2 (i.e., string or text) and be long enough to store the full value.

For example:
- Table = SETTLEMENT
- Column = 'Link to Document'
- URL = '[http://www.oracle.com/|]'
The URL must be in the format: [DisplayText|URL|] where URL is required and DisplayText is optional.

The value must start with a '[' (square bracket) and end with a '|]' (pipe character followed by square bracket). Also, if DisplayText is included, then a '|'‘ (pipe character) must separate the DisplayText from the URL.

Example: To display "Oracle" as the Series value in a worksheet and launch http://www.oracle.com/ when the end user clicks the link, the URL should be:

[Oracle|http://www.oracle.com/|]

To display the URL as the series value, then omit DisplayText. For example:

[http://www.oracle.com/|]

If the value does not conform to the required format of [DisplayText|URL] then the Series value will be displayed as normal text (no hyperlink).
Create a new series. The settings that are required for a series value to appear as a link are described below. For details about all other settings, see "Creating a Series" in the Oracle Demantra Implementation Guide.
- In the Display Properties screen, set Display Format to 'Hyperlink'.
- In the Data Properties screen:
  - Set Data Table to the table where you defined the URL in step 1. (Do not specify an 'Update Field'.)
  - Set Data Type to 'String'.
  - Set Aggregation Function to 'Max'
  - In the Expression Properties screen, define the series' Server Expression. Below are two examples of how to do this:
a. Example where full syntax is stored in database column:

max(nvl(table_name.column_name,' '))

b. Example where the base URL is stored in a database column and full syntax is concatenated in the expression:

max(concat(concat(‘[DisplayText|’,table_name.column_name),'|]'))
Add the new series to a worksheet using Worksheet Designer.

Naming Series

Series names are often included in client expressions and names that contain special characters may prevent the expression from functioning as intended. Forbidden characters within series names are:

Configuring Series

Display Series as a Link

Creating a Series that Displays as a Link

Naming Series