Report security in business intelligence? RRS feed

  • Question

  • Hi All,

    I had deploy a report under business intelligence and required the specific domain author can only able to access the report which falls under there domain only due to security reason.

    For example : Suppose there are two domains, DomainA and DomainB . Under DomainA there are 2 projects abc & xyz and under DomainB there is one project abcdef. I have deployed the report under BI.Now, I required when DomainA access the report link he/she will only able to see project(s) which are falls under there domain only.

    Thanks in advance!

    Anuranjan Prasad

    Wednesday, August 3, 2011 7:11 PM

All replies

  • Hello Anuranjan,

    What do you mean by Domain? Are you classifying the Projects based on some criteria , Is that similar to Program/Departments? If yes , You can build a SQL query which checks the Windows account of user & Departmnet, filter the data.

    Thanks, Amit Khare |EPM Consultant| Blog:
    Thursday, August 4, 2011 5:19 AM
  • Hi Amit,

    If in a department there are 4 project managers (A, B, C, D) who all combined created 10 projects respectively. Suppose project manager “A” has been created 3 projects.

     Now, when project manager "A" ran the report through BI he/she should only able to see 3 created projects!



    Wednesday, August 17, 2011 9:30 AM
  • Hello Anuranjan ,

    You can build the query which checks the ProjectOwner Windows account (from Reporting database view : MSP_EPMResourceUserView) & filter data based on the user windows account with ProjectOwner Windows account.

    Thanks, Amit Khare |EPM Consultant| Blog:
    Wednesday, August 17, 2011 11:50 AM
  • Hi Amit,

    Does it return back the current login user account details?




    Thursday, August 18, 2011 2:38 PM
  • Hi Amit,

    Please correct me if I am wrong!

    To achieve current resource I need to create a button through PSI on BI to get the current resource acccount?

    Thanks & Regards

    Anuranjan Prasad

    Monday, August 22, 2011 5:51 PM
  • Hi Anuranjan,

    User!UserID property is available for this purpose.  It will always give you the user name of the person who is running the report. so no need to create a button through PSI. It shows Domain\USername  which you can filter based on projectOwnerWindows NT account from Reporting database view : MSP_EPMResourceUserView

    Hope that helps.

    Thanks, Amit Khare |EPM Consultant| Blog:
    Tuesday, August 23, 2011 9:31 AM