SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 SSRS
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sanghavi17389
Starting Member

India
26 Posts

Posted - 10/17/2012 :  05:11:32  Show Profile  Reply with Quote
I have SSAS cubes serving as a data source for my SSRS reports. Since SSRS and SSAS both use Windows authentication I have a constraint that whenever a person login to the system to view the reports he should only be able to see the reports catering to his dept.

for ex: Suppose there are two users userA and userB. userA operates in India and userB operates in China. I have created a mapping table in SSAS of user with operating place like this:

Table :

-----------------------------------------------------------------------

UserName OperatingPlace

-----------------------------------------------------------------------

userA India

userB China



Now what I want to achieve is that whenever userA logins into the system to view the SSRS reports he should be able to see only the records belonging to India in the SSRS report and when userB logins he should be able to see only the records belonging to China in the SSRS report

Q) Can this be achieved through SSAS or SSRS?

Q) Do I need to pass any kind of parameter to the datasource(SSAS cubes) from SSRS reports so that the data is filtered there in cubes itself?

Note: I am very new to SSAS and SSRS.

harshal sanghavi

navya krishna
Starting Member

India
39 Posts

Posted - 01/23/2013 :  01:46:27  Show Profile  Reply with Quote
Dear all,

i have one problem in ssrs.i need to display sales report customer wise [sales and budget and variance and variance percentage] from different databases but in single server.it will be there detailes in multiple databases.i need to display detailes in single report.could you please anyone help me.for example we are maintaining 2010,2011 databases so i need to display customer no,sales,budget,variance,variance percentage in single report ...

year from 2012 year to 2013 date filter 01-01-12..31-12-13

Customer No. Sales -2012 Budget-2012 Variance-2012 Variance %-2012 Sales -2013 Budget-2013 Variance-2013 Variance %-2013

i need details like this in one report using multiple databases.please anyone help me.


navya krishna katta
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3761 Posts

Posted - 01/23/2013 :  13:41:25  Show Profile  Reply with Quote
If all the databases are on the same server, you can create a query that uses 3-part naming to pull data from all the databases. That is to say, if you have database A and database B on the same server, you can query database B from database A like so:
SELECT col1, col2, col3 FROM [B].[dbo].[YourTableInDatabaseB]


If they are on different servers, you can again do something similar using 4-part naming, but you would need to set up linked servers.
Go to Top of Page

navya krishna
Starting Member

India
39 Posts

Posted - 04/12/2013 :  08:35:53  Show Profile  Reply with Quote
Dear All,

I have created one ssrs report i gave parameters to that report item no,item catagery code and branch name. it is working good.but i need to give multiple selection for that parameters......can anyone please help me....in that parameters option i applied right click and give option multiple selection but it is showing error incorrect syntax near",".....please solve the issue.

navya krishna katta
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3761 Posts

Posted - 04/12/2013 :  08:54:34  Show Profile  Reply with Quote
When you allow multiple parameters, SSRS sends a comma-separated list of parameter selections to the SQL Server. So you have to change your stored procedure or query to accept the comma-separated list. Post the stored procedure that you are calling to get the data with some sample input parameters that you want to send to it.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000