[OBIEE Issue] Roll back Selection Security to be Enable

Recently, I was asked about a question that how to roll back the Selection Security to be Enable again.

It looks like on the Dashboard Properties page, you could change the Selection Security from Enable as shown by the graph above to the two new icons below which offer more flexibility of setting up the selection permission.

 The question is how to roll it back. It seems there is no way to roll it back to Enable on the same configuration page.

Solution: 

In order to roll back the change, you need to go to the catalog  Manager and navigate to Shared -> Shared folder name (eg: BI Framework) -> _Portal

Go under _portal folder and find the dashboard folder that the change was made. You would see there is one extra folder called _selections and  one extra attribute file _selections.atr

Delete these two items and restart BI Server. You would see the Enable link is restored back!

5 thoughts on “[OBIEE Issue] Roll back Selection Security to be Enable

  1. Claire,
    Regarding this post: I do not believe that the server restart is required (presentation catalog changes are instantaneous (or thinking about it in another way, done in “real-time”. There is no commit or rollback (so to speak.) Simply deleting the objects noted in your article above, then refreshing the General Properties page will do the trick.

    General: Thank you for taking your time to describe your findings with OBI. I will be returning to read your article on single sign on. We have just completed implementation of single sign on with OBIEE 11g (Solaris to Exchange) and found it to be quite complex and challenging.

    Regards,
    Dan

    1. Dan,thanks for your comments! I agree that it is not necessary to restart the server. I think you just need to reload metadata in the presentation service. I am actually doing the installation and configuration for OBIEE as well and find it quite complicated compared to 10g. You said that you have completed the single sign on for OBIEE 11g. Does it work smoothly in your env?

  2. wonderful piece of information, I had come to know about your blog from my friend Nandu , Hyderabad, I have read at least 7 posts of yours by now, and let me tell you, your website gives the best and the most interesting information. This is just the kind of information that I had been looking for, I’m already your RSS reader now and I would regularly watch out for the new posts, once again hats off to you! Thanks a ton once again, Regards,obiee online training

  3. An impressive share! I’ve just forwarded this onto a coworker who
    had been conducting a little research on this.
    And he in fact bought me dinner because I stumbled upon it for him…
    lol. So allow me to reword this…. Thank YOU for the meal!!

    But yeah, thanks for spending time to discuss this matter here on your internet site.

Leave a comment