For example, I'd like to restrict access to maybe 100 of those columns for client A but only restrict 50 columns for client B.
Is there a way so that once I've restricted a column I can choose for that column only who the restriction is for, and it can be different restrictions for the following column?
Let me know if I've been clear or if you need more detail.
Thanks for sending in the query. I hate to be the bearer of bad news on this one, but unfortunately what you are after currently isn't feasible because you can't restrict a field at the view in the default org without effecting all of your client orgs. As you surmised, restricting a view field is basically all or nothing.
The closest thing that you could do to achieve something similar would be to use client reference id's as a source filter on your fields. This doesn't hide the column per say, but this method would allow you to restrict field values by client org.
If you are interested, here is forum article on the subject:
How to use the Client Reference ID as an access filter
In order to accomplish exactly what you are after, you are going to have import your default org view/reports and disable fields that you don't want a particular client org to use. Of course, this probably isn't practical as this defeats the purpose of managing content at the default org level. I just wanted to mention it as a possibility.
Anyway, I know this wasn't the information you were hoping for exactly, but I hope some of it is useful to you. Please feel free to let us know if you have any follow-up questions etc.
Have a great day!
The Yellowfin Support Team
Community Forum: www.yellowfinbi.com/YFForum.i4