Thanks, i had to add the linked server prefix as well. Moreover, i also had to add square brackets for some reason for it to finally work...
[server].[database].[owner].
With regards to the cube, what i meant was, is it required for building reports using SSRS. Would i get the same level of performance if i had the data for fact tables and dimensions residing on SQL server(instead of SSAS).
I basically need to get some reports out soon.
I plan to read some more whitepapers on this from the MS site ..after im done inserting into the staging area, so yeah i will be looking more deeply into it. Thanks for your suggestions so far ...!
Happy Monday..!