Final Configuration

Update Profile Tables

We have created a DASH profile that will be used in the DEMO dashboard page included with the installation. We have included the SQL script Update_Profile.sql in the DASHv2.0 folder. Use the MySQL Administration application to restore this file into the J2 schema. If you created the jetspeed schema in Data Base Preparation with a name other than J2 - the script will need to be modified. If you are using a different database other than mysql - the script will need to be modified as well.

Startup DASH

Startup DASH with the script for your platform as noted in Startup DASH and Deploy WARs

Login as Admin

Access your DASH installation by entering the following address in your browser:

http://localhost:8080/jetspeed - this assumes that you are accessing on your machine - otherwise change localhost to a server name or ip address.

The new Login page is displayed:



Login as admin with your new password.

Enter License Key and Verify Default Database Settings

MARVELit should have sent you an email with a license key. If you want to use DASH for a trial period, the key will allow dash to be used for 30 days. If you have purchased a lcense, your key will never expire.

The process to enter your key is the same - after logging in as an admin - select Jetspeed Administration Portlets and pull down to MARVELit Admin

Selecting MARVELit Administration displays a page for entering the MARVELit License Key, setting the default data source, setting data maps and adding/updating data sources. See Administration Portlets for more information on the Administrative portlets.

The first entry is for entering the MARVELit License key. Copy and paste the key that you received during the trial or purchase registration process. DASH will not operate without a valid License Key entered into this field.

Under the License Key are the database connectivity settings for the DASH database. In a previous step you restored 13 DASH tables onto a mysql database. See Build Dash Tables

The default DASH connection is displayed: marvelit database on mysql on the localhost machine with user and password of marvelit. If you restored to another location or used a different database or names - set your values here.

After pasting in the key and verifying the default DASH database connection - scroll down several pages - pass the data map section and click the Save Properties button.

Set up Welcome Page Portlets

After saving your License key - click Welcome and the Welcome page is displayed. This page contains 8 portlets that need to be configured for a Welcome demo dashboard. This is good practice on using the DASH meter, chart and report portlets.

Here is part of the page that is displayed :

Starting with the top row - moving left to right - Configure each portlet as follows:

Portlet 1 - Meter - Select Demo as Datasource, Select Welcome1 as Saved Query - the query loads in the portlet - click Display Details - Below. Click SAVE. The meter displays.
Portlet 2 - Chart - Select Demo as Datasource, Select Welcome2 as Saved Query - the query loads in the portlet - click Display Details - Below. Click SAVE. The chart displays.
Portlet 3 - Chart - Select Demo as Datasource, Select Welcome3 as Saved Query - the query loads in the portlet - click Display Details - Below. Click SAVE. The chart displays.

Middle row - moving left to right - Configure each portlet as follows:

Portlet 4 - Chart - Select Demo as Datasource, Select Welcome4 as Saved Query - the query loads in the portlet. Click SAVE. The chart displays.
Portlet 5 - Chart - Select Demo as Datasource, Select Welcome5 as Saved Query - the query loads in the portlet. Click SAVE. The chart displays.
Portlet 6 - Chart - Select Demo as Datasource, Select Welcome6 as Saved Query - the query loads in the portlet. Click SAVE. The chart displays.

Bottom row - moving left to right - Configure each portlet as follows:

Portlet 7 - Chart - Select Demo as Datasource, Select Welcome7 as Saved Query - the query loads in the portlet. Click SAVE. The chart displays.
Portlet 8 - Report - Select Demo as Datasource, Select Welcome8 as Saved Query - the query loads in the portlet. Click SAVE. The report displays.

Here is the Welcome page after it is configured:

You are All Done

That's it. You now have DASH configured and can build your own dashboards. Some things to review on the Welcome pane.

Review each Portlet - click on the pencil icon in the upper right corner of each portlet. Read the sections on Meter, Chart and Report portlets in this wiki.

• Chart Portlets , How to update and save MARVELit Charts

• Report Portlet , How to update and save MARVELit Reports

• Meter Portlet , How to update and save MARVELit Meters (dials)

Review the Levers - Select Jetspeed Administration Portlets - than DASH Levers Administration - the Levers are displayed. See the Levers sections for further information.

• Levers Portlet , How to add Levers (pull down selections) and have them work on a page

Review the Page Layout - click on the pencil icon in the upper right corner of the Welcome page. See the Page Layout sections for further information.

• Formating Panes , Adding Columns and Rows to existing Dashboard Panes

What's Next

You now can build your own DASHBOARDS. Review the following secitons of this wiki to help you get started.

• Administration Portlets , Adding Data Sources - Set up your own data sources

• Adding Panes , How to add or modify dashboard panes in the portal
• Formating Panes , Adding Columns and Rows to existing Dashboard Panes
• Adding Portlets to a Pane , Adding MARVELit portlets to panes to create dashbboards

• Chart Portlet , How to update and save MARVELit Charts
• Report Portlet , How to update and save MARVELit Reports
• Meter Portlet , How to update and save MARVELit Meters (dials)
• Levers Portlet , How to add Levers (pull down selections) and have them work on a page
• Portlet Variables , How to use Variables in Portlet configurations
• Format Portlets using XML , How to use XML tags to create custom colors, fonts, and threshholds

There are also some flash movie files on our web site at movies.html that provide a good overview.