SnapShot

Overview of SnapShot

Imagine you could take a picture of every data point in your database just before you roll into the next business day –  A snapshot in time to preserve a copy of how yesterday ended. What would you do with it that picture?

SnapShot is a new environment in CU*BASE which stores a rolling copy of the complete FILExx processing data at every end-of-day (EOD). As an Asterisk Intelligence initiative, SnapShot (FILExxSS) was built with enhanced support for custom data transfers in mind, but we recognize that database managers and data analysts will want access to see and use the data on their own for research and reporting.

Data Silos Yourdata Analytics and Warehousing

High Level – What Does It Do?

Snapshot Processing Window

Standardizes time-of-capture for data sets which need to be consistent and static for further use. This is valuable especially for 3rd party vendor data transfers, custom query reports, and other external software using CU*BASE data (Analytics Booth!). SnapShot data is captured at the same time every day, for all credit unions.

Enhances back-end operations for data transfer products. SnapShot is available outside of the standard End-of-Day/Beginning-of-Day (EOD/BOD) processing window with blows wide open the available time to send data to your vendors or your external data warehouses. Now, data transfers have a 20-hour window, increased from 5 hours.

For you – a FREE copy of yesterday’s backup to query and research. Did you know we make backups of your member and transaction processing data (FILExx) every day? Now you can see and use the most recent backup at any time via Query. The window of availability is short – SnapShot refreshes every night – but some of your departments may find value in comparing today to yesterday, or the ability to research a new time slice of data.

Request Access to Query SnapShot

Asterisk Intelligence logoEvery credit union using the CU*BASE® core automatically has a SnapShot (FILExxSS) environment already. In other words, it’s FREE.

No management or customization required, it’s an instant solution for a static, consistent, copy of processing data as of the last end-of-day processing cycle.

To request access to the data via Query, place an order through Asterisk Intelligence’s Store Page

Order SnapShot Access

AT A GLANCE

FILExx
Live Core Processing
FILExxSS
SnapShot (EOD Copy)
FILExxE
EOM Archive
Purpose daily processing copy of yesterday’s FILExx copy of last month’s FILExx
Timing dynamic static – updates daily static – updates monthly
Retention instant changes 1 day 6 months
Contains all processing tables all processing tables partial set of processing tables
Example Table MASTER MASTER EMSmmyy

Top 5 Reasons to Love Snapshot

  1. Every Piece of Data, Literally!
    No corners are cut here. Every single table, row, and column that you find in the daily processing database has a corresponding record in SnapShot.
  2. Latest Possible Moment
    The picture is developed within normal end-of-day (EOD) processing so you consistently capture the final values for any given day.
  3. New Time Slice for Analysts
    Comparing current day data to yesterday’s data aids in member support research, research of financials, and other queries where timing is important.
  4. Quadrupled Processing Window
    Data transfers to vendors or your own teams can be larger and more flexible as they are moved outside the Operations cycle (a 3-5 hour window) and are now run from the SnapShot data (available 20 hours).
  5. Smoooooth Operating
    Testing of the transition to run vendor data transfers off SnapShot has been seamless and many custom data transfers already use it! Development continues to identify and prepare additional custom programs to utilize SnapShot.

One of the Family

SnapShot is native to CU*BASE® and becomes the third operational* warehouse of data in CU*BASE:

  • FILExx (core production for transaction processing)
  • FILExxE (selective set of 6 end-of-month records)
  • FILExxSS (rolling copy of FILExx at last end-of-day)

Live data, End-of-Month data, and now End-of-Day data – This new time-slice fills the need for consistent daily data capture for analysts and database administrators.

*an operational warehouse is one which supports the core system processing functions.

Learn More – Resources

Download a copy of the SnapShot overview to print or share:

Snapshot Overview

Read more technical details about how SnapShot fits into the family of data warehouses for both processing and analytics, plus some of the technical details related to timing and management of SnapShot:

Data Warehouses Booklet

Read more about how to access SnapShot (FILExxSS) data via the Report Builder (Query) tool in CU*BASE. Remember, this means you must be authorized to access to the tool. If you don’t have tool authority for Report Builder (Query), contact your internal Security Officer to request it:

How To Query SnapShot

If you manage your own analytics Data Warehouse – you may also be interested in our Custom DEX packages. DEX – Data EXchange, and the packages include copies of the most popular CU*BASE data transferred to you daily for use in your external Data Warehouse.

Standard DEX Package

Custom DEX Package

Updated
May 2, 2018

Jump into a Dashboard Dive: Analyzing Fee Income, Refunds and Waivers

Jump into a Dashboard Dive: Analyzing Fee Income, Refunds and Waivers

Join the Asterisk Intelligence Team for a Dashboard Dive! Join the Asterisk Intelligence team as they review the CU*BASE Fee Income, Refunds, and Waiver dashboards.  Learn how to utilize these dashboards to analyze and understand your fee income like never before!  Use these tools to compare your total potential fee income versus your collected fee… Read more »

May 23, 2019

The AB 19.06 Analytics Booth Release is Coming!

The AB 19.06 Analytics Booth Release is Coming!

The Asterisk Intelligence Team is excited to present the AB 19.06 Analytics Booth Release, arriving to Analytics Booth subscribers on Sunday, June 9!  This release features the NEW Static Pool Analysis Dashboard, Learn-From-Peer Trend line graphing, additional Power Lines, and more.  Check it out! View the Release Summary Learn More About the Analytics Booth Release… Read more »

May 22, 2019

Don’t Miss This Week’s Dashboard Dive: Why Your Members Call

Don’t Miss This Week’s Dashboard Dive: Why Your Members Call

Join the Asterisk Intelligence Team for a Dashboard Dive! Join the Asterisk Intelligence team as they review the tool #1315, the ‘Why Your Members Call’ Dashboard.  Learn how this dashboard can be used to analyze your call center activity and provide greater visibility into your call center Wrap-up Codes.  Quickly review call volume per day,… Read more »

May 20, 2019

Jump into a Dashboard Dive: Why Your Members Call

Jump into a Dashboard Dive: Why Your Members Call

Join the Asterisk Intelligence Team for a Dashboard Dive! Join the Asterisk Intelligence team as they review the tool #1315, the ‘Why Your Members Call’ Dashboard.  Learn how this dashboard can be used to analyze your call center activity and provide greater visibility into your call center Wrap-up Codes.  Quickly review call volume per day,… Read more »

May 15, 2019

How are You Utilizing the New Web Dashboards and Powerlines?

How are You Utilizing the New Web Dashboards and Powerlines?

Earlier this year, the 19.02 Release of Analytics Booth debuted the first web integration between CU*BASE and Analytics Booth via Powerlines and Web Version features.  This Analytics Booth release also saw the introduction of the first web dashboard to contain private data. How has your credit union been utilizing these features?  If you have ideas… Read more »

May 8, 2019

Order Your Lending Scorecard Today!

Order Your Lending Scorecard Today!

Enhance your periodic reporting packets with a Lending Scorecard, brought to you by the Asterisk Intelligence team!  Gain insights into portfolio balances, product participation, credit history, membership demographics, and more – all in a single report!  Reports can be produced using end-of-month data for monthly reporting, or produced mid-month using current membership data. Ready to… Read more »

May 7, 2019

Don’t Miss This Week’s Dashboard Dive: Written-Off/Charged-Off Loan History Dashboard

Don’t Miss This Week’s Dashboard Dive: Written-Off/Charged-Off Loan History Dashboard

Join the Asterisk Intelligence Team for a Dashboard Dive! Join the Asterisk Intelligence team as they review tool #476, the Written-Off/Charged-Off Loan History Dashboard.  Do you have a firm handle on your historical loan losses?  Do you know how your 2019 year- to-date charged off loans are trending versus 2018?  Analyzing your historical loan losses… Read more »

May 6, 2019

Jump into a Dashboard Dive: Written-Off/Charged-Off Loan History Dashboard

Jump into a Dashboard Dive: Written-Off/Charged-Off Loan History Dashboard

Join the Asterisk Intelligence Team for a Dashboard Dive! Join the Asterisk Intelligence team as they review tool #476, the Written-Off/Charged-Off Loan History Dashboard.  Do you have a firm handle on your historical loan losses?  Do you know how your 2019 year- to-date charged off loans are trending versus 2018?  Analyzing your historical loan losses… Read more »

May 2, 2019

Order a Data Warehouse for Custom Data Storage in the Core

Order a Data Warehouse for Custom Data Storage in the Core

The Data Warehouse, available from Asterisk Intelligence, is designed to support the storage and analysis of data from multiple sources from alongside your core processing data.  The space gives you a solution to manage custom and special data sets in CU*BASE. Click below to purchase your Data Warehouse: Visit the Store Today Asterisk Intelligence is… Read more »

Apr 29, 2019

Join Us for Asterisk Intelligence Week!

Join Us for Asterisk Intelligence Week!

Join the Asterisk Intelligence team for a week of in-person educational events, May 13-16 in Grand Rapids, MI!  These events are designed for credit union management, marketing staff, and database administrators. We are excited for the high level of interest in our on-site query courses.  Attendance is almost full for our May session, but we… Read more »

Apr 29, 2019