April 26, 2009 at 10:01 am
Hi,
I need to configure SSRS reports where data will be coming from RDBMS & SSAS. One filter of the report will be set to consume data from RDBMS whereas rest of the filters and report will show data from SSAS cubes.
Now, I have few questions -
1. Is multiple data sources allowed in single SSRS report?
2. If yes, will changing the RDBMS filter will change data in the report where data is coming from SSAS automatically?
3. Can I hide filters (dimensions) in SSRS report and show RDBMS filter instead of that and show report to the user where drill down / slicing dicing is not based on that filter? To make it more clear, Let R1 is RDBMS filter. S1, S2 & S3 are SSAS filters. I want S1 to be hidden and R1, S2 & S3 to be shown on the reports. There will be no slicing and dicing based on R1 whereas we may or may not do it for S3 or S2.
Your prompt response will be really appreciating as I am very new to SSRS.
Thanks,
Santosh
April 26, 2009 at 1:14 pm
You can utilize multiple data sources and use both relational and multi-dimensional sources for these. Just remember that you will need to format the parameter values properly when passing them to an SSAS source or you will have to setup your query appropriately to accept the values.
So values in SSAS will typically need to be in formats like [Product].[Category].&[1] for example if you look at the Adventure Works DW sample and this would be the value for the Bikes cateogry in the product dimension.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 27, 2009 at 5:20 pm
Hi,
Thanks a lot for your prompt response. I got your point - MDX will not accept absolute values rather it will be relative (hierarchical). I'll try to implement it.
Thanks,
Santosh
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply