March 9, 2011 at 6:28 am
Hi All,
Our client needs a reporting tool which allows the end-users to create adhoc reports
Backend is OLAP (SSAS) cube.
I tried Report Builder in SSRS. But it cannot use SSAS cube.
Please suggest a reporting tool which can use SSAS cube as back-end and allows the users to create adhoc reports.
Thanks.
March 9, 2011 at 11:05 am
AFAIK Report Builder can be used to build ad hoc reports using a cube as an initial data source.
1. Create and publish a Report Model from an SSAS Cube: http://msdn.microsoft.com/en-us/library/ms345292(v=SQL.105).aspx
2. Publish the Report Model (see Lesson 5): http://msdn.microsoft.com/en-us/library/ms167048.aspx
3. Use Report Builder to create reports from the Report Model. http://msdn.microsoft.com/en-us/library/dd220475.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 9, 2011 at 12:21 pm
What version of Report Builder are you using?
Report Builder 3.0 surely supports SSAS:
http://technet.microsoft.com/en-us/library/dd220525.aspx
Another ad-hoc reporting tool is Excel. Laugh all you want, it is still the most used BI tool out there.
If the above aren't good alternatives for you, you can also consider Cognos Analysis Studio.
But I'll guess Report Builder/Excel will be cheaper.
(and there is also Qlickview, Tableau, Targit et cetera)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 9, 2011 at 12:25 pm
Another link...MDX support in Report Builder: http://msdn.microsoft.com/en-us/library/dd220489.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 9, 2011 at 9:17 pm
Thanks Koen Verbeeck and opc.three
I appreciate your help.
Regards,
Suresh
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply