Custom Report Usage Metrics - Composite Model

[ebeery]

Hi all,

I just started digging into building Custom Usage Metrics reports and hit my first snag:

I'm connecting to the automatically-generated Report Usage Metrics dataset from Workspace A, and then layering on a couple SQL tables containing user-related dimensional data (approach generally described here)

I would like to publish this new "composite" model in Workspace B, and grant access to users who are NOT members of Workspace A.

Question is, how do I do this? I think they need access to the Report Usage Metrics, but I can't see how to even pull up that dataset to give them permissions. I would prefer not to have to give them access to the actual report that's being monitored, since they are consuming that via app.  I would also prefer not to give them access to Workspace A.

Here's a diagram of roughly what I am trying to achieve.  When I model in this state currently, all the visuals show up with errors (where as I, an admin of both Workspace A and B, can see the visuals with no issues in the Service).

[ebeery · Accepted solution]

So, for anyone who may stumble upon this thread in the future, I did find the solution, which was obvious in retrospect.

From the standard "Usage Metrics Report" report in Workspace A, go to "Manage Permissions", and then select the dataset instead of the report.

From there, users can be granted "Read, Build" access.  That, along with read access to the "Custom Usage Metrics Report" in Workspace B should allow them to view the composite report, without having access to the original report or being members of Workspace A.

[lbendlin]

"I'm connecting to the automatically-generated Report Usage Metrics dataset from Workspace A"

Indeed, that's your first mistake 🙂  Use the tenant audit logs instead.  The Report Usage Metrics datasets are ephemeral, with no guarantee whatsoever.  Not a reliable source.

[ebeery]

☹️@lbendlin I am not a tenant admin ☹️