Oracle said no logs such we have for Hyperion.
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!
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
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.