Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Custom Report Usage Metrics - Composite Model

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).

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

     

     

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    "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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      ☹️lbendlin I am not a tenant admin ☹️

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.