To hide the “component” level in the “Project” dimension from the report users try using data access roles to restrict eazyBI report users (user, viewer, dashboard_viewer) from expanding Projects dimension members to component level.
Martins / eazyBI
When this data access role is enabled for Project dimension - it seems the user is no longer able to view / edit Calculated members in this dimension as well.
This will break existing reports which use Calculated members (even just at the Project level). Is this expected?
Hi @KaeEe_Wong
I believe the resolved this in a direct conversation, but I’ll paste the solution here as well in case other eazyBI users have the same question.
Indeed, unfortunately, data access roles don’t work with the calculated members. We do have a backlog ticket on this.
However, here are 2 workarounds I can suggest:
Create a new account where you import only the Projects you want to conisder and in that account add the data access role in that particular account and don’t create aggregates in the Project dimension.
Another option is to create a new calculated field in import options that would show only Project name without components and there you can define the aggregated members.
2.1) In import options, tab Custom fields choose to add a new field.
2.2) Provide internal and display names for the field.
2.3) Select the data type string.
2.4) Mark option Dimension.
2.5) provide the custom JavaScript code to fetch the project name for each issue.
if (issue.fields.project.name) {
return issue.fields.project.name;
}
See picture below how the configuration for the calculated field should look like:
2.6) Save changes and select the new field for data import as dimension (in which you can then create the aggregates)
More details on calculated fields are here: Account specific calculated fields
Best wishes,
Elita from support@eazybi.com
