In this tutorial, we’ll walk through the step-by-step process of creating a hyperlink from a database in Sage Enterprise Intelligence (SEI).

Steps:

1. Prepare the URL Link in Your Database Tables:

Ensure that your database tables contain the necessary URL links that you want to use as hyperlinks.

Fig. 1.Database Tables

2. Create a Data Model:

Open the “Data Models and Views” tab.

Right-click and select “New Data Model” to create a new data model.

In the Data Model Designer, set up the “Format” field

Under the “Categories” section, select “Hyperlink.”

Click “OK.”

Fig. 2. Set Hyperlink

3. Save the Data Model:

In the upper left-hand corner, click “File” and select “Save Data Model.

4. Create a New View:

Go back to the “Data Models and Views” tab.

Create a new view based on the data model where you set up the “Format” field.

Choose the “Worksheet” option.

5. Add Hyperlink (URL) Fields:

In the worksheet grid, add the relevant hyperlink fields.

When users click the link, a new window will open to display the URL in a browser.

Fig. 3. Add Hyperlink

In this blog post, we explored the process of creating hyperlinks from a database in Sage Enterprise Intelligence (SEI). By following these steps, you can enhance your reports and dashboards with clickable links to external resources.