we provide all employees with statistics on their Logged Hours in Jira, to get them into a feedback loop. At the same time, we don’t want to allow all users to look into other user’s data. That’s why I currently restrict access to all User-Dimensions to a special user group, and specify “no access” as default access policy.
Unfortunately, this leaves me in a situation where I cannot provide the report anymore. I tried specifying a Custom Measure, where I restrict the “Hours spent” to the LoggedBy/CurrentUser() using a formula - but that only works for users that have access to the dimension.
Defining a new calculated member “CurrentUser” in the LoggedBy dimension does not work either, as it does not show up in the configuration page of the “Data Access Roles”.
CurrentUser() is a function that can be used for calcualtions but not for data access roles.
If yuo want to provide some analytics for users and restrict their options to see data, consider granting these users the “Dashboard viewer” role (see documentation: Account users). This way, they will be able to see only reports prepared and published in dashboards and will have limited options (set by you) on what they can do with those reports.
Yuo can create a calcauted measure to show the logged hours of the current users.
You can also add annotations to the calcauted measures that disable the option to drill across other dimensions or drill into details: Calculated measures and members
If you choose to publish reports on Jira dashboards, there are more options to limit user actions: Publish in Jira dashboards.
If you have difficulty managing data access roles, you might reconsider how eazyBI accounts are created and managed in your instance and introduce the template accounts.
Here is video with our suggestions on account and user management: