SMART Messages

SMART Logo

 
DATE June 28, 2012
Module DW
Subject Update for Business Intelligence/Data Warehouse - GL- Commitment Control Activity Log subject area users:

Update for Business Intelligence/Data Warehouse – GL- Commitment Control Activity Log subject area users:

We are pleased to inform you that the GL- Commitment Control Activity Log subject area is now available. The subject area has been down in order to update the data and implement an enhancement.

  • The data update will allow the Data Warehouse data to remain in sync with SMART production data.
  • A delete job enhancement has been added to the subject area in order to remove rows from the Data Warehouse that have been deleted/updated in the SMART system.

To assist you in creating requests in the Commitment Control Activity Log subject area we have created a data mapping spreadsheet for this subject area. The document identifies the source tables and fields for the columns in this subject area. The document can be found on the new Resources & Help tab on the home dashboard in the data warehouse. The document is titled ‘Commitment Control Activity Log – Data Warehouse to SMART/SHARP Mapping’ and is in the Data section of the Resources & Help page.

We are finalizing our testing of the GL-Commitment Control Budget Balances Subject area and hope to still have it available by the end of this week.

If you experience any problems or have questions about the Commitment Control Activity Log subject area, log a Service Desk Ticket and choose the Category of ‘Data Warehouse’ and then select from the available sub categories. The ticket will be routed to the DW/BI team.

Thank you for your patience while we have fixed these subject areas.

Business Intelligence/Data Warehousing Team,

Dept. of Administration

 

 

Quick Links

Search the Site

Contact Us

Send us an email

Sign Up

Sign up for the SMART InfoList