Is anyone aware of a way to track report utilization in BI FSM?
For custom reports my suggestion is to add a load action to each report. Update a counter perhaps in an SQL table in the EPM Staging database. For standard or protected content I have no suggestion.
Hi Ka$ey,
as John said, FSM is protected content, but for custom reports you can use this feature. I call it "Report Counter", which tracks the call/opening of a report (sometimes user, timestamp and settings are added). The implementation is based on an Application Engine Script, Staging Tables and an app studio report to explore the data. Data collection is done via on Load actions calling the "Runprocess()" formula.
Is this what you need?
Kr,Peter
Hi,
as suggested, I added two screenshots of a solution, to give an idea what is existing.
1) The OnLoad Action John described above and that is "generating" the data
2) Report to analyze the data
Kr,
Peter
I have sth similar as Peter, maybe not so tricky and powerful, but it does the necessary things:
Stored Procedure in SQL-Server:
create procedure [dbo].[sp_appstudio_log](@application nvarchar(50), @benutzer nvarchar(50), @bericht nvarchar(50)) as
begin
INSERT INTO [AppStudio_Log] (Benutzer, Zeit, Bericht, Berichtsname) VALUES (@benutzer, getdate(), @bericht, @application)
end
In this procedure special users like Admin can be filtered and not tracked in the table
Global Action in Report Catalog:
and in each report that should be tracked an action:
The only thing is not to forget to add the report action in each new report.
Hope it helps as well
Ralf
Hi Ralf, just for my understanding, this only works OnPremise, or? "My version should" be ready for both, Cloud and OnPremise. Kr, Peter
Thank you!
Thank you Ralf!
I am new to using Application Engine. Do you have a sample script that I could use to create this process?
