Post reply

Filtrate Report's Content based on Account

  • December 6, 2013 at 2:52 am

    #395952

    Goal:

    Filtrate the report's content in SSRS based on user's account or similiarww.

    When the user enter on (instance).com/reports and click on a report, the content should be filtrated based on the user's logging account in the report. User shall read his/her data, not others in the report.

    Problem:

    Is it possible to do it?

    Information:

    *Data source is SSAS.

    *using MDX coding in the report

    *I'm using SQl server 2008R2 standard edition.

  • December 6, 2013 at 3:29 am

    #1671427

    you must have some data / value to determine if this data belongs to the user or not.

    is there any column which maintain this data in your cude ?

  • December 6, 2013 at 3:32 am

    #1671428

    Probably the best way to achieve this would be by implimenting Role Based Security in your OLAP database. Here[/url] is a good article about it all.

    I'm on LinkedIn

  • December 6, 2013 at 4:07 am

    #1671445

    this is a good option, though if you need to see only a specific User entry data must be inserted in a new dimension to filter out the data. you can say to extension of the role.

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

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