7 Replies Latest reply: Oct 4, 2013 4:56 PM by 931644 RSS

    Hyperion Planning security refresh is failing

    931644

      Hi,

       

      I have a planing app and when i try to refresh security from planning its fails and gives result that 'Failed to create Security Filters for the following users' and also i tired to export security using below query and which also did not give any result, I am having a Hyperion planning 11.1.1.3.

       

       

      SELECT A.OBJECT_ID AS GROUP_ID,

      A.OBJECT_NAME AS GROUP_NAME,

      D.USER_ID,

      E.OBJECT_NAME AS USER_NAME,

      D.ROLE,

      D.SYNC_PSWD

      FROM

      HSP_OBJECT A,

      HSP_OBJECT_TYPE B,

      HSP_USERSINGROUP C,

      HSP_USERS D,

      HSP_OBJECT E

      Where

      A.OBJECT_TYPE=B.OBJECT_TYPE

      AND A.OBJECT_ID=C.GROUP_ID

      AND C.USER_ID=D.USER_ID

      AND D.USER_ID=E.OBJECT_id

      AND B.OBJECT_TYPE ='6'

      ORDER BY A.OBJECT_ID

       

      Could anyone help me here.

       

      Thanks

      Pranav