Report builder usage

[SQLScholar]

Hey all,

One element of SSRS i have never used is report builder. I understand report builder works much better with SSAS than BIDS does (isnt difficult).

I have a request for a dashboard, but there are a lot of filters - making it an unpractical request. We are currently looking to the need for each filter at the moment. But it has led me to a question.

If i built an SSAS cube for this - with filters as dimensions. Then built the dashboard using Report builder. I am guessing the end users could then drag the measures into the filter area to changes the dataset? (so they just choose the filters they want?)

Am i on the correct lines here?

Also is it possible to do this without giving the end users access to save the RDL`s to the server. So basically we give them the dashboard without filters and they then can add filters but not save.

Thanks for any advice.

Dan

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

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------