Is possible to create dynamic reports based on cubes?

Hi,

I would like to know if is possible to create dynamic reports based on cubes. What i mean is,after creating a cube with a couple of dimensions and measure if is there any way to give the normal users on the report manager or report builder the freedom to choose their own dimensions/measure so they can output the report with the choosen criteria.

Thanks.

I thought you could do that with report builder, but I never use that feature anyway... One thing you can do is have users connect to the cube via Excel. In excel 2003, go to Data->Import External Data->New Database Query. Then, they can drag and drop cube dimensions and measures into an excel style pivot table. It is very easy to use. I've heard the excel 2007 version has more features so you may look at that. -Joe
|||

It's almost imposible to achieve it directly in SSRS. I would recommend Proclarity, Excel 2007, Excel 2003 or other 3rd party products (Business Objects Voyager). Report Builder may be used as well, just the result is always limited to the chosen layout, parameters - simply the report content cannot be changed.

J.

|||

I have done my question before it was given me permissions for a connection to generate model in report manager and after sort out that issue and opening report builder i could open the data source related with cube. But now i have other situation that i need to confirm: Why the hierarchies created on the cubes and many of the attributes arent present on the model?Is any workaround that can be done?

In the meantime i tried to connect to the cube from the excel(the version installed is 2002) and i dont have the information about the data source on the OLAP Cube option even if i tried to create a new server and connect to the server. Any idea?

Thanks.