Category Archives: Data Warehouse

Data Warehouse Server Upgrade

On Friday, August 08, 2014, during an extended maintenance window (4:30-10:00 a.m.), Information Technology Services (ITS) will upgrade the Data Warehouse servers. This upgrade will affect the following services: Data Warehouse, iTwo, Data Dictionary, Data Warehouse password page, Data Warehouse status page, and iTwo Security Manager.

If there are no issues with the upgrade, the Data Warehouse will be available much sooner than 10:00AM. This alert will be updated once the upgrade is complete and the Data Warehouse is available.

For more information, please contact Business Intelligence Team (biteam@psu.edu).

New IBISFin Users Group File

To accommodate the recent changes to the PostDoc fringe rates, a new version of the IBISFin User Group file has been created. It is recommended that everyone updates to the newest version.

It’s available on the Q drive ( \\engrcdc\gen_info) in the folder called “IBIS Users Group”.  The file name is “Users Group V10 for Access 2007” and it is configured for use in Access versions 2007 and newer.  Drag it to your desktop or wherever you store the file.  You can’t open the file from its location on the gen_info drive; those files are Read Only.  

You may also need to relink to your data warehouse tables.

  • To relink your tables, open an Access file, go to the External Data tab, click the Link Table Manager Button, click the Select All button, and click OK.

DATA WAREHOUSE SPRING TRAINING SESSIONS

Training Available

We periodically offer ITS Data Warehouse training in our Lab in Hammond Building This training is FREE and is the same formal ITS warehouse training conducted at the University level.

Upcoming ITS Data Warehouse trainings:

Topic: iTwo 11g Queries: Advanced

Date: 5/15/14 & 5/16/14
Time: 1-5pm and 8:30am-12pm
Trainer: Nikke Moore
Location: 153J Hammond Building

If you would like to attend either of these sessions, please email training@engr.psu.edu. We will then send you the link to formally register with ITS.