New Training Videos Released!

April 24th, 2017

If you’re on your way to upgrading to the very cool 4.3.15 release or higher, you need to check out the new Admin video series that covers the new features including the FAST Table Builder that shows you how to create a quick and easy Oracle Table in FAST. You can create a table using a simple Excel upload or make one from scratch! You can then use that Table to create a multi-faceted data entry page right in your favourite FAST application! Capture data right in FAST and you manage who sees the page as a read-only report and who has data entry access to it.

If you don’t yet subscribe to the FAST training video libraries, what are you waiting for? Email us at training@mcsl.com to get started or for more info! We add tons of new video content all the time and it’s your best way to stay current on what’s new!

As a sneak peak – check out this brand new How Do I video on managing security for your new custom reporting pages!

Ever tried to Cross-Tab your Report Results?

April 7th, 2017

If you’re not sure what I’m talking about, I’ll take it as a “no”. If you’ve ever used a Pivot Table, this will be really fun for you! This is a great reporting feature that allows you to change the look and feel of your report results. It allows you to take the data from any column and flip it around to become your column header!

You can then select what you’d like to use to populate the data in the report and how you’d like it to display – Average? Sum? Count? Really depends on what sort of data you’re collecting today. You can even customize the formatting of your new column data to include specific numbers, currency, percentages and rounded to the number of decimals you want to see!

Finally, you can add back in up to three more columns from your original report to display back in your new, modified dataset!

You can then save your report data as a Pinned Report to keep your formatting in place for next time, and you can even enable it as a “Grid” to access directly from any of your personalized or executive-level dashboards!

 

 

 

Importing FROM Excel… you heard me.

March 22nd, 2017

Do you use one of the many FAST data-entry style pages? If you do, did you know that you can now import your data directly from an Excel spreadsheet? True story. You’ve always been able to download your FAST report data to Excel but you can now also save time, keystrokes and avoid input error by importing your external data right into your FAST data entry page!

Next time you’re on a data entry page, check out the Excel icon on the bottom right hand corner; it looks a little different now, right?

Click the arrow and select “Import Data from Excel”. Follow the simple instructions and watch your data populate right before your very eyes! The cool thing is, that you can also combine manually keyed-in data with your spreadsheet uploads – one will never over-write the other!

Save time, save effort and above all, reduce the risk associated with manual data entry!

Cool Feature Alert!

March 1st, 2017

Visualizations…I have a feeling you haven’t tried them yet, but they’re awesome now so it’s time!

Let’s say you have a report that gives you a ton of really valuable info…but I know sometimes you might wish that you could display some of that great data visually instead of just a bunch of data. A picture paints a thousand words, after all, right?

Here’s how it works:

Let’s say you have a column where you are tracking Budget Variance information… if that Budget Variance is favourable (like really favourable!), maybe you want to display the number with a nice big happy face! Now if it’s favourable but starting to slide a little, maybe you want to display that variance data with a caution sign. And of course if that variance has slid past the point of where you’re comfortable, maybe you want FAST to show you that data as a big, red “thumbs down”….you choose the parameters and you choose from our huge library of cool and cheeky images!

Run the report and then get visual indicators about where that budget really is! Plus, this works in any and every FAST App! Create cool Visualizations for age grouping of employees, application status or course enrolment numbers – the sky’s truly the limit!

PS – don’t forget to add a Virtual Column so that you can see both the original data and the Visualizations side by side!

Ensuring Supporting Documents are Confidential!

February 9th, 2017

For those of you using FAST JV, Web Req and/or Budget Transfers, there is an important, but often overlooked feature that allows you to ensure that any supporting documents you upload remain Confidential! In other words, they won’t be shared with other systems or flow through to the documents page in FAST Finance Reporting! Confidentiality is a big deal – make sure you know exactly what is going to show up and who can see it!

This can be crucial if those documents are sensitive in any way! You can opt to make all document uploads confidential or just pick and choose depending on the type of document being included.

As an Administrator, you can also pre-define the default for your Application by setting Configuration Setting #1338. End users can still override this setting by selecting (or de-selecting) the indicator.

Schedule it and leave the rest to FAST!

January 30th, 2017

We know you love your Pinned Reports….who doesn’t? But are you making use of the Report Scheduler yet? Once you create your own Pinned Reports, you can schedule them to deliver, right to your e-mail in-box at any interval you decide! That means you don’t even have to remember to “run” that report to get your hands on that data when you need it.

Here’s the skinny on how it works:

  1. Save your Pinned Report (as private)
  2. Click “Schedule”
  3. Choose a delivery schedule!
  4. You can pick everything from:
  • Frequency (Daily? Weekly? Twice a week? Monthly? Quarterly?)
  • Time of day
  • Duration (A couple weeks? A couple months? Till the end of the year? Forever and beyond?)
  • The format – choose from PDF, Excel or CSV
  • Hit GO and leave the rest to us

Nothing could be simpler! When you’re done, click on your “My Schedule” Tab to check out your delivery schedule at-a-glance and then just sit back and wait for those reports to start rolling in.

The rumours are true…. Virtual Columns are now available!

January 16th, 2017

You can now create “virtual” columns at either the individual level or even at a global level for all end users of the report! This gives you the amazing ability to add one or more NEW columns to your report results! Just think of the possibilities:

  • Concatenate two or more columns in the report quickly into ONE
  • Create a formula based on existing column data…something like:
    • Column C \ Column F – Column B = BRAND NEW USEFUL COLUMN X
  • Duplicate an existing column to display it a second time and/or use Virtualizations to render it as a visual icon or image

The possibilities are endless and the power is amazing! Customize your report, YOUR way.

Here’s a quick run-down (but be sure to check out the detailed training videos for a way more thorough explanation!):

  1. Make sure you are running 4.3.06 or higher – if you’re not, what are you waiting for?
  2. Run your report
  3. Click the GEAR button on the top left hand corner of your report:

  1. Click + to add a new column
  2. Fill in the Virtual Column worksheet to define the parameters of your new column including title, width, format, and of course the formula. The formula is the trickiest part, so be sure to ask for help if you need it!
  3. Click SAVE and the report will re-execute with your new Virtual Column right where you want it!

Best part is, you can still use any of the Advanced Options, Grouping features, Pinned Reports, Graphing and more to refine, aggregate or modify your new report data!

Don’t like one of the titles of a report column or don’t think it quite captures the information correctly?

January 3rd, 2017
How about changing it?

If you are an application administrator, did you know that you can do this yourself  and on a global level? Here’s how:

  1. Locate the Report and find the Administration Tab (note: this is probably under your + More tab)
  2. The first tab, called Datagrid Columns lists all the current columns in this report.
  3. Locate the column title you wish to change; change the text right on this page! – the cell is case sensitive and if you need to make it slightly wider or more narrow, just change the “width” column right next to it!
  4. Click Save and update changes.

Re-run the report – it is now changed for all end users who run this report!

Insights for Registrars and Admissions Officers from PACRAO 2016

November 9th, 2016

Registrars and admissions officers gathered last week at the annual PACRAO conference in Las Vegas, NV and we were fortunate to be able to deliver a presentation around using technology to better report, forecast, and analyze admissions and enrollment numbers.

You can download the presentation here.

While we were there, we picked up on some major themes that we thought would be valuable to share:

 1. The need for a single “system of record” for admissions and enrollment numbers

There was quite a bit of discussion about not only consolidating data from multiple sources so that there was a single set of information but how to share and collaborate around that data.  Our FAST reporting and analytics software provides the single view into the data as well as makes it easy to share on a scheduled basis.

2. Think about competencies and skills vs. job titles when building your organization

Rather than staffing for a role or job description, think about the skills and competencies needed to perform the job well as a starting point. Once defined, then seek out candidates with those skills or develop put a plan in place to develop them in existing staff members.

3. Systems should support workflow

Take a look at how you are doing your work and where current systems are creating extra steps or inefficiencies.  Rather than focus on data entry, spend time looking into what the data tells you – trends, comparisons, and insights.  Our FAST reporting and analytics software enables this by accessing existing data in your administrative system and providing pre-configured views so you can “look beyond the numbers.”

Class Lists and Grading, Simplified!

October 26th, 2016

To learn more about Millennium’s FAST reporting and analytics software, click here to schedule a personalized demonstration.