View Metadata

In IBM® Controller, it is possible to trace selected metadata regarding updates.

This function complies with, for example, the Sarbanes-Oxley Act of 2002, SOX. The purpose is to protect shareholders from accounting irregularities, by ensuring accuracy, consistency, transparency, and timeliness of financial results and reporting. By analyzing the metadata, you can trace which user did what and when. The time stamps in the system audit log originates from the clock on the database server.

You can trace the following types of data:

  • When the system audit log is enabled/disabled
  • Inserted values
  • Deleted values
  • Updates
  • User

Metadata is recorded for the following menus:

  • Account Structures
  • Company Structures
  • Extended Dimension Structures
  • Currency Rates
  • Historical Rates
  • Control tables for automatic journals
  • Excluded automatic journals in consolidation types
  • Intercompany Profit Margins
  • Security Groups
  • Users and Installations
  • Import Structures
  • Import Specifications
  • Lookup Tables
  • Shareholdings and Investments in Group Companies