Commands for HFM Maintenance

HFM Maintenance commands:

select count(*) from hfm_errorlog;

select count(*) from <Application Name>_task_audit;

To clear HFM userparams:

select * from <Application Name>_userparams where username = 'username@Native Directory'

delete from <Application Name>_userparams where username = 'username@Native Directory'


Thanks,
Mady

ODI - File to Planning Metadata

Thanks,

Mady

ODI - File to Essbase

Thanks,
Mady