New Enhancement: Identify your dups on My Lists

When you Create a My List you may get a message that duplicate keys (IDs) were found.

Now you can identify those duplicate keys when you Create a My List by simply titling the name of your My List with a ' dups' or ' DUPS' (note that there is a single space prior to dups).

For example, when you create a My List and receive notification of duplicates:








Submit it again with ' dups' in the title:








This new My List will contain only those IDs that had duplicate records.

Tip: You can go to Maintain My Lists under the General Utilities tab and utilize the utility to take a list and subtract out matching IDs (Option #2). This will allow you to derive those single (non-duplicated) IDs.

WebFOCUS Upgrade Completed

WebFOCUS was successfully upgraded on Saturday at 4:30 am.

A summary of new features this release (7.6.11) will offer is available at N:\WEBFOCUS\Summary_of_new_Features.pdf.

How current is the ODS data?

The ODS refresh process begins at 6pm nightly.

You can check on its status as well as completion time by running the "When was the ODS last refreshed?" report available on DART BOARD's Welcome tab in the upper right hand corner.

Further details on each process and its completion times are available through drilldowns on the report.

Is DARTBOARD Slow?

Internet Explorer's accumulation of temporary files can slow down your system over time if you do not delete them. It is a good practice to take the time to periodically maintain your system to prevent this from occuring.

You can delete Internet Explorer's temporary files by selecting "Tools", "Internet Options". Under the General Tab select "Delete" in Browser History and then "Delete files..." in Temporary Internet Files.

New Enhancements: Documentation and Limits

As I write this post, most templates are being generated with the following new enhancements:

Documentation is available by clicking on the hand above the submit now icon. This will provide you documentation for the template along with a narrative. Anyone is invited to help assist in this project by sending a description of a template and how they use it by to sashi@fau.edu with a subject line of Narrative.

Users may choose to limit their data if desired. For example, this may be useful when an individual has multiple addresses ordered by sequence number. One may select Sort Descending along with Limit 1 Value on Report to report the latest address.

Please feel free to contact me if you have other ideas for enhancements or questions at ext. 7-3156.

ODS Prod Academic Study Reports

There have been some changes with the new ODS V8 release that went into effect over the holidays. One of the changes affected the Academic Study View. The ACADEMIC_STUDY view was not working like it used to because Sungard has changed it to identify “active” students. However, since FAU’s records do not conform to the Sungard’s “active” records criteria, we were missing many records in this view.

This was not identified and resolved until today.

Please note that because of this, your reports which you generated earlier this week was using a database that held far fewer records than it should have and may not have been accurate.

Please feel free to contact me if you have any questions or concerns regarding the above.

ODS Upgrade from Version 3 to Version 8 Completed

The ODS has been upgraded from Version 3 to Version 8. WebFOCUS and DARTBOARD reports are now accessing this new version.

This new version offers additional reporting views and additional fields added to existing views which can be reviewed under the ODS Metadata tab on DARTBOARD.

Please address any concerns or questions concerning this topic to Carol Sashi (email sashi@fau.edu).

Enhancement: Sub Line Counters on Create a Report

It was suggested in today's DARTBOARD class that a new feature be added to the "Create a Report" drilldown option. In addition to the option of invoking a Line Counter to be prefixed for each detail line, it is now possible to have a running counter on any field that requests to have a Subtotal, Page Break, Underline, or Skip Line. You must first check "Line Cnt" in order to activate this new feature. Below is a sample from the Academic Study template:

Select Line Cnt and Subtotal:

Results:

The BITS Office wants to help you achieve your reporting goals

Over the past year, numerous reporting templates have been developed and they may be just the ones you need to access to see your data. See the "What is on the DARTBOARD" report for a detailed listing of available reports you can run today. Access to all reporting templates is dependent upon your Banner security access.

Classes are offered periodically throughout the year. Please contact the BITS Office to find out how to get started or for advanced DART BOARD users, you may want to request a meeting to build a new (or modify an existing) report template.

Contact Carol Sashi at sashi@fau.edu.

A Drop in the Bucket

Please note that the BITS "Bucket" Newsletter has been replaced with this DARTBOARD Blog. Being able to interact and post current events and activities has been more effective. Therefore the Bucket has been dropped.