locked
How to show dashboard per user login RRS feed

  • Question

  • Hi,

    We have a performance point dashboard with grid based on SSAS cube diplaying sales for all sales agents etc.

    We want to let each agent view this dashboard but only to see his own sales not all agents sales.

    I suppose I need to configure kerberoes and add some things to the SSAS cube but I don't have clear steps of how and what to do in order to achieve this.

    Please advice.


    Namnami

    Wednesday, July 10, 2013 11:05 AM

Answers

  • Here is a great post by Rod in regards to doing this exact scenario.

    http://www.rodcolledge.com/rod_colledge/2010/10/ssas-dynamic-security-kerberos-and-performancepoint.html

    If you are unable to do the Per User security setup and Kerberos another option is to explore the CustomData setup within SSAS and PerformancePoint.

    If everything is running on a single server you should be able to do Per User security setting and no Kerberos will be required, just depends on your server configuration.


    Dan English's BI Blog

    • Marked as answer by namnami Monday, August 5, 2013 7:55 AM
    Wednesday, July 17, 2013 2:46 AM