Hyperion Planning Application (HPB) Audit Options Explaination


All audit records for Hyperion Planning are stored in HSP_AUDIT_RECORDS table of Planning schema used in the application creation.

Audit Option Name – Query to check

Data Form Definition – select * from hsp_audit_records where property like ‘Audit Form Folder’ order by time_posted desc;

Clear Cell Details – select * from hsp_audit_records where property like ‘Audit Clear Cell Details’ order by time_posted desc;

Group Administration – select * from hsp_audit_records where property like ‘Audit Groups’ order by time_posted desc;

Users Administration – select * from hsp_audit_records where property like ‘Audit Users’ order by time_posted desc;

Alias Table Administration – select * from hsp_audit_records where property like ‘Audit Alias Table Changes’ order by time_posted desc;

Launch Business Rules – select * from hsp_audit_records where property like ‘Audit Business Rules’ order by time_posted desc;

Dimension administration – select * from hsp_audit_records where property like ‘Audit Dimension Members’ order by time_posted desc;

Copy Version – select * from hsp_audit_records where property like ‘Audit Copy Version’ order by time_posted desc;

Approvals – select * from hsp_audit_records where property like ‘Audit Workflow’ order by time_posted desc;

Data – select * from hsp_audit_records where property like ‘Audit Data’ order by time_posted desc;

Data Form Folder Administration – select * from hsp_audit_records where property like ‘Audit Forms’ order by time_posted desc;

Security – select * from hsp_audit_records where property like ‘Audit Security’ order by time_posted desc;

Copy Data – select * from hsp_audit_records where property like ‘Audit Copy Data’ order by time_posted desc;

Task List – select * from hsp_audit_records where property like ‘Audit Task List’ order by time_posted desc;

Offline – select * from hsp_audit_records where property like ‘Audit Offline’ order by time_posted desc;

Thanks,
~KKT~

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s