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.

ENHANCEMENT: Excel Tabbed Worksheets

Excel tabbed worksheets can now be created via the "Create a Report" option on the DART BOARD by selecting your Output format to be Excel and by checking the Page Break/Excel Wksheet option below Field (1) as shown below. Note: your selection for Field (1) will be used to separate each worksheet.

Create a Report Selection (click on image for larger picture):

Excel Result:

ENHANCEMENT: Future term Academic Study records now available

As requested from the COB, the Academic Study templates now contains future term records. Please note that these future term records will contain active as well as inactive students. Therefore you should expect to receive many more records (unless you apply your filters effectively) for these future academic period terms.

FIXED: Issue with inability to click to drilldown on Statistics

The inability to click usually on a count in order to drilldown from the Statistics output has now been corrected. The cause was a 2,000 character limitation on the number of parameters to be passed through a web browser. The Statistics program now minimizes the number of parameters being passed.

DART BOARD Training Videos

Click on the topics below to view videos.


Learn how to activate your DART BOARD account, login and navigate to Reporting Templates and security requirements. (13:28)


Learn how to access report information by activating filters and organizing information by dimensions on the DART BOARD. (30:49)


Learn standard drilldown options: Show Me all the data, Create A Report, Create My LISTs and optional Custom Reports. (18:42)


Learn how to apply My LISTs to produce Labels and utilize My Lists as an additional filter on other Reporting Templates. (18:29)

Why can't I see a report template?

The templates you see on DART BOARD is based upon your banner security access. If you do not see a report on the menu it is because your banner security access has limited it from you. You can go to the DART BOARD Welcome page and on the right hand side, run the report, What is on the DART BOARD? This report will show you all the available templates by application and business concept along with the banner security access required. You will then need to contact a Banner Security Officer, (i.e. not Carol Sashi) to grant you this access.

New Enhancement: Additional Filters

One of the limitations of the DARTBOARD was the fixed number of 7 filters that can be used on a template. In order to alleviate this, the "Freeform Filter In Parens" box was created so that users could type in their own filter. Now, there is an additional capability of a new box named "Additional Filters" which can be created with a dropdown list of predefined filters to select. Furthermore, it is also possible to multi-select these values for applying multiple filters to your query. The below query will select all currently enrolled freshman who are degree seeking and registered in the College of Business:

















As on all DARTBOARD reports, the filters applied will be documented:

Academic Study Primary with GPA (ODS PROD) Enhancements

Unduplicated Head Count has been added as an additional measure for Statistics. This provides you with the headcount for a grouping. (EQ requested)

ODS Student Load corrects the name for the College of Business

In order to correct all records in the ODS database to the name, “College of Business” which was formerly named “Barry Kaye Col of Business”, a full student ODS load was run this past weekend. The student load completed on Sunday evening and the refresh was run bringing up all ODS records current.

Summary of enhancements applied for Advisors

Based upon input from Advisors, the following templates have been enhanced as follows:

Schedule Offering (ODS PROD)
· New Drilldown report, Schedule Offering with Instructor’s WK Address

Academic Study Primary with GPA (ODS PROD)

· Drilldown report, Student Data with email, lo-pr address and telephone will show the student’s age (not date of birth).
· Additional Across Column named “New Student Ind”
. When selecting a GPA Type and Range and a student does not have a GPA, the student was being dropped from the report. Now, the student will be included on the report and will show a blank GPA. - enhanced on 9/16/2009


In addition, to correct the name of the College of Business formerly named Barry Kaye Col of Business, a planned reload of the ODS Student database is scheduled to occur over the weekend of September 19, 2009.

Please review these enhancements and let me know if you have any difficulty accessing your reports.

New Drilldown option on Academic Study Primary with GPA (ODS PROD)

A new drilldown option on the 'Academic Study Primary with GPA (ODS PROD)' template named 'Student Detail with email, lo-pr address, and telephone' is now available.

This will allow you to select the desired student population and generate a file in excel format which will include the student's preferred email address, an address (using local over permanent), and the local telephone.

Using the available dropdown on the launch page under the title will allow you to use a shortcut to generate this report with one-click.

STUDENT_CLASSIFICATION added to Student Course Schedule Study (ODS PROD)

STUDENT_CLASSIFICATION has been included as the last field under “Show Me All the Data” and “Create a Report” options.

Please note that because this column is located in a different view from the student_course view that access time has increased which will increase the wait time for the information to be returned to you. Let me know how this template performs and if it becomes a problem.

New Enhancement: Shortcut to Reports

The BITS Office is pleased to announce the additional DARTBOARD capability to run reports directly from the launch page. Reports such as "Show Me All the Data", "Create A Report", and all Custom Reports can now be pulled down directly under the Report title.

"Statistics" will remain the default and is the recommended report to run when you are unsure of the volume of records. Drilldown capabilities from the Statistics report will allow you to continue accessing the other reports.

This new enhancment will be applied to existing templates over the next two weeks.

New DART: Student GPA Analyzer

Do you need to know a Student GPA?

Do you need an overall GPA or a GPA for an academic period?

Do you need an Institutional (FAU), Transfer, or Overall GPA?

All these answers are available on the new DART: Student GPA Analyzer located under the Student tab, in the Business Concept, Student Detail to users with access to SHAINST.

Simply enter an ID, Name or use a MyLIST for the filter to begin.

Run the Statistics with Sorting on "ID" and "Academic Study Value" and Across Column "GPA Type" filtering on GPA Grouping, "Cumulative Values" to generate a report with GPAs and ID on one detail line.

Welcome to the DART BOARD Blog

DARTBOARD users may choose to:

1. Sign up to follow this blog and be notified of updates by clicking on "FOLLOW BLOG" at the top of this page.
2. Respond by selecting their reaction to a posting (this will be used to vote on future decisions).
3. Enter comments to a posting.
4. Subscribe to the feed for automatic downloads to the user's computer.