Filtrate Report's Content based on Account

Question

Post reply

Filtrate Report's Content based on Account

akirajt

Right there with Babe

Points: 762
More actions
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.

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

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

Umer Akram SSC-Insane Points: 22209 More actions · Answer 1

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 ?

PB_BI SSCoach Points: 17463 More actions · Answer 2

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

Umer Akram SSC-Insane Points: 22209 More actions · Answer 3

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.