Post reply

Prevent "Show Details" in Excel

  • February 10, 2015 at 2:04 pm

    #150326

    Does anyone know if there is an option in SSAS to prevent the "show details" sheet from showing in excel when a user double clicks a specific cell.

    Double clicking this cell opens up a new sheet with PKs and FKs all not user friendly to the user and I wanted to disable this option.

    Thanks

  • February 10, 2015 at 4:09 pm

    #1776787

    ttdeveloper (2/10/2015)

    Does anyone know if there is an option in SSAS to prevent the "show details" sheet from showing in excel when a user double clicks a specific cell.

    Double clicking this cell opens up a new sheet with PKs and FKs all not user friendly to the user and I wanted to disable this option.

    Thanks

    You should be able to change the properties of the role, to not allow cube drill-through. You will see "Local Cube/Drillthrough Access" in the "Cube" section of a role's permissions.

  • February 10, 2015 at 7:42 pm

    #1776808

    Martin

    This definitely helps. So I guess I need to be setting permissions to None to stop all drilling into the details.

    I've read some articles on being able to configure actions on drilling so ill configure some action for drilling at a later stage. In the meantime, thanks again

  • February 11, 2015 at 9:12 am

    #1776980

    ttdeveloper (2/10/2015)

    Martin

    This definitely helps. So I guess I need to be setting permissions to None to stop all drilling into the details.

    I've read some articles on being able to configure actions on drilling so ill configure some action for drilling at a later stage. In the meantime, thanks again

    Something else you may want to consider, is to create Perspectives. It is the SSAS equivalent of a view, and will allow you to expose whichever attributes you like.

    It's a great way to control what other people see, but make sure you do this last as any change to your cube may affect all Perspectives as well.

  • February 11, 2015 at 1:43 pm

    #1777062

    Interestingly enough, this was one the questions I was asked during the demo of this cube.

    Still have a few enhancement changes to make with "Can you add this or can you add that?" requests.

    Thanks again for the tip

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply