Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sidhuonline
Starting Member
2 Posts |
 Posted - 2011-02-16 : 23:51:28
|
| I want to create SSRS reports where my data source is SSAS cubes and these reports will have the filtered data based on the user who has logged in.My requirement is that : I do have a mapping table where I have mapped the username with the userid.My fact table contains the userid's of various persons and the respective data allocated to them.1)How should I capture the username of the user who has logged in to the reports and pass it to the SSAS cubes?2)How to filter the data from the cubes based on the user login from cubes?Its urgent. Pls helpA Sidhu |
|
|
theboyholty
Posting Yak Master
226 Posts |
Posted - 2011-02-22 : 11:59:12
|
| When defining your parameters, you can set a default parameter which can be mapped to the Globals list and in here you can use UserID to get the ID of whoever is running the report.---------------------------------------------------------------------------------http://www.mannyroadend.co.uk The official unofficial website of Bury Football Club |
 |
|
|
|
|
|
How to create filtered SSRS reports?