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


Live Core Processing
SnapShot (EOD Copy)
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

May 2, 2018

Proving Data Strategies: Indirect Dealer Loan Analytics

Proving Data Strategies: Indirect Dealer Loan Analytics

Join the Asterisk Intelligence team for the first installment of Proving Data Strategies, focusing on Indirect Dealer Loan Analytics. Have you been looking for ways to analyze your indirect loan portfolio and dealer relationships?  Which dealers are sending you the most applications?  Which have the highest booked loan to total applications ratio?  Curious about average… Read more »

Apr 23, 2020

CANCELLED: May Asterisk Intelligence Week

CANCELLED: May Asterisk Intelligence Week

After careful discussion between our team members, we have decided to cancel the Asterisk Intelligence Week courses for our May session.  These courses, which were originally scheduled for May 11 – 13, will not be rescheduled for a different date this quarter. However, if you are interested in attending a future Asterisk Intelligence Week series,… Read more »

Apr 17, 2020

Introducing ‘Proving Data Strategies’

Introducing ‘Proving Data Strategies’

If you have enjoyed our Dashboard Dives Webinars in the past, you are not going to want to miss “Proving Data Strategies”, brought to you by Asterisk Intelligence! Proving Data Strategies is a new webinar series designed to relate CU*BASE tools and resources to tasks and challenges faced by credit unions on a daily basis. … Read more »

Apr 15, 2020

NEW Analytics Booth for Board Members Video Series!

NEW Analytics Booth for Board Members Video Series!

Credit Union Board Members: Uncover the treasure trove of information on the credit union you serve as a board member! Find out how with the new video series: Analytics Booth for Board Members Watch Now Search for this thumbnail: Not sure if your credit union subscribes to Analytics Booth?  Contact your credit union management team… Read more »

Apr 8, 2020

Operational Trending Wherever You Are!

Operational Trending Wherever You Are!

Remote access to your data and your operations is more important now than ever before. Every day, Analytics Booth is tracking and trending hundreds of data points on your operations, your members, your products and services.  Whether your focus is on portfolio performance, delinquency, electronic services, liquidity or just about anything in between, Analytics Booth… Read more »

Apr 7, 2020

First Asterisk Intelligence Week event of 2020 focuses on data audiences and using data to “Prove It”

Asterisk Intelligence, a data analytics team at CU*Answers, successfully concluded hosting their first 2020 event named Asterisk Intelligence Week, held  in February. The 4-day event is open to users of CU*Answers’ CU*BASE core processing software and was attended by 29 individuals from credit unions across the United States. All sessions were free and included a […]

Mar 16, 2020

Asterisk Intelligence enters its fourth year of providing data consulting and educational services to credit unions

Asterisk Intelligence, a data analytics team at CU*Answers, which provides business intelligence consulting, fulfillment, and educational services to credit unions will complete their third year of operations later this month. The Asterisk Intelligence team specializes in data storage, structure, and retrieval of credit union operational data within CU*BASE as well as business strategies in leveraging […]

Mar 6, 2020

Don’t Forget, the AB_20.02 Analytics Booth Release Arrives February 23!

Don’t Forget, the AB_20.02 Analytics Booth Release Arrives February 23!

New Executive Summary Trends and Alerts, and Updated Graphing Options UI!  The Asterisk Intelligence Team is excited to present the AB_20.02 Analytics Booth Release, arriving to online client Analytics Booth subscribers on Sunday, February 23!  This release features updates to Executive Summary Trends and Alerts, as well as an updated user interface for Graphing Options… Read more »

Feb 17, 2020

Learn All About CU*BASE Report Builder – Join Us on March 4th!

Learn All About CU*BASE Report Builder – Join Us on March 4th!

You can hardly go anywhere today without hearing about database management, warehousing, and mining.  What do these terms mean, and how do credit union employees participate in these new concepts?  CU*BASE Report Builder uses the IBM program called Query, a powerful, flexible tool for mining data from your CU*BASE member data. Join us on Wednesday March… Read more »

Feb 13, 2020

Register for Data Analysis and Query Sessions at CU*Answers

Register for Data Analysis and Query Sessions at CU*Answers

Join the Asterisk Intelligence team later this month for several educational events.  Between Monday, February 24th and Wednesday, February 26th, we will be hosting on-site training.  Then, on Thursday, February 27th, we will be hosting a series of webinars.  During these courses, we will discuss data analytics, data management, and data warehousing solutions – some… Read more »

Feb 10, 2020