3 Replies Latest reply: Jan 1, 2013 8:05 AM by JohnGoodwin RSS

    Security HSS Essbase

    hyperion start
      Gurus,
      Since I have inherited this system and since there is no documentation regarding security in the environment, for example GROUP security, User security, etc in planning, hss or essbase, is there any way I can view how security has been set up in the environment. Is there any way of getting an EXCEL-LIKE file in Shared Services or essbase/planning? Does importsecurity help in this case?
      Please suggest.
      Thanks
        • 1. Re: Security HSS Essbase
          JohnGoodwin
          You can generate provisioning reports in Shared Services or you could export the provisioning using LCM, this will show you the provisioning applied in Shared Services, for Planning access permissions they are held within the planning application so you could use LCM to extract them or the exportsecurity utility, all these exports will be to flat files which you could open in Excel.

          Cheers

          John
          http://john-goodwin.blogspot.com/
          • 2. Re: Security HSS Essbase
            hyperion start
            Thanks John for your suggestion.
            When I use the ExportSecurity command, such as ExportSecurity.cmd /A=APPLICATIONNAME. /U=USERNAME/, S_USER=HARRY for example, it gives a txt output right?
            Is there anyway of getting in different format or are there any other options so as to group users by groups or anything like that?
            If I wanted to export only the planning security for ecample dimension security or version security what method would I use/
            thanks
            • 3. Re: Security HSS Essbase
              JohnGoodwin
              What is wrong with text file output as you can do pretty much what you want with it in this format.

              Alternatively you could write custom SQL to extract the information you require, there is an example here - https://blogs.oracle.com/pa/entry/exporting_security_out_of_hyperion

              Cheers

              John
              http://john-goodwin.blogspot.com/