Single Sign On Authentication Failed. You Are Not Authorized To Use System, Contact Your Administrator

While accessing SSO enabled Workspace, we were facing the below issue, as we need to allow SSO in Registry.

Solution:
- To update a component property, go to EPM_ORACLE_INSTANCE/bin and run the following command:

- epmsys_registry updateproperty WORKSPACE/LOGICAL_WEB_APP/@AllowDirectLogonAfterSSO true;

Thanks,

Mady

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