BookmarkSubscribeRSS Feed


Started ‎11-30-2011 by
Modified ‎10-05-2015 by
Views 853

IT Resource Management (ITRM) aggregation tables are a collection of accumulated statistics that are organized as summary or simple as specified in aggregation transformations. 


The ITRM aggregation transformation creates and updates the majority of all ITRM metadata objects and physical SAS tables and does so with each and every run of the Aggregation jobs that contain these transformations.  As such, this document proposes a best practice of which the physical tables created by the aggregation transformation be backed up prior to running the aggregation job such that they are available for restoration to quickly recover from the failure of any run of an Aggregation transformation; thus avoiding a more time consuming restoration of an IT data mart.  The document introduces a tool for backing up and restoring physical aggregation tables named the ITRM Backup And Restore Facility for Physical Aggregation Tables.

Version history
Last update:
‎10-05-2015 02:56 PM
Updated by:



SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team.

Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!

Submit your idea!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Tags