I want the BI Administrators only to be able to create analysis with Office Keys, while BI Authors, should be able to create analysis but not on Office Keys. They should be able to view the analysis created by BI Administrators that includes Office Keys.
I will create a new Subject Area at the Presentation Layer, create a new presentation table, where the relevant columns will be placed.
Those columns are part of the subject area at the BMM layer, so they have all the needed connections and joins from there.
I use the default permissions at the RPD.
Last step is at the Administration / manage privileges, at the web interface:
In my case, I need to set the "access within BI Answers" to the new subject area, to BI Administrators only (please be positive, grant the required access, using the deny option can cause problems).
Now BI Administrators can create analysis and projects with the new columns and all others can only view the results.
When BI Administrators creates an analysis now, they can use the keys:
Now when the BI Author attempts to Edit that analysis, it is prevented, but the data from the key column is available:
Same is correct in Visualization Projects.