The Decision Stream or Data Manager ETL tool has many built in capabilities that assist the data warehouse programmer in generating the data needed by the business.
Data about data is called meta data. Meta data is often housed in a data dictionary. The data dictionary is one of the primary needs of a successful BI team.