[Part 3] Anaplan Audit History Data in an Anaplan Reporting Model

With Anaplan Audit, Enterprise and Professional level Customers can track audit events that occur in their Anaplan tenant.

For the Anaplan Audit History project, we created a simple Anaplan reporting model and app to report on Anaplan Audit events in the Anaplan UX.

Customers may download and use the Anaplan Audit Model & App in their Customer tenant. The standalone Anaplan Audit model consists of a single Anaplan model with a small number of lists, modules, actions, processes, and user experience pages. Customers are able modify and maintain their Audit Model as they see fit.  

Once connected to the Python integration described in Part 2, Customers may schedule daily updates from the SQLite tables.  The model update process consists of a single Anaplan process that imports new audit data as text into a flat ‘Audit’ module. Lists are subsequently updated using standard Anaplan line item functions of FINDITEM and ISBLANK in conjunction with filtered module views such that only new Audit metadata is added to lists. SUM and COUNT functions sum over audit event frequencies by Audit activity category into an ‘Audit Report’ module. A ‘Refresh Log’ module is dimensionalized with a batch ID dimension that captures timestamps of every model update as well as record counts. These three modules are displayed on UX pages.

The Anaplan model is ~2MB at download, but will grow over time as the number of unique audit records increases based on the volume of activity in a Customer’s tenant. Customers may therefore need to periodically archive older audit data to maintain desired model size. 

Audit Logs are available to members of the Tenant Auditor role via either the Administration UI or via the Audit API. The Anaplan Tenant Admin assigns members of the Tenant Auditor Role. Audit logs are available through the Admin console or the REST API for 30 days.

Please reach out to your Anaplan Customer Success Business Partner or Representative to obtain your Model copy. The Anaplan Audit Model is not supported by Anaplan and is used at Customer’s own discretion.

See Part 1 and Part 2 of Anaplan Audit History Data in an Anaplan Reporting Model.