Reporting Services

[plsh]

Hi there,

Does anyone know how to create a report that accesses an OLAP cube on MS Analysis Server? I am currently doing this via OWC, which is really easy to do and manipulate. I have been told I need to investigate Reporting Services and see if they to can do it? I also have to have to allow for Analysis Server roles based on what user has logged onto the page.

Does anyone know if any of these are possible? If so, can you point me in the right direction please?

Thanks

 

[JayKusch]

Yes to both your questions if RS can be used in that fashion. Here is a link to get some info on it ...

http://www.microsoft.com/sql/reporting/default.asp

Thanks

J. Kusch

 

[plsh]

Hi Jay,

Thanks for pointing me in the right direction, would you be able to be a bit more specific as to where the article relating to my question may be. I have spent countless hours searching and can't find anything. I am not sure if I am looking in the wrong place, but can't seem to find anything.

Thanks