REport/DAshboard Creator and last executed by

Questions & Answers
1

under usage statistics is it possible to get user who created and/or last executor?

2

Hi @knayak

You can see the user who has created the report from the Analyze tab. In the usage statistics, this information is currently not available. I created a task in our backlog to easily access users who interacted with reports (created, last updated, last used).

The most granular time level is a day. You can find the last date when the report was executed and all the users who did that on that day. For that, create a calculated measure.

Users who executed the report on the last date when report was opened:

Generate(
 Order(Filter(
  NonEmptyCrossJoin(
    [Time].[Day].Members,
    [User].[User].Members
  ),
  [Measures].[Report Executions]>0
), [Time].CurrentMember.StartDate, DESC).item(0).item(1),
 [User].CurrentMember.Name, ", ")

Measure to get the last execution date:

Order(
  Filter(
    DescendantsSet([Time].CurrentHierarchyMember,[Time].[Day]),
      [Measures].[Report Executions]>0
  ),
  [Time].CurrentHierarchyMember.StartDate,
  BDESC
).item(0).StartDate

Notice those are quite slow measures, please, use it on a small report set in a report.

Best
IlzeLA, support@eazybi.com