Hi All
How do you control which fields are shown when you drill through into a cube and can this be linked to user rolls. For example would like to hide selected measures for different user groups (rolls)
Thanks
Malcolm
Hi All
How do you control which fields are shown when you drill through into a cube and can this be linked to user rolls. For example would like to hide selected measures for different user groups (rolls)
Thanks
Malcolm
Hello Malcolm -
That's a great question and I had to ask around a little.
The drill-through pulls a list of all the fields in the specific data warehouse table. There is no direct way to manage which fields get displayed.
On possibility would be to setting up security in the data warehouse and restrict specific fields from users. This might hide the fields (but I am not sure). If you did this, the hidden data would also be restricted when those users pull data from the data warehouse (i.e., the change would no impact JUST the drill-though).
So that you have the information: Here is the DWH security article.