To find out if your credit union is currently using a Data Warehouse, you can try any of the methods explained below.

Method 1: Ask the Asterisk Intelligence Team

Contact the AI team at ai@cuanswers.com and we'll be happy to tell you if your credit union has been set up for a data warehouse.

Method 2: Library Dashboard Tool 

Use Tool #1980 Library Dashboard and see if the 'Library' lookup has the DW code (for data warehouse) available in this list.  If present, then yes, you do have data warehouse. If not, you do not have data warehouse for your credit union at this time.

Method 3: Query the System Control File

Using Tool #100 CU*BASE Report Builder (QUERY) you can query the SYSCTL file in your credit union's FILExx library, where xx is your credit union's two character CUID. 

Using the Choose Records feature, enter record selection information as follows: 
           SYSCTL      EQ      'LIBDW'   


 
Once you have done that then use the Preview Report button at bottom of the screen to see if your credit union has this setting in your configuration. If an entry is there, then yes, you have data warehouse; if it doesn't bring any record up to be displayed you do not have data warehouse.