4 Replies Latest reply on Jul 23, 2019 10:58 AM by Madhusudhan.Meesala

    How to find out windows id of users of editing FR reports?

    Madhusudhan.Meesala

      Hi all,

       

      If anyone faced please give some idea please.

       

      For example, we have one FR report and that report edited and saved by admin user.

      Admin user credentials are there with couple of people in team.

       

      They logged in workspace or fr studio and saved that report.

       

      Now how can we trace that user from any logs? I mean if we find that windows user id, then we can catch.

      If anyone faced or have an idea please reply me..

       

      Thanks,

      Mady

        • 1. Re: How to find out windows id of users of editing FR reports?
          Madhusudhan.Meesala

          Oracle said no logs such we have for Hyperion.

           

          Thanks,

          Mady

          • 2. Re: How to find out windows id of users of editing FR reports?
            iArchSolutions-Joe

            Hi Madhusudhan.Meesala - If you check out the

             

            The option to track Financial Report usage data was enabled by default and the information such as the name of the FR objects being accessed, the time stamp, the user accessing the object (etc.) is being logged in the FRLogging.log file. It was introduced in EPM 11.1.2 and 9.3.3.

             

            Usage tracking and logging for FR documents is kept on your FR Servers. It can be viewed in the FRLogging.logxxx file(s).  These Logs. are located on the X drive under a default path similar too:

             

            D:\Oracle\Middleware\epmsystemX\domains\servers\FinancialReports0 on the primary FR server

            D:\Oracle\Middleware\epmsystemX\domains\servers\FinancialReports1 on the secondary FR server (etc.)

             

            The information that can be observed is

            ·         Object name and type (report, book or batch)

            ·         Time/date stamp

            ·         User name

            ·         For each grid in a report:

            ·         Server, application and database name for the data source

            ·         POV information

            ·         Report execution time

             

            It would probably take some effort to turn those logs into usable formatting, since the format will be ODI.  Additionally, those logs are rolling, so you won't have a years worth of them to go off of. By default, Hyperion has not been set up to do anything more than its' default settings for this logging routine concerning Reports. There are at most 5 Rolling logs for Reports on each server. These 5 logs will contain a subset of information each and then roll to the next.  When the system reaches the 5th log, it deletes the oldest and creates a new one.  The span of time covered depends on how much the product is used. The more it is used the less time it will cover.

             

            Once you're good with this question please let us know by marking it answered so others in the community know you're all set.

             

            Any other questions, please don't hesitate to ask!

             

            -Joe

            • 3. Re: How to find out windows id of users of editing FR reports?
              JohnGoodwin

              The same information can be found in

               

              Financial Reporting (FR) - Usage Tracking For Reports And Books (Doc ID 1353965.1)

               

              Financial Reporting (FR) Usage Tracking - Report Access by Username (Doc ID 1947774.1)

               

              If it is a shared admin account (not sure from your post) is being used then the logs are probably not going to help.

              If an admin account is being shared then you either need to put trust into the users sharing the account or separate the accounts and then you would know who was accessing the report

               

              Cheers

               

              John

              • 4. Re: How to find out windows id of users of editing FR reports?
                Madhusudhan.Meesala

                Hi John,

                 

                Yes, It is shared admin account only. If it is an Utility or something executing from server then we can check server logs. Here the case is workspace we can access from any system which will be in network. Anyway, need to take care from next time.

                 

                Thanks,

                Mady