Hi,
I have cubes where I have to create custom views that are very fine in detail and I have to create a lot of them for different user classes. I have also noticed that if I clean house on a dimension, the custom view gets destroyed if I have excluded certain categories in the custom view. Does anyone have a macro that can accept a user class, a category or list of categories, a dimension and then go in and exclude a user class from having access to any categories in the dimension not in the list of categories? I am usually excluding at the lowest level in a dimension.
Thanks in advance,
Paul
I have cubes where I have to create custom views that are very fine in detail and I have to create a lot of them for different user classes. I have also noticed that if I clean house on a dimension, the custom view gets destroyed if I have excluded certain categories in the custom view. Does anyone have a macro that can accept a user class, a category or list of categories, a dimension and then go in and exclude a user class from having access to any categories in the dimension not in the list of categories? I am usually excluding at the lowest level in a dimension.
Thanks in advance,
Paul